Task 2 (10 marks) Analyse the following conceptual schema that represents a sample database domain where the projects are implemented by the employees who belong to the departments. There are two categories of employees: programmers and software designers. The computers are used to implement the projects. DEPARTMENT ID: 102 102 enumber city street building fax EMPLOYEE First name Last-lane - Belongs-te date-of-birth 8..1 esployment-date salary project--sign-date Implements PROJECT title short-description budget start-date phone ID3 104 Uses PROGRAPPER university-agree 0.. COMPUTER IP address transient-nemory-size persistent-renory-size SOFTWARE-DESIGNER years-of experience pronation date ID Your task is to perform the logical database design, ie. to transform a conceptual schema given above into a collection of relational schemas and to implement the relational schemas in SQL Assume that superset method must be used to transform a generalization hierarchy. Start from a logical design. Transform a conceptual schema given above into a collection of relational schemas. Clearly list the names of attributes, primary key, candidate keys (if any), and foreign keys (if any) for each one of the relational schemas created. A way how a conceptual schema can be transformed into a collection of relational schemas is explained in a presentation 06 Logical Design