Need this ASAP Consider the following 3NF relations abou t a sorority or fratern

ID: 664958 • Letter: N

Question

Need this ASAP

Consider the following 3NF relations abou t a sorority or fraternity:

MEMBER (Mem ber_ID,Name ,Address ,Dues_Owed)

OFFICE(Office_Name ,Officer_ID,Term_Start_Date, Budget)

EXPENSE (Ledger_Nu mber,Office_Na me,Expense_Date, Am t_Owed)

PAYMENT(Check_Number,Expense_Ledger_Num ber, Amt_Paid)

RECEIPT(Mem ber_ID,Receipt_Date ,Dues_Received)

COMMITTEE (Com mittee_ID,Officer_ in_Charge)

WORKERS (Com mittee_ID,Mem ber_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 Problem and Exercise A.

foreign key-member_id

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.