a) Draw an ERD for the following scenario. Scenario: The project is for the Moon Hotel. There are many rooms in the hotel. Each room has a unique room number, type and price. There may be many customers in each room. But a customer may rent only one room. Each customer has a unique customer_id, name, date of birth and a phone number. There are many departments in the hotel. For each department you need to store deptno, and name. Departments are identified by deptno. There are many employees working for a department, but an employee works for only one department. Each employee has an emp_id, name and salary. One of the employees is the manager of a department. An employee may serve many rooms but only one employee serves each room.

a) Draw an ERD for the following scenario. Scenario: The project is for the Moon Hotel. There are many rooms in the hotel. Each room has a unique room number, type and price. There may be many customers in each room. But a customer may rent only one room. Each customer has a unique customer_id, name, date of birth and a phone number. There are many departments in the hotel. For each department you need to store deptno, and name. Departments are identified by deptno. There are many employees working for a department, but an employee works for only one department. Each employee has an emp_id, name and salary. One of the employees is the manager of a department. An employee may serve many rooms but only one employee serves each room.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: What is the difference between a scenario and a use case? When do you use each construct? Explain…

A: Use case: An example of a use case is a description of a series of actions that a system or…

Q: This is like previously asked questions, but the instructor has added extra requirements and a…

A: Algorithm:StartDefine the GroceryItem class with attributes name and quantity.Implement member…

Q: Select all the correct responses. There is more than one correct response. Which of the following…

A: In software engineering, the process of requirements engineering and design involves the systematic…

Q: Each course has a unique identifying code (a 4 character string, e.g., 7FXU) and a longer ti (e.g.,…

A: ENTITY RELATIONAL (ER) MODEL which refers to the high-level conceptual data model diagram. ER…

Q: The variable's "type" is not enough to describe it. Each variable has unique data and…

A: What is variable has unique data and characteristics: A variable having unique data and…

Q: [For this question, you can use a program such as Excel or Word (paste into the quiz, then format at…

A: The given information is a factorial matrix that shows the combinations of two variables: "THIS" and…

Q: User research should divide the design into many user views

A: Introduction User research is the process of gathering data and insights about the needs, behaviors,…

Q: eople like to give gifts to their love ones on different events. Trendy Gifts is a gift shop that…

A: # People like to give gifts to their love ones on different events. Trendy Gifts is a gift shop that…

Q: Build an Enhanced ERD using the below business description. Granite Sales Company keeps information…

A: Granite Sales Company, a dynamic business entity, manages a comprehensive information system to…

Q: List the name of each employee. If the employee has a supervisor, then also list the name of the…

A: Answer(a)select name as Employee_Name,SupervisorSSN as Supervisor_Name from EMPLOYEE;

Q: Create a Crow’s Foot ERD for each of the following descriptions: During some period of time, a…

A: Actually, ERD stands for Entity Relationship Diagram.

Question

a) Draw an ERD for the following scenario.
Scenario: The project is for the Moon Hotel. There are many rooms in the
hotel. Each room has a unique room number, type and price. There may be
many customers in each room. But a customer may rent only one room. Each
customer has a unique customer_id, name, date of birth and a phone number.
There are many departments in the hotel. For each department you need to
store deptno, and name. Departments are identified by deptno. There are
many employees working for a department, but an employee works for only
one department. Each employee has an emp_id, name and salary. One of the
employees is the manager of a department. An employee may serve many
rooms but only one employee serves each room.
b) Write any one Select Statement for the above scenario.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Provided Data and Asked Question

VIEW

ER Diagram

VIEW

Select query for selecting room details with employee number

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

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.

Similar questions

Write down all the different kinds of use cases.
Student Registration for an Online Portal In this simple project, we will get the student details and insert them into the database. A unique student roll number (student_id) will be generated once the registration is complete. If the student is already registered, we will send a message saying the student already exists.
Please write down the cmdlet for the following questions: We use this cmdlet to start a Background Job. We use this cmdlet to start a Scheduled Job. We use this cmdlet to remove a Background Job. We use this cmdlet to remove a Scheduled Job.
Create a comprehensive flowchart of the interactions.
You just started your summer internship with NU Bank as part of its growing development team. Your first assignment is to design and build two classes that are to be utilized in both the banks website and internal applications. The first is a loan class representing a loan contract. The second is a customer class representing the individual receiving the loan. You will be building the business logic classes, so you don’t have to worry about forms for communicating with the user or data access classes to communicate with the database. To test your classes, you will use them in a test application. The requirements for your classes and the testing application are as follows:• You are to design and build 2 components of the Loan Processing System (LPS). There will be one class to represent loan contracts, and another to represent customers.• Each class should have at least 2 members and 2 methods.• The LPS will need to be able to check that the customer is at least 21 years old. A…
Please explain the steps of the coding.
Provide details on how to use a decision table to generate test cases.
You are a Data Scientist at United Health. You want to check if a patient will develop cancer based on smoking habits. Please write the R code to generate confusion matrix. Use the following details. After splitting the dataframe, we have test_cancer, and training_cancer. The outcome variable is develop_cancer.
If you're performing user research, it's a good idea to break down the overall design into many different user views.