All Matches
Solution Library
Expert Answer
Textbooks
Search Textbook questions, tutors and Books
Oops, something went wrong!
Change your search query and then try again
Toggle navigation
FREE Trial
S
Books
FREE
Tutors
Study Help
Expert Questions
Accounting
General Management
Mathematics
Finance
Organizational Behaviour
Law
Physics
Operating System
Management Leadership
Sociology
Programming
Marketing
Database
Computer Network
Economics
Textbooks Solutions
Accounting
Managerial Accounting
Management Leadership
Cost Accounting
Statistics
Business Law
Corporate Finance
Finance
Economics
Auditing
Ask a Question
Search
Search
Sign In
Register
study help
computer science
database concepts
Questions and Answers of
Database Concepts
What string function should you use to list the first three characters of a company’s EMP_LNAME values? Give an example, using a table named EMPLOYEE.
What Oracle function should you use to calculate the number of days between your birthday and the current date?
What MS Access/SQL Server function should you use to calculate the number of days between the current date and January 25, 1999?
Given the employee information in Question 19, what is the query output for the MINUS query? (List the query output.)Data from Question 19.Suppose that you have two tables, EMPLOYEE and EMPLOYEE_1.
Given the employee information in Question 19, what is the query output for the INTERSECT query? (List the query output.)Data from Question 19.Suppose that you have two tables, EMPLOYEE and
Given the employee information in Question 19, what is the query output for the UNION ALL query? (List the query output.)Data from Question 19Suppose that you have two tables, EMPLOYEE and
Suppose that you have two tables, EMPLOYEE and EMPLOYEE_1. The EMPLOYEE table contains the records for three employees: Alice Cordoza, John Cretchakov, and Anne McDonald. The EMPLOYEE_1 table
What does it mean to say that SQL operators are set-oriented?
What are the three types of results a subquery can return?
What is the difference between the COUNT aggregate function and the SUM aggregate function?
What is a recursive join?
How would you describe a condition in which one attribute is dependent on another attribute when neither attribute is part of the primary key?
Why is a table whose primary key consists of a single attribute automatically in 2NF when it is in 1NF?
What is a partial dependency? With what normal form is it associated?
When is a table in 3NF?
Global Unified Technology Sales (GUTS) is moving toward a “bring your own device” (BYOD) model for employee computing. Employees can use traditional desktop computers in their
Tiny College wants to keep track of the history of all administrative appointments (date of appointment and date of termination). The Tiny College chancellor may want to know how many deans worked in
Is it possible for a book to appear in the BOOK table without appearing in the PRODUCT table? Why or why not?
What is a disjoint subtype? Give an example.
Use the following description of the operations of the RC_Charter2 Company to complete this exercise.¢ The RC_Charter2 Company operates a fleet of aircraft under the Federal Air
Luxury-Oriented Scenic Tours (LOST) provides guided tours to groups of visitors to the Washington D.C. area. In recent years, LOST has grown quickly and is having difficulty keeping up with all
Create a Crow’s Foot notation ERD to support the following business operations:• A friend of yours has opened Professional Electronics and Repairs (PEAR) to repair smartphones, laptops, tablets,
What is a recursive relationship? Given an example.
Create the relational diagram.Use the database shown in Figure P3.24 to answer this Problem. ROBCOR is an aircraft charter company that supplies on-demand charter flight services using a fleet of
Create the ERD.Use the database shown in Figure P3.24 to answer this Problem. ROBCOR is an aircraft charter company that supplies on-demand charter flight services using a fleet of four aircraft.
Use the database composed of the two tables shown in Figure Q3.18.What would be the conceptual view of the INDEX table that is described in question 26? Depict the contents of the conceptual INDEX
Use the database composed of the two tables shown in Figure Q3.18.Suppose you wanted quick lookup capability to get a listing of all plays directed by a given director. Which table would be the basis
Use the database composed of the two tables shown in Figure Q3.18.Identify the primary keys.Figure Q3.18. Table name: DIRECTOR DIR_NUM DIR_LNAME DIR_DOB 100 Broadway 12-Jan-65 18-Nov-53 101
Using the tables in Figure Q3.13, create the table that results from MACHINE DIFFERENCE BOOTH.Figure Q3.13: Database name: Ch03_VendingCo Table name: MACHINE MACHINE_PRODUCT MACHINE_PRICE Table name:
Create the table that results from applying an INTERSECT relational operator to the tables shown in Fig Q3.13.Figure Q3.13: Database name: Ch03_VendingCo Table name: MACHINE MACHINE_PRODUCT
Write the relational algebra formula to apply an INTERSECT relational operator to the tables shown in Figure Q3.13.Figure Q3.13: Database name: Ch03_VendingCo Table name: MACHINE MACHINE_PRODUCT
Create the table that results from applying a UNION relational operator to the tables shown in Fig Q3.13Figure Q3.13: Database name: Ch03_VendingCo Table name: MACHINE MACHINE_PRODUCT MACHINE_PRICE
Write the relational algebra formula to apply a UNION relational operator to the tables shown in Figure Q3.13.Figure Q3.13: Database name: Ch03_VendingCo Table name: MACHINE MACHINE_PRODUCT
Create the table that would result from πstu_code,dept_code(student ⋈ professor).
Create the table that would result from πstu_code(student).
Write the business rules that are reflected in the ERD shown in Figure P2.17.
Describe the relationships (identify the business rules) depicted in the Crow’s Foot ERD shown in Figure P2.13.
Create the UML class diagram that reflects the entities and relationships you identified in the relational diagram.
Create the basic Crow’s Foot ERD for Tiny College.
Use the contents of Figure 2.1 to work on this problem.Given the business rule(s) you wrote in Problem 1, create the basic Crows Foot ERD. Table name: AGENT (first Six attribute AGENT
Use the contents of Figure 2.1 to work on this problem.Write the business rule(s) that governs the relationship between AGENT and CUSTOMER.FIGURE 2.1 Table name: AGENT (first Six attribute AGENT CODE
What is a relationship, and what three types of relationships exist?
How would you model Question 6 with an OODM?
Why is an object said to have greater semantic content than an entity?
Consider the scenario described by the statement “A customer can make many payments, but each payment is made by only one customer” as the basis for an entity relationship diagram (ERD)
Using your schools student information system, print your class schedule. The schedule probably would contain the student identification number, student name, class code, class name,
What is metadata?
Explain the differences between data, information, and a database.
What is structual independence, and why is it important?
Define each of the following terms:a. Datab. Fieldc. Recordd. File
Showing 600 - 700
of 650
1
2
3
4
5
6
7