This discussion assesses your ability to clarify the role of each legally mandated attendee on the Individualized Education Program team. This assessment also supports your achievement of Course Learning Outcome….
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.