Write a report which documents the logical design of a database to support the Information System

Write a report which documents the logical design of a database to support the Information System requirements described in the Appendix A. Your logical design should be carried out using the top-down and bottom-up techniques that you have been taught in the module.
1) Identification of the entities.
For each entity found in the attached case study, provide a suitable name and a description. Your description should indicate why it is necessary in the database.
2) Definition of tables.
For each table, list the table name, the entity that the table implements (if appropriate), the primary key of the table (name and data type) and other identified attributes (names, data types and all other constraints).
3) Proof of normalization.
Demonstrate that you have normalized the data for the tables to 3rd normal form (removing repeating groups, resolving functional dependencies).
4) Produce an Entity-Relationship Diagram to complete the Logical Design Produce an Entity-Relationship diagram for the database system, showing all entities (with attributes and primary keys), relationships (with relationship name and
cardinality),.
5) Evaluation of your design
Write a short (250 word) evaluation of your database design, discussing the features of the requirements that you have included and any problematic issues that were difficult to resolve.