Draw an E-R Diagram that models an information system that keeps track of booking information for several hotels within a chain. Use the notation that is used in the text and in class. State any other assumptions you make. a. b. Each hotel has a unique hotel identifier along with a name, location, and phone number. Each hotel has different numbers, and types of rooms. For a given hotel, each room is assigned a room number, type (single, double, suite, etc.) and standard price. c. Each hotel customer has a unique customer number, a name, a phone number, and a credit card number. d. A customer books a specific room for a given date and number of days. e. The actual price of a given room may differ between customers due to the customer being a preferred or corporate customer. State any assumptions you make. Be clear.

Draw an E-R Diagram that models an information system that keeps track of booking information for several hotels within a chain. Use the notation that is used in the text and in class. State any other assumptions you make. a. b. Each hotel has a unique hotel identifier along with a name, location, and phone number. Each hotel has different numbers, and types of rooms. For a given hotel, each room is assigned a room number, type (single, double, suite, etc.) and standard price. c. Each hotel customer has a unique customer number, a name, a phone number, and a credit card number. d. A customer books a specific room for a given date and number of days. e. The actual price of a given room may differ between customers due to the customer being a preferred or corporate customer. State any assumptions you make. Be clear.

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

Similar questions

Think about what you'd want to see in an entity identifier, then write it down.
It is not enough to just name a variable; the definition must additionally provide the variable's "type" and "extra characteristics." To reiterate, each variable is distinguished from others by characteristics that are independent of the data type. We would be really appreciative if you could explain the idea that would enable us to exactly describe any given variable.
Selection structures are vital in computer programming, although they do have certain restrictions. The same procedure is required for many consumers, online clients, and other sorts of transactions regardless of the medium. Do various occupations have varying requirements? What sets these structures apart from the rest?
Domain Model Class Diagram LAB 6: Academic Scenario With the following information given below, design a domain model class diagram. A university has only full-time and part-time instructors. The details of an instructor include name, address, email, and number. The students in the university can enroll in a seminar and the details to be stored for each student include name, student number, and email. Each seminar consists of seminar name and seminar code. Full-time instructors are responsible for taking the seminars. Each seminar can be taken by at least one and at most two instructors. Part-time instructors can teach courses as well as full-time instructors. Each course consists of a name and course code. Students can register for a maximum of five courses per semester. A course can either be a university elective or an area elective. The availability of an area elective course depends on the number of available students for that course. A student can either be a bachelor, master's,…
Based on the provided information below, what would be the entities and the relationship between each one? Thank you!
draw Entity Relationship Diagram (ERD) for scenairo: “There is a group of employees who have run the website. Three admins are responsible to check registration forms filled by babysitters. An accountant is responsible to check fees payments. All these employees are supervised by the manager. Each babysitter can register on the website one time by filling in her data including first and last names, qualifications, fee rate per hour (25 SAR per Hour), contact information, address, photo, and years of experience. The system will issue for her id and registration date. Mothers can make booking as many as they need. For each time, they must fill in their names, contact information, address, number of children, the date and time (e.g. from 2:00 PM to 4:PM) of booking. The website will generate the booking report including mother’s data, babysitter’s contact data, number of booked hours, fee rate per hour, fees total amount, and tax (%5). To make a payment, the mother needs the…
i need the answer quickly
To completely define a variable, it must include both its 'type' and its 'additional characteristics.' To put it another way, all variables have a data type as well as other attributes. Explain the concept that will allow us to describe any variable's attributes.
Construct an E-R diagram for the following hospital: In this hospital, we have many patients (characterized by social security number, name, insurance, the admission date, and the date of check out) received by medical doctor. Each medical doctor in the hospital is characterized by: ID number, name, and specialization. For every patient, the medical doctor will perform one or more tests and examinations to diagnose his illness. Each test or examination is characterized by an ID, name, date, time, and result. In your ER-Diagram, you must specify the key for each entity and all relationship cardinalities.