Data Modeling using ERD We want to realize a database for hotel management. The database must allow the management of several hotels. Each hotel is described by: number, name, address, and telephone. Those hotels are divided into different classes. Each class is described by the number of stars and the description. Each hotel contains several rooms. A room is characterized by: number, price per night, and telephone. However, each room in a hotel belongs to a category. A category is described by: code and description (example: single, double...). We also wish to register the information of the clients who want to book rooms. A client is characterized by: number, name, first name, date of birth, nationality, and email. A client can make one or more room reservations. Each reservation concerns only one room and one client. A reservation is characterized by: number, start date of residence, and duration (number of nights). We must have a trace of the reservation modality. A reservation can be done in two ways either online, by completing a reservation form, or at an agency where the client fills a reservation file. Also we must register the information about the services (breakfast, lunch, dinner ...) ordered during the residence of a client: service number, description, date of service, and price. During the residence, a client can order zero or more services. A service can be ordered by zero or more clients. Design a representation of the data in terms of entities, attributes and relationships between entities. Construct an ERD diagram to depict this representation. Show the cardinalities using (min, max) or CHEN notation and all necessary information.

Principles of Information Systems (MindTap Course List)

12th Edition

ISBN:9781285867168

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter5: Database Systems And Applications

Section: Chapter Questions

Problem 4PSE: Using a graphics program, develop an entity-relationship diagram for a database application for an...

See similar textbooks

Related questions

Question

Data Modeling using ERD

We want to realize a database for hotel management. The database must allow the management of several hotels.

Each hotel is described by: number, name, address, and telephone.
Those hotels are divided into different classes. Each class is described by the number of stars and the description.
Each hotel contains several rooms. A room is characterized by: number, price per night, and telephone.
However, each room in a hotel belongs to a category. A category is described by: code and description (example: single, double...).
We also wish to register the information of the clients who want to book rooms. A client is characterized by: number, name, first name, date of birth, nationality, and email.
A client can make one or more room reservations. Each reservation concerns only one room and one client. A reservation is characterized by: number, start date of residence, and duration (number of nights).
We must have a trace of the reservation modality. A reservation can be done in two ways either online, by completing a reservation form, or at an agency where the client fills a reservation file.
Also we must register the information about the services (breakfast, lunch, dinner ...) ordered during the residence of a client: service number, description, date of service, and price.
During the residence, a client can order zero or more services. A service can be ordered by zero or more clients.

Design a representation of the data in terms of entities, attributes and relationships between entities. Construct an ERD diagram to depict this representation. Show the cardinalities using (min, max) or CHEN notation and all necessary information.

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.