Database Design & Management with MySQL
A detailed look at projects where I used MySQL to design, implement, and optimize database systems.
Cineplex Ticketing System
Description:
The database supports critical functions such as customer sign-up, movie ticket booking, transaction processing, and mobile ticket generation, enabling customers to browse movies, select seats, make payments, and receive mobile tickets, while tracking transactions and customer activity.
Objective:
To ensure smooth customer experiences by managing data integrity, supporting high transaction volumes, and enabling efficient querying of customer, ticket, and movie data.
Download & View Pptx below
Database Design for Canadian Flowers Online Store
Description:
Project involves designing a relational database for Canada Flowers. The database models the key business processes of browsing products, placing orders, managing recipients, processing payments, and ensuring timely deliveries.
Objective:
The database ensures accurate order processing, inventory control, and customer management while reducing redundancy and maintaining data integrity.
Download & View Pdf below
Employee Management System
Description:
This project involves designing and implementing a relational database for a hypothetical company that manages multiple employees, job codes, and projects.
Objective:
The database should ensure data integrity through primary and foreign key constraints, reduce redundancy through normalization, and allow efficient data manipulation and retrieval using SQL queries.
Download & View Pdf below
Tasks
Cineplex Database System
-
Requirements Gathering
-
Business Rules & Assumptions
-
E-R Modeling
-
Table Design & Creation )
-
Data Integrity Controls
-
Sample Data Entry
-
SQL Queries
Canada Flowers Online Store Database
-
Business Process Analysis
-
Business Rules Definition
-
E-R Modeling
-
Relational Schema Conversion
-
Normalization
-
Sample Data Representation
-
Functional Dependency Analysis –
Employee–Project Management Database
-
Table Creation
-
Database Diagram
-
Data Integrity Controls
-
Data Insertion
-
SQL Queries
-
Error Handling & Debugging
🔑 How to View and Understand the Projects?
1. Open the Files
-
Cineplex Ticketing System → open the PPT Canada Flowers Online Store → open the PDF
-
Employee Management System → open the PDF
2. Read the Basics
-
Description & Objective → explains the purpose (what problem it solves) and goal (what the database ensures, e.g., integrity, scalability).
3. Identify the Structure
-
Entities/Tables → key objects (CUSTOMER, ORDER, PROJECT, EMPLOYEE, MOVIE, etc.).
-
Relationships → ER diagrams or schema to see how tables connect.
-
Constraints → primary/foreign keys, integrity rules.
4. Connect to Real-World Use
-
Cineplex → customer signs up → books movie → pays → gets mobile ticket.
-
Canada Flowers → customer browses → places order → enters recipient info → pays → delivery confirmed.
-
Employee Management → company adds employees → assigns jobs/projects → queries employee/project data.