Download Assignment 2 - Database - Vo Minh Quoc and more Essays (university) Database Management Systems (DBMS) in PDF only on Docsity!
ASSIGNMENT 2 FRONT SHEET
Qualification TEC Level 5 HND Diploma in Computing Unit number and title Unit 04: Database Design & Development Submission date 10/11/2021 Date Received 1st submission Re-submission Date Date Received 2nd submission Student Name Vo Minh Quoc Student ID GCD Class GCD0904 Assessor name Do Duy Thao Student declaration I certify that the assignment submission is entirely my own work and I fully understand the consequences of plagiarism. I understand that making a false declaration is a form of malpractice. Student’s signature Quoc Grading grid
P2 P3 P4 P5 M2 M3 M4 M5 D2 D
Summative Feedback: Resubmission Feedback:
Grade: Assessor Signature: Date: Signature & Date:
Chapter 1 - Development of the database system (P2 - P3)
1.1 Final Mock-up of the application: In this part, I designed the interface of user with all function that I stated in the assignment 1 to match with user’s requirment. − User requirment: The pharmacy manages hundreds or thousands of medicines, serving the essentials of thousands of students in treatment; additionally, customers (students) can buy medicines through giving prescriptions or saying the kind of their diseases or their requirements. So, to serve customers and calculate the total cost in terms of the medicines or products in general bought or sold quickly, neatly, and accurately, pharmacies need to computerize their medicine catalog management, pharmacist, and customer management rapidly and accurately. A. Login and function interface: o I designed a login interface for user to login. Figure 1. Login interface
o After clicking the button login, user must enter their ‘user name’ and ‘password’ Figure 2. Login interface. o Then, the interface will turn into function interface Figure 3. Function interface
Figure 5. 'New catergory' button o After clicking ‘New medicine’ button: Figure 6. 'New medicine' button o After clicking ‘New bill’
Figure 7. 'New bill' button. o After clicking ‘New pharmacist’ button: Figure 8. 'New pharmacist' button o After clicking ‘New pharmacist’ button:
C. View the information: o When the user clicks ‘View’ button, the interface will turn into other interfaces to view table ‘Category’, ‘Medicine’, ‘Bill’, ‘Phamacist’, ‘Customer’, ‘Branch’, ‘Medicine most order’, Medicine least order, Months (highest evenue), Months (lowest evenue), ‘Entered times (customer). Figure 11. 'View' button o After clicking ‘Category’ button:
Figure 12. 'Category' button o After clicking ‘Medicine’ button: Figure 13. 'Medicine' button
o After clicking ‘Bill’ button: Figure 16. 'Bill' button o After clicking ‘Medicine most order’: Figure 17. 'Medicine most order' button.
o After clicking ‘Medicine least order’: Figure 18. 'Medicine least order' button. o After clicking ‘Months (highest revenue)’: Figure 19. 'Months (highest revenue)' button.
D. Update and detele the information: o When the user clicks ‘Update’ button, the interface will turn into another to update ‘Category’, ‘Medicine’, ‘Phamacist’, ‘Customer’, ‘Branch’,’Bill’. And when they click one of five buttons the interface will turn into another interface for them to edit or delete the information. Figure 22. 'Update' function 1.2 Queries to create database with results
A. ERD:
- In this part I will show the logical design (ERD) of my application to give the same of both ERD and Database diagram created. All elements in this ERD that was explained in my assignment 1 report so, I will not explain again in this assignment. Here is the logical design: Figure 23. Logical design.
