Question (C2): (7 marks) A hospital would like to set up a database recording which registered nurse looked after which patient etc. Each registered nurse has a unique nurse ID, and each patient has a unique patient ID, and the following attributes are found for nurses, and patients in the first round of design: NURSE: nurseID, surname, first name, birthdate, dept-code, sex, salary-level PATIENT: patientID, surname, first name, birthdate, wardID, sex, admission_date, discharge_date A recent duty list shows the patients that were cared by each nurse in past 2 months, see below for some samples: 11 nurseID NO140000 N0172222 NO182222 N0163333 N0164444 patientID P123, P234, P883, P678 P234, P334, P222, P883 P243, P123, P883, P888 P111, P123 P222, P234 You are responsible to help design this database for the hospital. a) What relationship (one-to-one, one-to-many, many-to-many) exists between NURSE and PATIENT? Explain your answer or draw an entity relationship diagram. (2 marks) b) How many tables would be needed to implement the relationship as indicated in (a)? List out the attributes in each table, indicating which field(s) form the primary key, and which field is the foreign key (if foreign key ex y exists). (5 marks) Question (C3): (3 marks) Below is a database with 2 tables - Product, Vendor: Product table; primary key = Product_Num, foreign key = Vendor_Num Product_Num Product_decription Vendor_Num 1336 Claw Hammer 123 1337 Dawn Thunder 1338 Plastic Thistle 111 1339 Hasty Exciter 123 1340 Vanilla Splitter 1341 X-filer 123 111 134 Vendor table: primary key = Vendor_Num, no foreign key Vendor_Num Vendor_company Vendor_contact_phone Vendor_contact_person Country X-Hardware 61-532-234156 Peter Fleming British 123 ABC_Machinery 62-333-123455 Joan Stenoma Italian 111 The above database contains an error in the data. Identify and describe this error