Database Project Proposal
Group Members:
- Angeline Karen – 2440035601
- Michael Christopher – 2440047362
- Vania Natalie – 2440032423
Introduction
The business that our group chooses to design and implement a database management system is a supermarket business. We have created a database management system to manage various databases in the supermarket including their inventory, suppliers, staff, memberships, and transactions. The reason why we create this management system is to make the transaction in the supermarket easier and more organized. The supermarket we are working with is called the “Owl Market”. It is a small supermarket with currently one active manager and some cashiers working on the supermarket. The manager asked us to create a management system where he, as a manager, can manage his supermarket including inserting, updating, and deleting different databases. This management system is also used by the cashiers to perform transactions with the customers.
Database Design
- ERD
2. Relational Schema
- StaffCategory (staffCategoryID, categoryName, hourlySalary, workingDays, workingHours)
- Staff (staffID, fName, lName, address, phoneNo, status, password, staffCategoryID) Foreign Key staffCategoryID references StaffCategory On Delete Restrict On Update Cascade
- Inventory (inventoryID, inventoryName, stock, price, category, supplierID) Foreign Key supplierID references Supplier On Delete Restrict On Update Cascade
- Supplier (supplierID, supplierName, address, phoneNo)
- Orders (orderID, inventoryID, price, quantity, total, invoiceID) Foreign Key inventoryID references Inventory On Delete Restrict On Update Cascade, Foreign Key invoiceID references Inventory On Delete Restrict On Update Cascade
- Invoice (invoiceID, todayDate, paymentMethod, price, staffID, membershipID) Foreign Key staffID references Staff On Delete Restrict On Update Cascade, Foreign Key membershipID references Memberships On Delete Restrict On Update Cascade
- Memberships (membershipID, fName, lName, phoneNo, birthDate, joinDate, points)
- Database Implementation
