Drawing ER Diagram :

Task 1:

Task 2:

.1 .Design an Entity-Relationship (ER) diagram for the country Indicate the relationships, including cardinality and participation. Identify the primary key, any assumption, and resolution of many-to- many or one-to-many relationships. Assume we have the following statements A country contains many governorates Each governorate contains many states .2 Many employees can work in a governorate .3 An employee can work only in one governorate For each governorate, there is a Manager An employee can be a manager of only one governorate .6 Each employee can take any number of tasks ] Only one employee can take a task Customer can enroll for any number of tasks 9 .4 5 .8 Each task can have any number of Customers. 10 Suppose you are working for a huge software development organization. Your organization is often involved in developing a database for customers affiliated with the news and virtual exhibitions. A Newspaper contains many sections, each section can offer any number of topics, many writers can work in a section, for each section there is a Head, a writer can work only in one section, a writer can be head of only one section, each writer can take any number of topics, a topic can be taken by only one writer, A Designer can design for any number of topics, each topic can have any number of the designer. Explain the mains steps that must be followed to draw ?Entity-Relationship (ER) Modeling