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.

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.

find the cost of your paper

Case study Analysis( paper)- Prime Bank of Massachusetts

APA format is required. References should be listed immediately after the question that is being answered. Each question lists a minimum number of unique scholarly references; the textbook is considered one unique….

“Letter from Birmingham Jail” was written by Martin Luther King Jr.

Overview “Letter from Birmingham Jail” was written by Martin Luther King Jr., as the title indicates, while he was confined in the Birmingham city jail in April, 1963. King is….

I need to write a medical report to academic advisor

Dear Sir or Madam, I need to write to my academic advisor a medical report ( Turki Alanazi came to our hospital after 14 days of his return from the….