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.
a) Suppose that You have gotten a job planning
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
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
