DRIVER TRUCK drives During some time interval, a DRIVER can drive many TRUCKs and any TRUCK can be driven by many DRIVERs FIGURE Q3.14 The Crow's Foot ERD for Question 14 How would you convert this model into an ERM that displays only 1:M relationships? Make sure that you draw the revised ERM. Specifically convert this M:N relationship into two 1:M relationships look at figure 3.26 to see example for STUDENT and CLASS. Use Crow's foot diagram as illustrated in Figures 3.17, 3.19, and 3.21 for ERM diagram. Write the business rules that apply to the two 1:M relationships and draw the revised ERM diagram. (7 points total - 2 for business rules, 5 for ERM diagram) Table name: EMPLOYEE Database name: Ch03 StoreCo EMP IN- LAL | EMP EMP CODE! EMP-TITLE | EMP EMP STORE CODE 1 Mr 2 Ms 3 Ms Williamson John Ratula Greenboro Lottie Rumpersfro Jennie 21-May-64 09-Feb-69 02-Oct-61 01-Jun-71 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 Renselaer Cary 31-Jul-62 10-Sep-68 19-Apr-55 06-Mar-66 21-Oct-72 08-Sep-74 Johnsson Elizabeth Broderick T Washington Alan Torn Peter Sherry H 25-May-66 24-May-64 Rosenberg Andrew Rosten Mckee 12-Nov-70 24-Jan-71 03-Oct-68 06-Mar-70 11-Dec-74 Peter Table name: STORE STORE-CODE | STORE NAME | STORE YTD SALES | REGION-CODE | EMP-CODE 1 Access Junction 2 Database Corner 3 Tuple Charge 4 Attribute Alley 5 Primary Key Point 1003455.76 142198739 986783.22 944568.56 2930098.45 12 15 Table name: REGION REGION-CODE REGION-D SCRIPT East 2 West FIGURE P3.1The Ch03_StoreCo Database Tables Table name: EMPLOYEE Database name: Ch03 StoreCo EMP IN- LAL | EMP EMP CODE! EMP-TITLE | EMP EMP STORE CODE 1 Mr 2 Ms 3 Ms Williamson John Ratula Greenboro Lottie Rumpersfro Jennie 21-May-64 09-Feb-69 02-Oct-61 01-Jun-71 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 Renselaer Cary 31-Jul-62 10-Sep-68 19-Apr-55 06-Mar-66 21-Oct-72 08-Sep-74 Johnsson Elizabeth Broderick T Washington Alan Torn Peter Sherry H 25-May-66 24-May-64 Rosenberg Andrew Rosten Mckee 12-Nov-70 24-Jan-71 03-Oct-68 06-Mar-70 11-Dec-74 Peter Table name: STORE STORE-CODE | STORE NAME | STORE YTD SALES | REGION-CODE | EMP-CODE 1 Access Junction 2 Database Corner 3 Tuple Charge 4 Attribute Alley 5 Primary Key Point 1003455.76 142198739 986783.22 944568.56 2930098.45 12 15 Table name: REGION REGION-CODE REGION-D SCRIPT East 2 West FIGURE P3.1The Ch03_StoreCo Database Tables DRIVER TRUCK drives During some time interval, a DRIVER can drive many TRUCKs and any TRUCK can be driven by many DRIVERs FIGURE Q3.14 The Crow's Foot ERD for Question 14 How would you convert this model into an ERM that displays only 1:M relationships? Make sure that you draw the revised ERM. Specifically convert this M:N relationship into two 1:M relationships look at figure 3.26 to see example for STUDENT and CLASS. Use Crow's foot diagram as illustrated in Figures 3.17, 3.19, and 3.21 for ERM diagram. Write the business rules that apply to the two 1:M relationships and draw the revised ERM diagram. (7 points total - 2 for business rules, 5 for ERM diagram) Table name: EMPLOYEE Database name: Ch03 StoreCo EMP IN- LAL | EMP EMP CODE! EMP-TITLE | EMP EMP STORE CODE 1 Mr 2 Ms 3 Ms Williamson John Ratula Greenboro Lottie Rumpersfro Jennie 21-May-64 09-Feb-69 02-Oct-61 01-Jun-71 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 Renselaer Cary 31-Jul-62 10-Sep-68 19-Apr-55 06-Mar-66 21-Oct-72 08-Sep-74 Johnsson Elizabeth Broderick T Washington Alan Torn Peter Sherry H 25-May-66 24-May-64 Rosenberg Andrew Rosten Mckee 12-Nov-70 24-Jan-71 03-Oct-68 06-Mar-70 11-Dec-74 Peter Table name: STORE STORE-CODE | STORE NAME | STORE YTD SALES | REGION-CODE | EMP-CODE 1 Access Junction 2 Database Corner 3 Tuple Charge 4 Attribute Alley 5 Primary Key Point 1003455.76 142198739 986783.22 944568.56 2930098.45 12 15 Table name: REGION REGION-CODE REGION-D SCRIPT East 2 West FIGURE P3.1The Ch03_StoreCo Database Tables Table name: EMPLOYEE Database name: Ch03 StoreCo EMP IN- LAL | EMP EMP CODE! EMP-TITLE | EMP EMP STORE CODE 1 Mr 2 Ms 3 Ms Williamson John Ratula Greenboro Lottie Rumpersfro Jennie 21-May-64 09-Feb-69 02-Oct-61 01-Jun-71 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 Renselaer Cary 31-Jul-62 10-Sep-68 19-Apr-55 06-Mar-66 21-Oct-72 08-Sep-74 Johnsson Elizabeth Broderick T Washington Alan Torn Peter Sherry H 25-May-66 24-May-64 Rosenberg Andrew Rosten Mckee 12-Nov-70 24-Jan-71 03-Oct-68 06-Mar-70 11-Dec-74 Peter Table name: STORE STORE-CODE | STORE NAME | STORE YTD SALES | REGION-CODE | EMP-CODE 1 Access Junction 2 Database Corner 3 Tuple Charge 4 Attribute Alley 5 Primary Key Point 1003455.76 142198739 986783.22 944568.56 2930098.45 12 15 Table name: REGION REGION-CODE REGION-D SCRIPT East 2 West FIGURE P3.1The Ch03_StoreCo Database Tables