(1) Complete E/R diagram from Phase 1 (25 points) On you E/R diagram, clearly describe each entity (including, list of entity attributes, and the primary key), and each relationship with its multiplicities. (2) Relational Model (25 points) Using the method for translating an E/R diagram to relations, produce a set of tables for your database design For each table, specify the attributes, their domains, required data constraints, default values, primary key, candidate keys, foreign keys and the tables which the foreign keys are referencing (everything you need for a CREATE TABLE statement) (3) Complete Database Functionalities and User Interface (40 points) (a) List all actors (i.e. users) of your database (b) For each actor, list all use-cases including all the steps. For each entity, you must have use cases that perform at least one aggregate query, one insert operation, one delete operation, and one update operation; For each relationship, you must have use cases that perform at least one joint query. (Number your use cases. That's a minimum of 34 use cases for 7 entities, and 44 use cases for 9 entities) (c) Use Case Realization: Explain how the relations and relationships are used in EACH of the use cases. Provide the complete relational algebra or SQL statements for every use case. (4) Project Time Table (10 points) (a) List major tasks to a be completed (b) For each task, indicate team member responsible for competing task, and planned completion dates.