
Principles of Information Systems (MindTap Course List)
12th Edition
ISBN: 9781285867168
Author: Ralph Stair, George Reynolds
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Data Modeling using ERD
We want to realize a
- 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

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 2 steps

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.Similar questions
- Data modeling is most often accomplished through the use of a(n) __________________. a. entity-relationship diagram b. data-flow diagram c. functional decomposition diagram d. activity diagramarrow_forwardThe ______________ model is a simple but highly useful way to organize data into collections of two-dimensional tables called relations.arrow_forwardA new sales ordering system needs a relational database that contains a customer table, a product inventory table, and an order table. Use a word-processing, graphics, or spread-sheet program to draw an entity-relationship diagram showing the relationships among these entities. Next, design each of these tables showing the keys and attributes to be included in each table. Include five sample records for each table.arrow_forward
- _______________ is a special purpose programming language for accessing and manipulating data stored in a relational database.arrow_forwardIn the hierarchy of data, what is the difference between a data attribute and a data item? What is the domain of an attribute?arrow_forwardAccess path A database table is composed of records and fields hold data. Data is stored in records. A field is a part of a record and contains a single piece of data for the subject of the record. The access path for finding the list of books is AUTHOR: AuthorID, Lname BOOKAUTHOR: AuthorID, ISBN BOOKS: Pubdate, ISBNarrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningSystems ArchitectureComputer ScienceISBN:9781305080195Author:Stephen D. BurdPublisher:Cengage LearningFundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrPrinciples of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning

Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning

Systems Architecture
Computer Science
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Cengage Learning

Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning

A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr

Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning

Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning