ER- DIAGRAM/ DATABASE The European Parliament wants to create a database to help the various countries store information about its inhabitants. Your mission is to create an ER chart that captures the following information: In each country there are provinces, which contain cities. There can be no two provinces of the same name in a country. In the same way, there can be no two cities of the same name in a province. People live in cities. A person can be a man, a woman or a child, and have a first name, last name, ID, and birthday. Men and women work in a city. Children go to school in a city. Children are everyone persons under 18 years of age. A man can be married to a woman. For each marriage, they store the day for the marriage and information about who is the child of the married couple. You should assume that the parents of a child married at the time of her birth.
ER- DIAGRAM/
The European Parliament wants to create a database to help the various countries store information about its inhabitants. Your mission is to create an ER chart that captures the following information:
In each country there are provinces, which contain cities. There can be no two provinces of the same name in a country. In the same way, there can be no two cities of the same name in a province. People live in cities. A person can be a man, a woman or a child, and have a first name, last name, ID, and birthday.
Men and women work in a city. Children go to school in a city. Children are everyone persons under 18 years of age.
A man can be married to a woman. For each marriage, they store the day for the marriage and information about who is the child of the married couple. You should assume that the parents of a child married at the time of her birth.
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 2 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
![Concepts of Database Management](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)