The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 398 Weeks Ago, 1 Day Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
5. 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)(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 a. (c) Explain the assumptions you made about cardinalities in your answer to part b. Explain why it is said that the E-R data model is more expressive or more semantically rich than the relational data model.
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll