Question: Use the database shown in Figure P3.17 to answer Problems 17-23. For each table, identify the primary key and the foreign key(s). If a table

Use the database shown in Figure P3.17 to answer Problems 17-23.

Use the database shown in Figure P3.17 to answer Problems 17-23. For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. Do the tables exhibit entity integrity? Answer yes or no, and then explain your answer. Do the tables exhibit referential integrity? Answer yes or no, and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key. Identify the TRUCK tables candidate key(s). For each table, identify a superkey and a secondary key. Create the ERD for this database. Create the relational diagram for this database

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

MIS 560 Database Management Systems-Assignment Use the database shown in Figure P3.17 to answer Problems 17-23. 17. For each table, identify the primary key and the foreign key(s). If a table does...

MIS 560 Database Management Systems- Assignment Use the database shown in Figure P3.17 to answer Problems 17-23. 17. For each table, identify the primary key and the foreign key{s). If a table does...

Table name: TRUCK Primary key: TRUCK NUM Foreign key: BASE_CODE, TYPE_CODE Database name: Ch03_TransCo Table name: BASE Primary key: BASE_CODE Foraian kexv nono Table name: TYPE Primary key:...

PROBLEMS 8, 11, 13, 14, 15, 20, 22 ONLY. THANK YOU! ATABASE TABI Database name: O03-StoreCo nna Table name: STORE 96763 22 Table nae: REGION Use the database shown in Figure P3.1 to answer Problems...

106 Problems Use the database shown in Figure P3.1 to answer Problems 1, 2, 3, 4, 5, 6, 7, 8 and 9. Figure P3.1 The CH03_Storeco Database Tables Table name: EMPLOYEE Database name: Ch03_StoreCo EMP...

Use the database shown in Figure P 3 . 1 7 to answer Problems 1 7 , 1 8 , 1 9 , and 2 2 1 7 . For each table, identify the primary key and the foreign key ( s ) . If a table does not have a foreign...

Use the database shown in Figure 3 to answer Problems 8-11. Table name: TRUCK Primary key: TRUCK_NUM Database name: Ch03_TransCo Foreian kevs: BASE CODE. TYPE CODE Table name: BASE Primary key:...

Table name: EMPLOYEE Database name: Ch03_StoreCo EMP CODE EMP TITLE BMP LNAME EMP_FNAME EMP_INTIAL EMP DOB STORE CODE 1 Nr. Wiliamson John W 21-May-84 2 MS. Ratula Nancy 09-Feb-89 3 Ns. Greenboro...

Database: chapter 3 a. Using the tables in diagram P3.1 (page 110), answer questions 1, 3, 4, 5, and 6. Use the database shown in Figure P3.1 110 Part 2 Design Concepts Problems FIGURE P3.1 THE...

Use the database shown in Figure P3.1 to answer Problems 1, 2, 3, 4, 5, 6, 7, 8, and 9. Figure P3.1 The Ch03_StoreCo Database Tables Table name: EMPLOYEE EMP_CODE EMP_TITLE EMP_LNAME EMP_FNAME...

The comparative balance sheet of Amelia Enterprises, Inc. at December 31, 2010 and 2009, is as follows: Additional data obtained from the income statement and from an examination of the accounts in...

Your company is considering to buy a new machine that can yield the following (year-end) net benefits: Year 1 - $3,000; Year 2 - $4,000; Year 3 - $5,000; Year 4 - $6,000. At the end of Year 4 the...

For married taxpayers filing a join return in 2 0 2 4 , at what AGI level does the phase - out limit fro contribuitions to Qualified Tuition Progeams ( Section 5 2 9 plans ) start

AR enhances the real world by adding digital elements to it Question 7 options: True False

How are custom calculations developed that will refer back to columns in the Pivot Table on the same Excel worksheet?

What do the Length of Service and Length of Service Earnings Quotients indicate with reference to Female versus Male Wage and Job Progression in respect to Length of Service?

How do Excel Pivot Tables handle data from non OLAP databases?