Faculty of Engineering Database Design and Information Management

This report details a database design assignment for the Mega Pizza project, covering requirements analysis and conceptual design. The report begins with an overview of the project's context, including the need to computerize the pizza outlet's records. The first part outlines data, transaction, and business requirements. The second part presents an Extended Entity-Relationship (EER) model and a comprehensive data dictionary. The EER model visually represents entities such as customers, orders, employees, and menu items, along with their relationships and attributes. The data dictionary provides detailed descriptions of each entity's attributes, including data types, lengths, and constraints. The assignment demonstrates a solid understanding of database design principles, data modeling, and the application of these concepts to a real-world scenario.