Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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

SQL Instant Reference

Authors: Gruber, Martin Gruber

2nd Edition

0782125395, 9780782125399

More Books

Students also viewed these Databases questions

Question

2. Identify issues/causes for the apparent conflict.

Answered: 1 week ago