Solution-Hotel management system database project

Hotel management system database project

Assignment Help Database Management System

Reference no: EM13996954

Hotel Management System Database Project

A hotel is a hive of numerous operations such as front office, booking and reservation, banquet, finance, HR, inventory, material management, quality management, security, energy management, housekeeping, CRM and more. Hotel has a number of rooms and these rooms are of different categories. On the basis of room category, each room has different price. Hotel has a number of employees to manage the services provided to customers. Customer can book the room either online or by cash payment at the hotel. Customer record is stored in hotel database which contains customer identity, his address, check in time, check out time etc. hotel provide food and beverages to their customers and generate the bill for this at the time of their check out.

You need to implement such scenario in a database, create a schema for it, a E-R diagram for it and try to normalize it.

Reference no: EM13996954

Questions Cloud

Marketing of industrial psychology : What differences existed between the two that resulted in their having different experiences - What was it about the zeitgeist of the times that resulted in these outcomes?

What is net power received at the town : If the power is now sent to a town through a transmission line of net resistance 4 Ohms, what is net power received at the town?

Assume world consists of only two countries : Assume a world consists of only two countries: Latvia and Bulgaria, which can produce only two goods: lemons and beef. Latvia can produce 1000 tons of lemons or 500 tons of beef or any linear combination of lemons and beef that satisfies lemons+2×bee..

Write a c function called resistance which reads adc channel : Write a C function called sensor to read the status of all sensors and return a single byte (short int) whose value is 0 if no sensor is active, 1 if the ‘core placed' sensor is active, 2 if the ‘winder' sensor is active, or 3 if the ‘test point' ..

Hotel management system database project : Hotel Management System Database Project - A hotel is a hive of numerous operations such as front office, booking and reservation, banquet, finance, HR, inventory, material management, quality management, security, energy management, housekeeping,..

What is the volume flow rate through the hole : What is the volume flow rate through the hole in L/min. What is the rate in mm/min at which the water level in the tank will drop if the water is not replenished?

What market form has a small number of firms : What market form has a small number of firms but a big market share? what form of market will do well only under inelastic demands.

Create fiscal redistributive initiatives : Most people perceive international public administration to be a set of state structures, institutions, and processes. Opponents of globalization argue that it weakens states, making it difficult for them to sustain social welfare and environmental p..

What are the pros and cons of john rickles five-point : Question: What are the pros and cons of john rickles five-point

User Account

All Pages

Hotel management system database project

Reference no: EM13996954

Reference no: EM13996954

Questions Cloud

Reviews

Write a Review

Database Management System Questions & Answers

Knowledge and data warehousing

Design a database schema

Entity-relationship diagram

Implement a database of courses and students for a school

Prepare the e-r diagram for the movie database

Design relation schemas for the entire database

Prepare the relational schema for database

Data modeling and normalization

Use cases perform a requirements analysis for the case study

Knowledge and data warehousing

Stack and queue data structure

Practice on topic of normalization

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT