Reference no: EM13831018
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.
|
What are ethical considerations for data collection
: What are ethical considerations for data collection
|
|
Predict stock price movements
: Explain the following statements: (a) There is a strong, consistent relationship between money supply changes and stock prices. (b) Money supply changes cannot be used to predict stock price movements.
|
|
Describe factors that impact the demand for money
: Name and describe at least 3 factors that impact the demand for money. What do you expect the price of a new laptop computer to cost in 6 months
|
|
Screening and diagnostic tools
: Screening and Diagnostic Tools
|
|
Decide which attributes are foreign keys and justify this
: 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 what led to an unsuccessful outcome at home depot
: Explain what led to an unsuccessful outcome at Home Depot. Analyze the Home Depot scenario utilizing the four-frame model (i.e., Structure, HR, Political, and Symbolic)
|
|
Lease a set of golf clubs from pings ltd
: You want to lease a set of golf clubs from Pings Ltd. The lease contract is in the form of 36 equal monthly payments at a stated annual interest rate of 9.2 percent, compounded monthly. Since the clubs cost $2,300 retail, Pings wants the PV of the l..
|
|
Fx forcasting using purchasing power parity
: 1. [FX forcasting using Purchasing Power Parity] The expected inflation rate now until the end of 2015 is 2.5% in the US, and 12% in Argentina, respectively. The current spot exchange rate between Argentina peso (AP) and the US dollar is AP8.2/$. ..
|
|
Write program that print a diamond shape featuring asterisk
: For this assignment, we will need to write a c++ program that is print out a diamond shape featuring the * asterisk to the console window. Please submit .cpp file.
|