The assignment should be done in groups of (maximum) 2 persons. Members in each group should contribute equally. Submit one report per group with your solutions to all the tasks. Submission: Submit online a single PDF file containing all tasks, where the filename should be named as 7003ICT_studentID1_studentID2.pdf (note: studentID1 and studentID2 are the group member student numbers).

Task 1: The EERD contain all necessary entities, relationships, attributes so that all the queries can be answered. Correct entity/relationship types (strong or weak) are used. Each strong entity has a PK. Each relationship has the two types of constraints. Correct class-subclass relationships are identified. There are no redundant entities, relationships or attributes (In particular, no foreign key attributes are present in the entities. Please do not confuse ER diagram with schema diagram, and confuse entities with tables.

Task 2: You have mapped your EERD to tables correctly using the appropriate rules. You have marked/listed all primary key and foreign key constraints. Please do not just copy your entities as the tables...usually you need more tables than entities because you may need to map some relationships into tables, and multi-valued attributes into tables. Please do not combined this task with task 3. Task 3: All your tables are in 3NF (and otherwise convincing reasons are provided to justify the use of non-3NF tables). An appropriate data type and length for each attribute. Integrity constraints such as null value constraints and important domain constraints are present. Other important constraints/business rules are identified.