Question: Use the database shown in Figure P3.1 to answer Problems 11-13. Table name: EMPLOYEE Database name: ChO3 StoreCo EMP CODE EMP TITLE 21-May-84 Greenboro Loie

 Use the database shown in Figure P3.1 to answer Problems 11-13.

Use the database shown in Figure P3.1 to answer Problems 11-13. Table name: EMPLOYEE Database name: ChO3 StoreCo EMP CODE EMP TITLE 21-May-84 Greenboro Loie umperstro Jenrie Renselaer Cary Jchnsson Eizabeth 31-62 19-Apr-5 06-Mar-56 21-Oct-7 08-Sep-74 1 M 12 M Broderick Ton 15 M 16 M 17 Ms 18 M Archialo Barry 12-Now-70 Rosenberg AndrewD 20 M 21 Ms 06-Mar-70 11-Dec-74 Table name: STORE EMP CODE Access Junction 2 Database Cone 003455 76 421987 39 906783 22 94458858 Tuple Charge Atribvte Aley 5 Prindey Key Point Table name: REGION 1 East West FIGURE P3.1 The Ch03 StoreCo Database Tables 11. (P3.1) For each table, identify the primary key and the foreign key(s). IFa table does not have a foreign key, write None to indicate no FK. (3 points 1 each table) 12. (P3.2) Do the tables exhibit entity integrity? For each table answer yes or no and then explain your answer. (3 points 1 each table) 13. (P3.3) Do the tables exhibit referential integrity? For each table answer yes or no and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key. (3 points-1 each table)

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!