EER Modelling and SQL Assignment: IMAT5103 Database Systems

This document presents a comprehensive solution for an EER Modeling and SQL assignment, focusing on database design principles. The assignment involves analyzing a problem domain to identify data requirements and designing a database system using modeling techniques. The solution includes an Entity-Relationship Diagram (ERD) demonstrating entities, attributes, and relationships, with justifications for design choices. The ERD showcases 1-to-many relationships between tables such as Client and Booking Clients. The solution also covers attribute lists, enterprise rules, and assumptions. The overall grade of the assignment is 93.3%. This document is a valuable resource for students studying database systems and design, providing insights into creating effective and well-structured database models.

Stage 1 Mark sheet (50%) – Case Scenario & Conceptual DB Design
Criteria justification
EERD –
presentation,
including the use
of consistent and
appropriate
notation
95%
The database design has been designed with proper entities and their
association has been shown in the ERD. Such as there is 1 to many
relationship between Client and Booking Clients tables.
EERD – content
quality, contains
minimum standard
of complexity and
matches scenario
95%
The content of the EERD is accurate as it is according to the
requirements. Such as, Staff table has Staff name, id, address,
contact, from which the details of a staff can be fetched.
EERD –
decompositions
appropriate and
traps eliminated
95%
The decompositions are mostly lossless. From the Client table the
Wedding clients’ data can be fetched.
Associated
attribute lists
appropriate and
complete
95%
As mentioned earlier, the attributes has been properly added and
shown in the EERD. Such as Rooms table has its ID, type, capacity,

room name which shows proper details of a room.
Enterprise rules
complete and
correct relative to
EERD
90%
The associated rules are properly added. Such as the association
between Booking and Payment tables.
Assumptions
complete and
appropriate to
scenario
90%
Every table has its proper link with appropriate tables. Such as,
Food Menu table can be accessible after the booking is done.
OVERALL
GRADE
93.3%