Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a) Suppose that You have gotten a job planning databases for the European Union. Your first on job assignment is to help the various countries

a) Suppose that You have gotten a job planning databases for the European Union. Your first on job assignment is to help the various countries maintain information about their inhabitants. Your model should capture the following information:
• In each country, there are provinces, which contain towns. There cannot be two provinces with the same name in a single country. Similarly, there cannot be two towns with the same name in a single province.
• People live in towns. Men and women work in a town. Children learn in a school in a town.
• A person can be a man, a woman, or a child, and has a first-name, last-name, id, and birthday.
Children are any people under the age of 18.
• A man can be married to a woman (polygamy is not allowed, i.e., one man can be married only to one woman). Although the Pope strongly disapproves, divorce, and subsequent remarriage, is possible.
• For each marriage, store the date of the marriage and information about who are the children of the married couple. You should assume that the parents of a child were married at the time of his birth.


Draw an entity relationship diagram to model the information described above.
Remember to put edge constraints (arrows) and participation constraints (thick lines) where needed. Underline the key attributes of each entity in the diagram. If you use the ISA relationship, state any covering and overlap constraints that hold. Make any necessary and logical assumptions.


b) Convert the ER diagram into a relational table.

Step by Step Solution

3.40 Rating (163 Votes )

There are 3 Steps involved in it

Step: 1

Pa... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microeconomics An Intuitive Approach with Calculus

Authors: Thomas Nechyba

1st edition

538453257, 978-0538453257

More Books

Students also viewed these Databases questions