Report: Database Design, Implementation for Celtic Catering System

This report delves into the fundamental concepts of database design and implementation, specifically tailored for a catering business, Celtic Catering. It begins with an introduction to database systems and then proceeds to create an Entity Relationship Diagram (ERD) to visually represent the relationships between entities such as customers, orders, products, and staff. The report then focuses on developing a relational database using SQL queries within MS Access. This includes creating database tables, defining primary and foreign keys to establish relationships, and implementing data normalization techniques to minimize redundancy and maintain data integrity. Furthermore, the report demonstrates how to produce calculations within reports, create embedded forms for data display, and generate reports from macro queries. Finally, the report showcases how to display a menu upon database opening, providing a comprehensive overview of database design and application within a catering context.