Consider the following 3NF relations about a sorority or fraternity.
dsis_1
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)
Foreign keys are not indicated in these relations. Decide which attributes are foreign keys and justify this.
Draw an ER diagram for these relations, using your answer to problem 1
Explain the assumptions you made about cardinalities in your answer to problem 2. Can you see why ER diagrams are considered more semantically rich than the relational model.
- 9 years ago
- 20
Purchase the answer to view it
- img-20150905-wa0003.jpg
- img-20150905-wa0004.jpg
- img-20150905-wa0005.jpg
- foreign_key.docx
- BUS 308 Week 5 Final Paper - 100% ORIGINAL
- Help!
- FINC 331 - Finance for Nonfinancial Manager _ Final Exam
- Manager of Human Resources for Nyanya
- Program and Curriculum Planning
- MTH 221 Complete Course Material
- I have 3 word problems I need solutions to for my assignment, and I cannot figure them out. Is there a...
- management2
- property types alphabetically
- essay 1