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

profiledsis_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)

 

 

 

  1. Foreign keys are not indicated in these relations. Decide which attributes are foreign keys and justify this.

  2. Draw an ER diagram for these relations, using your answer to problem 1

  3. 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
    Answer(1)

    Purchase the answer to view it

    blurred-text
    • attachment
      img-20150905-wa0003.jpg
    • attachment
      img-20150905-wa0004.jpg
    • attachment
      img-20150905-wa0005.jpg
    • attachment
      foreign_key.docx
    Bids(1)