Need Help creating this ER diagram I am lost, I feel like I know what I am doing

Question

Need Help creating this ER diagram I am lost, I feel like I know what I am doing but at the same time I feel like I am messing somethings up.

Design requirements:

Each santa has a unique ID, and we also track their name, favorite cookie, and country of residence. We often just need the first name of a santa. Santas are distributed throughout the world, and there is never more than one santa residing in any given country at a time. It is possible for a santa to relocate to a new country during their individual lifetime, but this can only happen if another santa is not already living there.

Santas must have some help, so they employ elfs. Due to their culture, no two elfs will ever have the same name ever. We track the height of our elves as well as their favorite candies. For payroll purposes we need to know the date when an elf started working for a santa. Elfs like to move around and could potentially work for many snatas during their lifetime.

Santas may own reindeer. No santa would own two reindeer with the same name. We store the birthdate of reindeer and need access to their age.

Children are identified by their name and address. We also need to store their birthdate and their country of residence.

In any given year, any santa can deliever a present to any child. We track the year a particular santa made the delivery and what present the child recieved. Some children are naughty, so not everyone receives a present each year. Also each child can only recieve on present. Some years santa may be out of commission and unable to deliver presents. Santas are known for their extensive and thorough records, and we need to know who was naughty or nice and what year that distinction applied(for all years)

Please write down any assumptions you may have made.

Explanation / Answer

Child
CID Name Address.Street Address.City Address.PostCode Age Country Goodness
Present
Name Weight PType Creator
Present Type
PType
Elf
Name
Delivers
CID Name Year
Wishist
CID PType

ERP diagram is not uploading.you can take help from this:

http://www.dcs.kcl.ac.uk/pg/hadjinik/DBS/C_S.pdf

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

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