This repository contains the design and analysis of a database management system for a restaurant business, using KFC as a case study. This project was developed as a part of the ITDS 221: Database Management System course at the Faculty of ICT, Mahidol University.
The primary goal was to analyze a real-world business's information systems and design a comprehensive database structure to support its key operations.
We analyzed three core business processes of the KFC online platform:
- Online Purchasing Process: The customer journey from selecting items, managing the cart, payment, and order confirmation to delivery.
- Member Registration Process: The steps for a new user to create an account, including data input and identity verification (OTP).
- Loyalty Points Process: How customers earn and redeem points through their accounts after making purchases.
Based on the process analysis, we developed a complete database design, which is included in this repository. The key artifacts are:
- Business Rules: A comprehensive list of rules defining the relationships between entities (e.g., "One customer can create many orders").
- Data Requirements: A detailed breakdown of all data attributes required for each entity.
- ER Diagram (Chen Model): A conceptual data model showing the entities and their relationships using Chen's notation.
- ER Diagram (Crow's Foot Model): A more detailed data model using Crow's Foot notation, illustrating cardinalities.
- Relational Schema: The final logical database design, derived from the ER diagrams through transform mapping. The schema is normalized to the Third Normal Form (3NF).
- Data Dictionary: A complete table detailing every attribute, its data type, and its role in the database (e.g., Primary Key, Foreign Key).
The final database design is structured around the following key entities to support the restaurant's operations:
- Customer
- Account
- Employee
- Branch_Store
- Food
- Category
- Order
- Rider
- Payment
- Promotion
- Reward
- Point