Consider the following 3NF relations about a sorority or fraternity.

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 1Explain 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.

 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "GET10" in your order"

If this is not the paper you were searching for, you can order your 100% plagiarism free, professional written paper now!

Order Now Just Browsing

All of our assignments are originally produced, unique, and free of plagiarism.

Free Revisions Plagiarism Free 24x7 Support