Draw an eer diagram using the crows foot notation

Assignment Help Computer Engineering

Reference no: EM134027452

Problem

Draw an EER diagram for the following problem using the crow's foot notation and following the guidelines in Hoffer, Jeff, et al. Modern Database Management. Available from: Yuzu Reader, (13th Edition). Pearson Education (US), 2018.

A nonprofit organization depends on a number of different types of persons for its successful operation. The organization is interested in the following attributes for all of these persons: SSN, Name, Address, City, State, Zip, and Telephone. Three types of persons are of greatest interest: employees, volunteers, and donors. Employees have only a Date Hired attribute, volunteers have only a Skillset attribute, and donors have only a Donation Amount attribute. Additionally, donors have a relationship (named Donates) with the entity Item. An item has an ItemID and a description. A donor must have donated one or more items, and an item may have no donors or one or more donors. There are persons other than employees, volunteers, and donors who are of interest to the organization. At a given time, a person may belong to two or more of these groups (e.g., employee and donor). Get the instant assignment help.

Now, develop a relational schema based on the EER diagram you created.

Reference no: EM134027452

Questions Cloud

What might explain the results : What might explain these results? If you were designing a machine learning pipeline for this problem, what would you suggest to do?

Draft an agenda for sierra college meeting with staff : Draft an agenda for Sierra College meeting with staff to draft 3 year college programs 6 semester. Talk about the advantage as a private career college.

What is the literature saying about the study : What is the study all about; What is the literature saying about the study; What is the research gap and How will this study address research gap?

What is the miss penalty for the cache : We have a 512 KB 8-way set-associative L2 cache that stores data as 16-byte blocks. What is the miss penalty for the cache (clock cycles)?

Draw an eer diagram using the crows foot notation : Draw an EER diagram for the following problem using the crow's foot notation and following the guidelines in Hoffer, Jeff, et al. Modern Database Management.

Element of negligence to determine potential liability : A patient incident has occurred, and you must analyze it using the four elements of negligence to determine potential liability and recommend actions

How would you compare historical casework : How would you compare historical casework to your understanding of recent criminal justice investigations and What has remained constant throughout the history

Hedging to protect your company income : Explain how you may use hedging to protect your company's income.

Dense stands along streams : Reed canary grass is a widespread invasive grass in eastern washington that forms dense stands along streams.

User Account

All Pages