Answered step by step
Verified Expert Solution
Link Copied!

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.

(P.1) For each table, identify the primary key and 

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems Design Implementation and Management

Authors: Carlos Coronel, Steven Morris

11th edition

9781305323230, 1285196147, 1305323238, 978-1285196145

More Books

Students also viewed these Databases questions

Question

Explain the OLE-DB model based on its two types of objects

Answered: 1 week ago

Question

Explain why database design is important.

Answered: 1 week ago