Download Assignment Front Sheet and more Assignments Programming Languages 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 Date Received 1st submission Re-submission Date Date Received 2nd submission Student Name Nguyen Quang Ngoc Student ID GCD Class GCD1101 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 Grading grid
P1 M1 D
CHAPTER 1: STATEMENTS OF USER AND SYSTEM REQUIREMENTS (P1)
1. Overview About The Problem
As a result of the rapid growth of the tourist sector in Da Nang, hotel services are in increasingly high demand. Some hotels in the city of Da Nang have had challenges with their hotel management systems due to the city's fast growth. This hotel management project was conceived with the intention of making hotel administration simpler and more effective. In addition, the primary purpose of this project is to develop a hotel database management system. This project enables the front desk employees to manage client flow by allowing them to book rooms, check out, and perform several other tasks.
Obtain all staff rights. Staff: Add customer information at checkin and print out invoice at checkout. Check, edit, delete customer information when there is an error. Add order information for each room, specific checkin and checkout time. Edit hotel services. Figure 2 : Access Rights Functions of restaurant management system: Create employee information, shift, customers, hotel rooms, services. Read information about employees, shift, customers, rooms, services. Update employee information, shift, customers, hotel rooms, services, invoices. Delete employee information, shift, customer, hotel room, service, invoice.
Statistical functions of the system: Statistics of hotel revenue by month, quarter, year. Statistics of employees who work diligently to offer bonuses. Statistics of customers who regularly book hotel rooms to offer incentives. Statistics of the most booked room types. Statistics of the most booked services.
2. Database Design With Explanations
