Assignment 5 MGT 6318 Due Sunday, August 5 Formatting Notes: Choose a font style and size that can be read without causing undue eyestrain. Use 1.5 or 2….
Decide which attributes are foreign keys and justify your decisions.
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)
(a) Foreign keys are not indicated in these relations. Decide which attributes are foreign keys and justify your decisions.