Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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. 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started