Table name: EMPLOYEE Database name: Ch03_StoreCo EMP CODE EMP TITLE BMP LNAME EMP_FNAME EMP_INTIAL EMP DOB STORE CODE 1 Nr. Wiliamson John W 21-May-84 2 MS. Ratula Nancy 09-Feb-89 3 Ns. Greenboro Lottie 02-Oct-81 4 Nrs. Rumperstro Jennie 01-Jun-91 5 Mr: Smith Robert 23-Nov-79 6 Mr: Renselaer Cary 25-Dec-85 7 Mr Ogalo Roberto 31-Jul-82 8 Ms. Johnsson Elzabeth 10 Sep 88 9 Nr: Eindsmar Jack 19-Apr-75 10 Mrs. Jones Rose 06-Mar-86 11 Nr Broderick Tom 21-Oct-92 12 Nr. Washington Alan 08-Sep-94 13 Nr: Smith Peter 25-Aug-84 14 Ns. Snith Sherry 25-May-86 15 Nr Olenko Howard 24-May-84 16 Nr: Archalo Darry 03-Sep-60 17 Ns. Grimalco Jeanine 12-Nov-90 18 Nr Rosenberg Andrew 24-Jan-91 19 Nr. Rosten Peter 03-Oct-88 20 Nr: Mckee Robert 06-Mar-90 21 Ns. Baunann Jennifer 11-Dec-94 W-AU AWNWNWA Table name: STORE STORE CODE STORE NAME STORE YTD SALES REGION_CODE EMP CODE 1 Access Junction 1003455.76 2 Database Corner 1421907.39 2 12 3. Tuple Charge 986783.22 4 Attribute Alley 944568.56 2 5 Primary Key Pont 2930098.45 Table name: REGION REGION_CODE REGION_DESCRIPT 1 East 2 West Use the database shown in Figure P3.1 to answer Problems 1-9. 1. For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. 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. 5. Create the ERD to show the relationship between STORE and REGION. 6. Create the relational diagram to show the relationship between STORE and REGION. 7. Describe the type(s) of relationship(s) between EMPLOYEE and STORE. (Hint: Each store employs many employees, one of whom manages the store.) Clupeli HHC HCIULIULUID 8. Create the ERD to show the relationships among EMPLOYEE, STORE, and REGION. 9. Create the relational diagram to show the relationships among EMPLOYEE, STORE, and REGION. Table name: EMPLOYEE Database name: Ch03_StoreCo EMP CODE EMP TITLE BMP LNAME EMP_FNAME EMP_INTIAL EMP DOB STORE CODE 1 Nr. Wiliamson John W 21-May-84 2 MS. Ratula Nancy 09-Feb-89 3 Ns. Greenboro Lottie 02-Oct-81 4 Nrs. Rumperstro Jennie 01-Jun-91 5 Mr: Smith Robert 23-Nov-79 6 Mr: Renselaer Cary 25-Dec-85 7 Mr Ogalo Roberto 31-Jul-82 8 Ms. Johnsson Elzabeth 10 Sep 88 9 Nr: Eindsmar Jack 19-Apr-75 10 Mrs. Jones Rose 06-Mar-86 11 Nr Broderick Tom 21-Oct-92 12 Nr. Washington Alan 08-Sep-94 13 Nr: Smith Peter 25-Aug-84 14 Ns. Snith Sherry 25-May-86 15 Nr Olenko Howard 24-May-84 16 Nr: Archalo Darry 03-Sep-60 17 Ns. Grimalco Jeanine 12-Nov-90 18 Nr Rosenberg Andrew 24-Jan-91 19 Nr. Rosten Peter 03-Oct-88 20 Nr: Mckee Robert 06-Mar-90 21 Ns. Baunann Jennifer 11-Dec-94 W-AU AWNWNWA Table name: STORE STORE CODE STORE NAME STORE YTD SALES REGION_CODE EMP CODE 1 Access Junction 1003455.76 2 Database Corner 1421907.39 2 12 3. Tuple Charge 986783.22 4 Attribute Alley 944568.56 2 5 Primary Key Pont 2930098.45 Table name: REGION REGION_CODE REGION_DESCRIPT 1 East 2 West Use the database shown in Figure P3.1 to answer Problems 1-9. 1. For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. 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. 5. Create the ERD to show the relationship between STORE and REGION. 6. Create the relational diagram to show the relationship between STORE and REGION. 7. Describe the type(s) of relationship(s) between EMPLOYEE and STORE. (Hint: Each store employs many employees, one of whom manages the store.) Clupeli HHC HCIULIULUID 8. Create the ERD to show the relationships among EMPLOYEE, STORE, and REGION. 9. Create the relational diagram to show the relationships among EMPLOYEE, STORE, and REGION