Type your question hereConsider the following 3NF relations about a sorority or

Question

Type your question hereConsider 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. (b) Draw an E-R diagram for these relations, using your answer to part

Explanation / Answer

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) MEMBER(Member_ID, Name, Address, Dues_Owed, office_ID) Here office_ID is a foriegn key OFFICE(Office_Name, Officer_ID, Term_Start_Date, Budget) EXPENSE(Ledger_Number, Office_Name, Expense_Date, Amt_Owed) office_Name can used as a foriegn key PAYMENT(Check_Number, Expense_Ledger_Number, Amt_Paid) Expense_Ledger_Number can used as foreign key RECEIPT(Member_ID, Receipt_Date, Dues_Received) Member_Id is a foreign key COMMITTEE(Committee_ID, Officer_in_Charge) WORKERS(Committee_ID, Member_ID) Member_id is a foreign key

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.