ABC Consulting IT company specialises on Mobile Application development for businesses. The company needs a database to store information about projects and employees working on the projects. You task is to design a relational database and create SQL queries to create and populate the tables. The 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). 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: 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. . Entities and their attributes For each entity you must also specify unique identifier attribute(s) Entity supertypes and subtypes. Describe inbormance types and the corresponding discriminators Identify multi-valued and composite attributes (if way). 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, ong-lo- many, many-to-many, and also optional o 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 S Entities in the Conceptual Model become relations (tables) in the Logical Mocel, and unique identifiers become primary keys For one-to-one or one-to-many relationship between two entities you will need to create a foreign key in one of the relations (lables) 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 typa (integec Boat, 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