项目作者: JackyC415

项目描述 :
Database implemented with JDBC and SQliteStudio; GUI frameworks Jframe & Swing
高级语言: Java
项目地址: git://github.com/JackyC415/sqlite-database-hotel-management-system.git
创建时间: 2018-01-25T05:51:15Z
项目社区:https://github.com/JackyC415/sqlite-database-hotel-management-system

开源协议:BSD 2-Clause "Simplified" License

下载


Database-Hotel-Management

Hotel management database application implemented with JDBC and SQLite.
Designed user interface with JFrames and JPanel in Eclipse WindowBuilder; utilized Java GUI framework Swing.

Database Application Description:

Application is capable of reserving rooms for incoming guests, extracting multiple tables with data; such as Employee, Department, Guest info etc.. , updating room/checkstatus, and removing guests information upon checkout.

Use Case Description:

Hotel managers have access to login administration.
New Customer Form (Reception) for new guests reservations.
User is able to request data from the following tables: Employee, Department, ManagerInfo, Room, and CustomerInfo.
User is able to search for room and the pick up service.

Relational Database Schema:

Checkstatus(c_guestid, c_roomid, c_checkstatus, c_date, c_time, c_paymentstatus)
Department(d_id, d_name, d_managerid, d_budget)
Driver(dr_id, dr_age, dr_name, dr_gender, dr_style)
Employee(e_employeeid, e_departmentid, e_salary, e_job, e_name, e_department)
Guest(g_id, g_name, g_gender, g_countryname, g_roomReserved, g_checkstatus, g_depotsit)
Manager(m_id, m_name, m_salary, m_age, m_gender, m_departmentID)
PickUpCar(p_id, p_year, p_brand, p_driverid, p_availability, p_airport)
Room(r_id, r_checkstatus, r_cleanstatus, r_price, r_bedtype, r_roomNumber, r_guestid)
Many to Many Relationships: Room with Guest and Manager with Department.