Question

In: Computer Science

project on hotel management in dbms with er diagram and table (sql) please give answer

project on hotel management in dbms with er diagram and table (sql)

please give answer

Solutions

Expert Solution

Short Summary:

  • Provided the ER diagram and tables for the requirement.

ER DIAGRAM:

Entities:

  • Hotels
  • Rooms
  • Facilities
  • Cost
  • Location

TABLES:

CREATE TABLE Hotel(
HotelID INT PRIMARY KEY,
HotelName VARCHAR(30),
emailID VARCHAR(50),
PhoneNumber INT)

CREATE TABLE Rooms(
RoomNo INT PRIMARY KEY,
RoomType VARCHAR(20),
HotelID INT,
FOREIGN KEY(HotelID) REFERENCES Hotel(HotelID))

CREATE TABLE Cost(
costid INT PRIMARY KEY,
RoomNo INT,
amount DECIMAL(18,2),
FOREIGN KEY(RoomNo) REFERENCES Rooms(RoomNo))

CREATE TABLE Facilities(
Fid INT PRIMARY KEY,
FacilityName VARCHAR(20),
HotelID INT,
FOREIGN KEY(HotelID) REFERENCES Hotel(HotelID)
)

CREATE TABLE Location(
LocationID INT PRIMARY KEY,
street VARCHAR(20),
City VARCHAR(20),
state VARCHAR(20),
pincode INT PRIMARY KEY)

**************************************************************************************

Feel free to rate the answer and comment your questions, if you have any.

Please upvote the answer and appreciate our time.

Happy Studying!!!

**************************************************************************************


Related Solutions

Draw an ER diagram with these attributes ( ER diagram for SQL for a library database)...
Draw an ER diagram with these attributes ( ER diagram for SQL for a library database) DRAW ER DIAGRAM AS ONE FULL LIBRARY SYSTEM, NOT DIFFERENT FOR EACH ATTRIBUTE. Attributes :           Customer Cust_ID: key identifier, required, simple, single valued Cust_Name{ first name, last name}: Key Identifier, simple;composite, multivaried   Address{street, city,zip,state}: Customer address, required, composite, single can be derived from zip (placeholder, there should be another attribute here to represent the books taken out by the customer. Not sure.)           Inventory Book_ID:...
Draw an ER diagram with these attributes ( ER diagram for SQL for a library database)...
Draw an ER diagram with these attributes ( ER diagram for SQL for a library database) Attributes :           Customer Cust_ID: key identifier, required, simple, single valued Cust_Name{ first name, last name}: Key Identifier, simple;composite, multivaried   Address{street, city,zip,state}: Customer address, required, composite, single can be derived from zip (placeholder, there should be another attribute here to represent the books taken out by the customer. Not sure.)           Inventory Book_ID: Key identifier, required, simple single valued Book_Name: Key identifier, required, simple, single-valued Genre:...
please tell me how I can construct er diagram on Netflix and on hotelmangement in dbms...
please tell me how I can construct er diagram on Netflix and on hotelmangement in dbms and also tell me how I convert er diagram of Netflix in third normal form(3nf). also explain the queries .
Need SQL Tables Final Project should be included ER, NER, Table diagrams and SQL statements. The...
Need SQL Tables Final Project should be included ER, NER, Table diagrams and SQL statements. The final project is about developing an auction Web site. The details are as follows: BA is an online auction Web site. People can buy and sell items in this Web site. Buyers are people who like to buy items, and sellers are people who like to sell items. •Each seller can sell items. •Each item has a bidding start time, an end time, and...
DBMS Create/Insert/Update SQL I need the create, insert, and update SQL statement for this table as...
DBMS Create/Insert/Update SQL I need the create, insert, and update SQL statement for this table as if it were being added to MySQL (please give explanations for each line of SQL code and a copy of the code as it would be entered into the query by itself: Customer PK Customer ID Text Phone Number int name text address ID int email text FK vendor ID int Vendor is the name of the table the FK comes from.
DBMS Create/Insert/Update SQL I need the create, insert, and update SQL statement for this table: Customer...
DBMS Create/Insert/Update SQL I need the create, insert, and update SQL statement for this table: Customer PK Customer ID Text Phone Number int name text address ID int email text FK vendor ID int Vendor is the name of the table the FK comes from.
I am doing a project and need an ER diagram, as well as some, create table...
I am doing a project and need an ER diagram, as well as some, create table statements in SQL. Here is what I have so far. My database will be a hospital management system. It will be able to keep track of patients and doctors, as well as each of their attributes, to better help organize the hospital's data. Each patient and doctor will be searchable via an id, and the user will be able to run reports as well....
What is the Database Management System (DBMS)? Give example companies who are using DBMS in Saudi...
What is the Database Management System (DBMS)? Give example companies who are using DBMS in Saudi Arabia? (write max 200 words with evidence in your own words)
Instructions: Draw an ER diagram for the following description. Identify the keys and give the cardinality...
Instructions: Draw an ER diagram for the following description. Identify the keys and give the cardinality of all relationships (e.g. 1:1, N:1, N: M). Make sure you note your assumptions. Assume you are creating a database for a library system with the following properties: The library contains one or several copies of the same book. Every copy of a book has a copy number and is located at a specific location on a shelf. A copy is identified by the...
Only needs DB SQL statements. Final Project must be included HER, NER, Table diagrams and SQL...
Only needs DB SQL statements. Final Project must be included HER, NER, Table diagrams and SQL statements. The final project is about developing an auction Web site. The details are as follows: BA is an online auction Web site. People can buy and sell items in this Web site. Buyers are people who like to buy items, and sellers are people who like to sell items. • Each seller can sell items. • Each item has a bidding start time,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT