Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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)
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(Commituee_ID,Officer_in_Charge) WORKERS(Committee_ID,Member ID) a. ns S. b. Draw an E-R diagram for these relations, using your an swer to Problem and Exercise 9-47a. c. Explain the assumptions you made about cardinali- ties in your answer to Problem and Exercise 9-47b. Explain why it is said that the E-R data model is more expressive or more semantically rich than the rela- tional data model
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started