database design project

Introduction Background on case study with clear aims and objectives of the report. The Conceptual Data Model Class diagram, constraints and assumptions • Represents all information requirements • Good use of assumptions to justify modelling decisions • Use of constraints to model features that cannot be represented by modelling features. Discussion on design decisions (minimum two pages) A discussion of the major design decisions taken in construction of the class diagram. Your discussion should justify the representation chosen to capture the data requirements. The Relational Data Model Model showing the relations, attributes, datatypes, primary and foreign keys. Implementation Table Listings •Requires SQL CREATE TABLE statements for each table together with any constraints (primary key, foreign key, not null, unique and check). Conclusion Critical evaluation of the final product and the entire exercise.