Draw Relational Diagram (logical design) and ER Diagram (conceptual design) From the above given data.

For each foreign key: i. Relationship type: 1:1, 1:M, M:N ___________ ii. Relationship with Table: ________ PK: ________

FKs w/related PK attribute w/bidirectional BRs

Table name: EMPLOYEE Database name: Ch03 StoreCo EMP EMP-CODE | EMP-TITLE | EMP-LNAME | EMP STORE CODE 21-May-64 09-Feb-69 02-Oct-61 01-Jun-71 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 Willamson John Greenbo Lottie Rumpersfro Jennie Renselaer Cary 31 Jul-62 10-Sep-68 19-Apr-55 06-Mar-66 21-Oct-72 08-Sep-74 Elizabeth I Broderick T Washington Alan Tom 25-May-66 24-May-64 Archilo Barry 12-Nov-70 24-Jan-7 03-Oct-68 06-Mar-70 11-Dec-74 Rosenberg Andrew ennifer Table name: STORE STORE-CODE STORE-NAME 1 Access Junction 2 Database Corner 3 Tuple Charge 4 Attribute Alley 5 Primary Key Point | STORE-YTD-SALES REGION-CODE | EMP-CODE 1003455.76 421987 39 986783.22 944568 56 2930098.45 12 15 Table name: REGION REGION-CODE REGION 1 East 2 West