Congratulations! You have been hired to plan databases for the European Union. Your first 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 considered to be any people under the age of 18.
Congratulations! You have been hired to plan
- 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 considered to be 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. Underline the key attributes of each entity in the diagram. Make any necessary and logical assumptions. State any such assumptions clearly. If there are any constraints in the problem that could not be expressed in the diagram, state these clearly.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 4 images