Requirements for the report on the logical design
The report on the logical design will have to contain at least the following elements:
- The restructured E/R model.
- A description of the restructuring process, including a cost analysis justifying all steps.
This also includes the choice of all primary identifiers.
- The final relational schema, including primary key and referential constraints.
- A list of external constraints reformulated over the relational schema.
- The tables of accesses of the main operations.