Final report software engineering project 4 hotel management

UEF UNIVERSITY

KHOA CÔNG NGHỆ THÔNG TIN

Final Report

Software Engineering

PROJECT 4:

Hotel Management

Giảng viên : Nguyễn Thị Thanh Trúc

Sinh viên thực hiện:

1. 205052122 Lê Sanh Hoàng Tuấn

2. 205052123 Lâm Thiên Anh

3. 205051684 Nguyễn Hải Sang

4. 205051789 Lại Tu Trung

1

Contents

UEF UNIVERSITY.................................................................................................1

I. Introduction.........................................................................................................3

II. Literature Review................................................................................................5

1. Introduction to Hotel..................................................................................5

2. Introduction to Online Booking................................................................6

III. Business Rules.......................................................................................................7

2. System Function Analysis............................................................................7

IV. Use Case Diagram.............................................................................................8

1. UC-1.0..................................................................................................................8

2. UC-1.1................................................................................................................10

3. UC-1.2................................................................................................................11

V. Class Diagram...................................................................................................13

VI. Sequence Diagrams.........................................................................................14

2.Diagram Booking Invoice..............................................................................15

3.Sequence Diagram Employee Management.................................................16

VII. Sources and methods of investigation..........................................................17

1. Source of investigation..................................................................................17

2. Investigation method.....................................................................................17

3. Scope and limitations of the software..............................................................17

4. Request new software in the future..................................................................18

5. Work assignment...............................................................................................18

VIII. DATABASE DESIGN.................................................................................18

1. Job Specification:.........................................................................................18

1.1 Job Description of Application With Functions:....................................18

1.2 Create MS SQL SERVER database with database name

"QLKhachSan".................................................................................................19

1.3 Design the program system to:...................................................................19

2. Database Specification Diagram:...............................................................19

2.1 Customer data map:.................................................................................20

1. Data diagram of the Rental – Booking Table.........................................20

2.2 Room data map:.......................................................................................21

2

2.3 Data Map of Room Type:........................................................................21

2.4 Data Map of Invoices................................................................................22

2.5 Data Map of Account – User:..................................................................22

1. Data tables....................................................................................................23

X. ERD.......................................................................................................................29

XI. UI.........................................................................................................................29

1. Login Interface:...........................................................................................29

2. Main interface:.............................................................................................30

3. Customer Information Interface:...............................................................31

4. Payment Interface:......................................................................................32

5. Invoice Interface:.........................................................................................33

1. Booking Interface.........................................................................................33

2. Room Management Interface:....................................................................34

8. Password Change Interface:.......................................................................34

9. Statistical reporting interface of invoice list..............................................35

10. Customer list statistics reporting interface:...............................................35

We haven't finished this part yet.............................................................................35

XII. CONCLUSION..................................................................................................36

1. Result..................................................................................................................36

1.1. Advantage....................................................................................................36

- Easy to organize and manage............................................................................36

- User-friendly interface, easy to understand and easy to operate.......................36

- Save a lot of costs.............................................................................................36

1.2. Defect...........................................................................................................36

- Security is not high...............................................................................................36

- Only applicable to small-sized hotels....................................................................36

2. Software development direction.......................................................................36

- Improve the security of the program.....................................................................36

- Updating new functions to meet the needs of advanced management, meeting

large-scale hotels.....................................................................................................36

- Ensure 3 layer model............................................................................................36

3. Conclude............................................................................................................36

3