Question 1. (40 points) Consider the database below: Table name: EMPLOYEE Database name: Ch03_StoreCo EMP_CODE EMP_TITLE

[answerhappygod]

Question 1 40 Points Consider The Database Below Table Name Employee Database Name Ch03 Storeco Emp Code Emp Title 1 (755.14 KiB) Viewed 34 times

Question 1. (40 points) Consider the database below: Table name: EMPLOYEE Database name: Ch03_StoreCo EMP_CODE EMP_TITLE EMP_LNAME EMP_FNAME EMP INITIAL EMP_DOB STORE_CODE W 21-May-64 09-Feb-69 02-Oct-61 01-Jun-71 23-Nov-59 25-Dec-65 31-Jul-62 10-Sep-68 19-Apr-55 06-Mar-66 ● 1 Mr. 2 Ms. 3 Ms. 4 Mrs. 5 Mr. 6 Mr. ● 7 Mr. 8 Ms. 9 Mr. 10 Mrs. 11 Mr. 12 Mr. 13 Mr. 14 Ms. 15 Mr. 16 Mr. 17 Ms. 18 Mr. 19 Mr. 20 Mr. 21 Ms. Williamson John Ratula Greenboro Nancy Lottie Rumpersfro Smith Renselaer Ogallo Johnsson Jennie Robert Cary Roberto Elizabeth Jack Eindsmar Jones Rose Broderick Tom Washington Alan Peter Smith Smith Olenko Archialo Grimaldo Rosenberg Rosten Mckee Baumann Table name: STORE STORE_CODE STORE_NAME 1 Access Junction 2 Database Corner 3 Tuple Charge 4 Attribute Alley 5 Primary Key Point 1 East 2 West Table name: REGION REGION_CODE REGION_DESCRIPT Sherry Howard Barry Jeanine Andrew Peter Robert Jennifer R S L A S I W R Y N H U V K D F S A 21-Oct-72 08-Sep-74 25-Aug-64 25-May-66 24-May-64 03-Sep-60 12-Nov-70 24-Jan-71 03-Oct-68 06-Mar-70 11-Dec-74 STORE_YTD SALES REGION_CODE EMP_CODE 1003455.76 1421987.39 986783.22 944568.56 2930098.45 2 2 1 2 1 8 12 7 3 15 3 2 4 5 3 1 3 1 2 4 3 2 3 4 5 5 4 4 4 1 a) 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. (7 points) 3 b) Create an ER diagram to show the relationships among EMPLOYEE, STORE and REGION with the following business rules: Each store employs many employees, and each employee works in only and only one store; Each store belongs to one and only one region, and each region may have many stores. (28 points) c) Create the relational diagram to show the relationships among EMPLOYEE, STORE, and REGION. (5 points)