Note: In drawing the diagram, o You may use Draw.io, LucidChart, or any diagram software you have. Tutorials o For using Draw.io, Microsoft Visio, and LucidChart: refer the videos and documents in Modeling and Database Management Software folder in Course Technology Support section o For drawing ERD: refer the videos in Week 4 Materials and Resource folder in Course Materials section Copy and paste the diagrams to Microsoft Word or convert them PDF and Submit the Word file or PDF file o Diagrams only, not the screen of the software Put your name on your document

Chapter 3 Homework Questions Use the database below to answer Table name: EMPLOYEE Database name: Ch03StoreCo EMP EMP CODE EMP TITLE EMP EMP EMP 21-May-64 09-Feb-69 02-Oct-61 01-Jun-71 STORE CODE 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 M 19 Mr 20 Mr 21 Ms Greenboro Lottie Rumpersfro Jennie 31-Jul-62 10-Sep-68 19-Apr-55 06-Mar-66 21-Oct-72 08-Sep-74 Johnsson Elizabeth I Eindsmar Jack Broderick Tom Washington Alan 25-May-66 24-May-64 03-Sep-60 12-Nov-70 24-Jan-71 03-Oct-68 06-Mar-70 11-Dec-74 Rosenberg Andrew Table name: STORE STORE-CODE STORE NAME 1 Access Junction 2 Database Corner 3 Tuple Charge 4 Attribute Alley Primary Key Point | STORE-YTD-SALES REGION-CODE | EMP-CODE 1003455.76 1421987 39 986783 22 944568 56 2930098.45 12 15 Table name: REGION REGION-CODE REGION East 2 West (Questions) 1. 2. 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. Create the ERD to show the relationship between STORE and REGION