Download Coffee Shop Management Database System and more Assignments Construction law in PDF only on Docsity!
ASSIGNMENT 1 FRONT SHEET
Qualification TEC Level 5 HND Diploma in Computing Unit number and title Unit 04: Database Design & Development Submission date 19/08/ Date Received 1st submission
Re-submission Date Date Received 2nd submission Student Name MAI HUU NAM Student ID Bs Class PBIT170101 Assessor name Ms THAI THI THANH THAO Student declaration I certify that the assignment submission is entirely my work and I fully understand the consequences of plagiarism. I understand that making a false declaration is a form of malpractice. Student’s signature NAM Grading grid P2 P3 P4 P5 M2 M3 M4 M5 D2 D
Introduction
I. Develop the database system with evidence of user interface, output, data validations, and querying across
multiple tables (P2)
1. User & system requirements To be able to arrange and manage employees, customers, types of services as well as prices and quantities in a coffee shop, I want to build shop management software that can handle several problems. subject. topics such as managing and storing data in the restaurant's system. Without this software, a store would have to operate without support, making it difficult to calculate and track customers. Customers come to the store, then the staff will Diagramse order that you have ordered and in that order, you will be sorted and delivered to your home or door will take a few minutes or not much. If the invoice you reflect is not good, the manager can control it because it is saved in the software. 2. Entity Relationship Diagram The tables I created to test the program on SQL
1. Table manager Table 1 manager 2.Tables employee Table 2 Employee
5.Tables customer Table 5 Customer
6. Tables Or_der Table 6 Or_der
7. Tables Service detail Table 7 Service detail 8.Tables Orderdish Table 8 Orderdish
3. User interface a.Homepage Figure 1 : User interface- Add new customer
b. login page Figure 2 login page
II. Implement a query language into the relational database system (P3)
In my database, I've got a few tests in SQL to run on MySQL Table 10 select manager
Table 11 Select employee
Table 14 Select dish Table 15 Select Or_der Query 01: Employee's on-call day
Table 16 query 1 Query 02: Employee's shift on day '2022-01-07'
Table 18 query 3 Query 04: Loyal customers have arrived
- Table 19 Query
- Query 05: My day manager paul is on duty on 2022-06-
