Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None to indicate no
For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None to indicate no FK
(P.2) Do the tables exhibit entity integrity? For each table answer yes or no and then explain your answer
(P.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.
Table name: EMPLOYEE Database name: Ch03_Store Co EMP_CODE EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP_DOB STORE_CODE 21-May-64 09-Feb-69 02-Oct-61 01-Jun-71 23-Nov-59 25-Dec-65 31-Jul-62 10-Sep-68 19-Apr-55 06-Mar-66 21-Oct-72 08-Sep-74 25-Aug-64 25-May-66 24-May-64 03-Sep-60 12-Nov-70 24-Jan-71 03-Oct-68 06-Mar-70 11-Dec-74 1 Mr. 2 Ms. 3 Ms. 4 Mrs. 5 Mr. 6 Mr. 7 Mr. 8 Ms. 9 Mr. 10 Mrs. 11 Mr. 12 Mr. 13 Mr. 14 Ms. 15 Mr. 16 Mr. 17 Ms. 18 Mr. 19 Mr. 20 Mr. 21 Ms. Williamson John Ratula Nancy Greenboro Lottie Rumpersfro Jennie Smith Robert Renselaer Cary Ogallo Johnsson Eindsmar Jones 1 East 2 West Broderick Washington Smith Smith Olenko Archialo Grimaldo Rosenberg Rosten Mckee Baumann Table name: STORE STORE_CODE STORE_NAME 1 Access Junction 2 Database Corner 3 Tuple Charge 4 Attribute Alley 5 Primary Key Point Table name: REGION REGION_CODE REGION_DESCRIPT Roberto Elizabeth Jack Rose Tom Alan Peter Sherry Howard Barry Jeanine Andrew Peter Robert Jennifer W 1003455.76 1421987.39 986783.22 944568.56 2930098.45 RSLAS I W R Y
Step by Step Solution
★★★★★
3.43 Rating (156 Votes )
There are 3 Steps involved in it
Step: 1
Ans Table Primary key Foreignkey Employee EMPCODE S...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