2 Ms. can Styles Table name: EMPLOYEE Database name: Cho3_StoreCo DP_CODE BP_TLE BYPLJUNUE DMP FNAME EXPANTAL EXP_DOBSTORE_CODE 1 M. Wamson John 21-May-84 Ratula Nancy 09-Feb-69 Groenboro Lottie 02-Oct-61 Rumperstro Jennie 01-Jun-71 Smith Robert 23-Nov-59 Renselaer 25-Dec-65 7 M. Ogallo Roberto 31--62 Johnsson Elbeth 10-Sep-68 Endsmar 19-Apr-55 10 Mrs. Jones Rose 08-Mar-88 11 Mr. Broderick Tom 21-Oct-72 12 Mr. Washington Alen 08-Sep-74 13 Mr. Smith Peter 25-Aug-64 Smith Sherry 25-May-66 Olenko Howard 24-May-64 Archiato Barry 03-Sep-60 Grimaldo Jeanine 12-Nov-70 18 M Rosenberg Andrew 24-Jan-71 19 Mr Rosten Peter 03-Oct-68 20 M Mckee Robert 06-Mar-70 Baumann Jennifer 11-Dec-74 Jack AWNW 14 MS. 15 Mr. Table name: STORE STORE_CODE STORE_NAME STORE_YTD_SALES REGION_CODE EMP_CODE 1 Access Junction 1003455.76 2 Database Corner 1421987 39 3 Tuple Charge 986783 22 4 Attribute Alley 944568.56 5 Primary Key Point 2930098.45 Table name: REGION REGION_CODE REGION_DESCRIPT 1 East 2 West 5. Create the ERD to show the relationship between STORE and REGION. 6. Describe the type(s) of relationship(s) between EMPLOYEE and STORE. (Hint: Each store employs many employees, one of whom manages the store.) 7. Draw the ERD to show the relationships among EMPLOYEE, STORE, and REGION