Question description

just i have 2 questions

1-Consider the list of individual 3NF relations below. These relations were developed from several separate normalization activities.
PATIENT(Patient_ID, Room_Number, Admit_Date, Address)
ROOM(Room_Number, Phone, Daily_Rate)
PATIENT(Patient_Number, Treatment_Description, Address)
TREATMENT(Treatment_ID, Description, Cost)
PHYSICIAN(Physician_ID, Name, Department)
PHYSICIAN(Physician_ID, Name, Supervisor_ID)
(a) Merge these relations into a consolidated set of 3NF relations. State whatever assumptions you consider necessary to resolve any potential problems you identify in the merging process.a

2-Consider the following 3NF relations about a sorority or fraternity:
MEMBER(Member_ID, Name, Address, Dues_Owed)
OFFICE(Office_Name, Officer_ID, Term_Start_Date, Budget)
EXPENSE(Ledger_Number, Office_Name, Expense_Date, Amt_Owed)
PAYMENT(Check_Number, Expense_Ledger_Number, Amt_Paid)
RECEIPT(Member_ID, Receipt_Date, Dues_Received)
COMMITTEE(Committee_ID, Officer_in_Charge)
WORKERS(Committee_ID, Member_ID)

(a) Foreign keys are not indicated in these relations. Decide which attributes are foreign keys and justify your decisions.