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 tablesusually 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.
Other constraints such as null value constraints and domain constraints are present, and important business rules are also identified.
Task 4:
The SQL commands are logically correct against your final tables in Task 3.