Answer Happy

Table name: EMPLOYEE EMP_CODE EMP_TITLE EMP_LNAME Williamson Ratula 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. ● Greenboro Rumpersfro Smith Renselaer Ogallo Johnsson Eindsmar Jones Broderick Washington 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 EMP_FNAME John Nancy Lottie Jennie Robert Cary Roberto Elizabeth Database name: Ch03_StoreCo EMP INITIAL EMP_DOB STORE_CODE Jack Rose Tom Alan Peter Sherry Howard Barry Jeanine Andrew Peter Robert Jennifer W 21-May-64 09-Feb-69 R 02-Oct-61 4 S 01-Jun-71 5 L 23-Nov-59 3 A 25-Dec-65 1 S 31-Jul-62 3 I 10-Sep-68 1 W 19-Apr-55 1 2 4 R 06-Mar-66 21-Oct-72 3 Y 08-Sep-74 N 25-Aug-64 H 25-May-66 U 24-May-64 V 03-Sep-60 K 12-Nov-70 D 24-Jan-71 F 03-Oct-68 06-Mar-70 11-Dec-74 S A 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 2 3 4 5 5 4 4 4 1 3 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) 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)