The following are the main tasks you are assigned to you: Designing the Database System 1. Investigate the requirements of the system. 2. Apply the conceptual design (ERM) concepts to: .Write the entity and identify the attributes required for each entity. Define the cardinality ratio of each relationship and their types. Check whether the provided design is normalized. If not, normalize the database by removing the anomalies. In addition, what is the type of normalization achieved in your design? 3. Design the relational database which includes: List of tables mapped from the ERD. Database schema which includes the fields, datatypes and constraints. Specify identifiers (primary Key) and foreign keys datatypes for each table