Decide which attributes are foreign keys and justify this

Assignment Help Database Management System
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.

Reference no: EM13831018

Questions Cloud

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.

Reviews

Write a Review

 

Database Management System Questions & Answers

  Implement a database based on the provided er diagram

Analyse and comprehend a provided ER diagram and Database Schema and implement a database based on the provided ER diagram and Database Schema

  Diagram and determine the possible iterative steps

Determine the steps in the development of an effective Entity Relationship Model (ERM) Diagram and determine the possible iterative steps / factors that one must consider in this process with consideration of the HR core functions and responsibili..

  What is the drawback of using end-to-end security

You will find an abundance of materials on this subject within the databases located within IEEE & ACM digital libraries. But don't forget that especially in the Networking technologies RFC's and other related standards are the most authoritative ..

  Difference between a data warehouse and a data mart

The difference between a data warehouse and a data mart is, Which of the following is not an example of the emerging mobile computing platforms

  Prepare a database using microsoft access

Using Microsoft Access, prepare a database and save it as Acme Inc. Prepare the following tables: Employees and Products. Field names for Employees table are first name,

  Asnbspyou approach thenbspend ofnbspthe class you have

asnbspyou approach thenbspend ofnbspthe class you have seen how a database can be set up and accessed.nbspnext you

  Analyze the business activity

Data Files needed for this Case Problem: OBrien.accdb (cont. from Tutorial 3) and Tests.bmp O'Brien Educational ServicesKaren O'Brien is using the OBrien database to track and analyze the business activity of her educational consulting company. T..

  Determine the benefits of data mining

Determine the benefits of data mining to the businesses when employing: Predictive analytics to understand the behavior of customers

  Discuss optimization techniques specific to data warehousing

Demonstrate the basic mechanisms for accessing relational databases from various types of application development environments.

  Discuss likely data integrity constraints on attributes

Write an SQL query to find out how many Computer Science departments are not in Victoria. Return the number -  Discuss likely data integrity constraints on attributes and specify all candidate keys and the primary key for each relation based on the..

  Number of employees at the new book sales corporation

To identify the number of employees at the New Book Sales Corporation, you view the records in the Sales Department table.

  Construct a diagram using rationale to map the arguments

Construct a diagram using Rationale to map the arguments about a moral claim that you have identified in the article/case study: Include all supporting and objecting claims.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd