Skip to content

Designed and implemented a relational database using SQL to build a unified system for hotel businesses to enable reservation management of rooms, restaurants, and events.

Notifications You must be signed in to change notification settings

0s9605/hotel-database-management-systems

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Hotel Database Management Systems

Goals

  • Allow a hotel’s departments to generate reports on customer, employees, hotel locations, event reservations etc.
  • Provide information to enhance or improve marketing efforts to specific targets like room bookings and restaurant bookings
  • Gain insight for revenue/budgeting reports based on customer habits and seasons (via dates booked)
  • Permit inventory management department and facilities department to maintain inventory and coordinate with suppliers
  • Allow Chains to keep track of the performance of their hotels
  • Let Hotels maintain a record of rooms, amenities, restaurants and their booking data

Entity Relationship Diagram

About

Designed and implemented a relational database using SQL to build a unified system for hotel businesses to enable reservation management of rooms, restaurants, and events.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • TSQL 100.0%