FIGURE P3.1 The Ch03 StoreCo database tables Table name: EMPLOYEE THE RELATIONAL DATABASE MODEL 93 Database name: Ch03_StoreCo EMP CODE EMP TITLE EMP LNAME EMP FNAME EMP NITIAL EMP DOB STORE CODE 1 Mr. 2 Ms. samson Rabule John Nancy W 21-May-64 3 09-Feb-89 2 3 Ms. Greenboro Lottie R 02-Oct-61 4 4 Mrs. Rumpersfro Jennie S 01-Jun-71 5 5 Mr. Smith Robert L 23-Nov-58 3 6 M Renselser Cary A 25-Dec-65 1 7 Mr. Ogallo Roberto S 31-Ju-62 3 8 Ms. Johnsson Elzabeth 10-Sep-68 1 9 M Bindsmer Jack W 19-Apr-55 2 10 Mrs. Jones Rose R 06-Mar-66 4 11 Mr. Broderick Tom 21-Oct-72 3 12 Mr. Washington Alon Y 08-Sep-74 2 13 M Smith Peter N 25-Aug-64 3 14 Ms. Smith Sherry H 25-May-66 4 15 Mr. Olenko Howard U 24-May-64 5 16 M. Archialo Barry V 03-Sep-60 5 17 Ms. Grimaldo Jeanine K 12-Nov-70 4 18 Mr. Rosenberg Andrew D 24-Jan-71 4 19 Mr. Rosten Peter F 03-Oct-68 4 20 Mr. Mckee Robert S 06-Mar-70 1 21 Ms. Baumann Jennifer A 11-Dec-74 Table name: STORE STORE CODE STORE NAME STORE_YTD SALES REGION CODE EMP_CODE 1 Access Junction 1003455.76 2 8 2 Database Comer 1421987.39 2 12 3 Tuple Charge 966783.22 1 7 4 Attribute Aley 5 Primary Key Point 944568.56 2930098.45 2 3 1 15 Table name: REGION REGION CODE REGION DESCRIPT 1 East 2 West 7. Describe the type(s) of relationship(s) between EMPLOYEE and STORE. (Hint: Each store employs many employees, one of whom manages the store.) 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. Use the database shown in Figure P3.10 to work Problems 10-16. Note that the database is composed of four tables that reflect these relationships: An EMPLOYEE has only one JOB CODE, but a JOB CODE can be held by many EMPLOYEES. An EMPLOYEE can participate in many PLANS, and any PLAN can be assigned to many EMPLOYEES. Note also that the M:N relationship has been broken down into two 1:M relationships for which the BENEFIT table serves as the composite or bridge entity.