The zip file for chapter 3 that you have downloaded will contain this database 1 1 For each table, identify the primary key and the foreign key(s) If a table does not have a foreign key, write None in the space provided 2 Do the tables exhibit entity integrity Answer yes or no and then explain your answer 3 Do the tables exhibit referential integrity Answer yes or no and then explain your answer Write NA (Not Applicable) if the table does not have a foreign key 4 Describe the type(s) of relationship(s) between STORE and REGION Such as one to one or one to many and etc 5 Create the ERD to show the relationship between STORE and REGION 2 MS Cory 9 Mr Table name EMPLOYEE EMP CODE EMP TITLE EMP LNAME 1 Mr Williamson Rotula 3 MS Greenboro 4 Mrs Rumpersfro 5 Mr Smith 6 Mr Renselaer 7 Mr Ogallo 8 Ms Johnsson Eindsmar 10 Mrs Jones 11 Mr Broderick 12 Mr Washington 13 Mr Smith 14 Ms Smith 15 Mr Olenko 16 Mr Archilo 17 Ms Grimaldo 18 Mr Rosenberg 19 Mr Rosten 20 Mr Mckee 21 Ms Baumann Database name Cho3 Sto EMP FNAME EMP NITIAL EMP DOB STORE CODE John w 21 May 64 Nancy 09 Feb 69 Lottie R 02 Oct 61 Jennie S 01 Jun 71 Robert L 23 Nov 59 A 25 Dec 65 Roberto S 31 Jul 62 Elizabeth 1 10 Sep 68 Jack W 19 Apr 55 Rose R 06 Mar 66 Tom 21 Oct 72 Alan Y 08 Sep 74 Peter N 25 Aug 64 Sherry H 25 May 66 Howard U 24 May 64 Barry V 03 Sep 60 Jeanine K 12 Nov 70 Andrew D 24 Jan 71 Peter F 03 Oct 68 Robert s 06 Mar 70 Jennifer A 11 Dec 74 Table name STORE STORE CODE STORE NAME 1 Access Junction 2 Database Corner 3 Tuple Charge 4 Attribute Alley 5 Primary Key Point STORE YTD SALES REGION CODE EMP CODE 1003455 76 2 8 1421987 39 2 12 986783 22 1 7 944568 56 2 3 2930098 45 1 15 Table name REGION REGION CODE REGION DESCRIPT 1 East 2 West

Question

The zip file for chapter 3 that you have downloaded will contain this database   1  1  For each table, identify the primary key and the foreign key(s)  If a table does not have a foreign key, write None in the space provided  2 Do the tables exhibit entity integrity  Answer yes or no and then explain your answer 3  Do the tables exhibit referential integrity  Answer yes or no and then explain your answer  Write NA (Not Applicable) if the table does not have a foreign key  4  Describe the type(s) of relationship(s) between STORE and REGION  Such as one to one or one to many and etc  5 Create the ERD to show the relationship between STORE and REGION  2 MS Cory 9 Mr Table name  EMPLOYEE EMP CODE EMP TITLE EMP LNAME 1 Mr  Williamson Rotula 3 MS Greenboro 4 Mrs  Rumpersfro 5 Mr Smith 6 Mr  Renselaer 7 Mr Ogallo 8 Ms  Johnsson Eindsmar 10 Mrs  Jones 11 Mr  Broderick 12 Mr Washington 13 Mr  Smith 14 Ms  Smith 15 Mr Olenko 16 Mr Archilo 17 Ms  Grimaldo 18 Mr Rosenberg 19 Mr  Rosten 20 Mr  Mckee 21 Ms  Baumann Database name  Cho3 Sto EMP FNAME EMP NITIAL EMP DOB STORE CODE John w 21 May 64 Nancy 09 Feb 69 Lottie R 02 Oct 61 Jennie S 01 Jun 71 Robert L 23 Nov 59 A 25 Dec 65 Roberto S 31 Jul 62 Elizabeth 1 10 Sep 68 Jack W 19 Apr 55 Rose R 06 Mar 66 Tom 21 Oct 72 Alan Y 08 Sep 74 Peter N 25 Aug 64 Sherry H 25 May 66 Howard U 24 May 64 Barry V 03 Sep 60 Jeanine K 12 Nov 70 Andrew D 24 Jan 71 Peter F 03 Oct 68 Robert s 06 Mar 70 Jennifer A 11 Dec 74 Table name  STORE STORE CODE STORE NAME 1 Access Junction 2 Database Corner 3 Tuple Charge 4 Attribute Alley 5 Primary Key Point STORE YTD SALES REGION CODE EMP CODE 1003455 76 2 8 1421987 39 2 12 986783 22 1 7 944568 56 2 3 2930098 45 1 15 Table name  REGION REGION CODE REGION DESCRIPT 1 East 2 West

Accepted Answer

The Answer is in the image, click to view ...

Question

The zip file for chapter 3 that you have downloaded will contain this database . 1. 1. For each table, identify the primary key and

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Introduction To Constraint Databases

Students also viewed these Databases questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question