Answer Happy

URGENT PLEASE HELP!
PLEASE GIVE CORRECT ANSWERS AND FOLLOW THE QUESTION
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 exists). (5 marks)