## (5)

\$15/per page/Negotiable

### About Maurice Tutor

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Algebra,Applied Sciences See all
Algebra,Applied Sciences,Biology,Calculus,Chemistry,Economics,English,Essay writing,Geography,Geology,Health & Medical,Physics,Science Hide all
 Teaching Since: May 2017 Last Sign in: 239 Weeks Ago, 6 Days Ago Questions Answered: 66690 Tutorials Posted: 66688

### Education

• MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011

### Experience

• Professor
Phoniex University
Oct-2001 - Nov-2016

Category > Computer Science Posted 14 Sep 2017 My Price 5.00

### 3NF relations

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.