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 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
Get step-by-step solutions from verified subject matter experts
