he database requirements contain the following information:

• Employees working on the projects are divided into two categories: Developers and Development Managers.
• Developers are working in Teams.
• Each Development Manager manages at least one Team.
• Each Team works on at least one Project.
• At least one Team works on a Project.
• The following general information is stored for each Employee: ID, Name and
• The Developer additional attributes are Position and Skill (not multi-valued).
• The Development Manager additional attribute is a Product Type.
• The Teams attributes are Team ID, team name and team start date.
• One of the team members (Developers) is also a team leader. This information must also be stored in the database.
• The Project attributes are Project ID, Project Name, Start Date and End Date.
• HoursWorked is an association between Project and Developer, and it is a number of hours a Developer spent working on a Project.

Part 1. Conceptual Model

Please remember that the Enhanced Entity-Relationship diagram is only a part of your assignment. You need to describe the Conceptual Model, which must include the following elements:

• Entities and their attributes. For each entity you must also specify unique identifier attribute(s)
• Entity supertypes and subtypes. Describe inheritance types and the corresponding discriminators.
• Identify multi-valued and composite attributes (if any). In this case, they need to be shown in the ER diagram with the corresponding notations.
• Describe relationships between entities and their cardinalities. Remember that relationships can be one-to-one, one-to-many, many-to-many, and also optional or mandatory
• Draw the Conceptual Model Enhanced Entity-Relationship diagram using app.diagrams.net tool, save it as .png or .jpg file and insert it in the Word document

Part 2. Logical Model

Describe the algorithm of convert the Conceptual Model into the Logical Model. Remember that your description should include the following elements:

• Entities in the Conceptual Model become relations (tables) in the Logical Model, and unique identifiers become primary keys.
• For one-to-one or one-to-many relationship between two entities you will need t
• If there is a many-to-many relationship between two entities, then you will need to create a new relation (table) with a composite primary key
• For each field (column) in a relation, describe a data type (integer, float, character, text etc.)
• If an entity contains a multi-valued attribute, then you will need to create a new relation in the Logical Model corresponding to this attribute.
• Draw the Logical Model diagram using app.diagrams.net tool, save it as .png or .jpg file and insert it in the Word document