# Consider the following 3nf relations about a sorority or fraternity.

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

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)

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.

#### What Students Are Saying About Us

.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"

.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."