Question: Part 2: For the database shown below, answer the following 3 questions: Table name: EMPLOYEE Datahase name: Ch03_StoreCo Table name: STORE Table name: REGION 1.

 Part 2: For the database shown below, answer the following 3questions: Table name: EMPLOYEE Datahase name: Ch03_StoreCo Table name: STORE Table name:

Part 2: For the database shown below, answer the following 3 questions: Table name: EMPLOYEE Datahase name: Ch03_StoreCo Table name: STORE Table name: REGION 1. For each table, identify the primary key and the foreign key(s) by filling in below table. If a 2. Do the tables exhibit entity integrity? Answer yes or no, and then explain your answer by fi 3. Do the tables exhibit referential integrity? Answer yes or no, and then explain your answer - Part 3: Write the business rules for the relationships you identify in Figure from Part 2. - Part 4: Create a Visio ERD for the database in Figure in Part 2. (Note all required elements as covered in class must be included)

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!