XYZ hotels have many branches, where there is one manager for each branch. A customer may reserve a room through the internet or over the phone, in both ways he/she should give all the needed information for the booking, like name, date of birth, telephone number and the national ID. Once the customer arrives at the hotel, the receptionist will help in booking the room and the check in process in general. The receptionist should check first for room availability and make sure the reservation is done for a single room, double room, or a suite. After the customer finishes his/her stay in XYZ hotels, the receptionist will help in the checkout process by issuing a bill containing a bill number and the customer's name. Before the payment is done the manager checks the bill and gives the confirmation. Besides confirming the bill, the manager also handles

XYZ hotels have many branches, where there is one manager for each branch. A customer may reserve a room through the internet or over the phone, in both ways he/she should give all the needed information for the booking, like name, date of birth, telephone number and the national ID. Once the customer arrives at the hotel, the receptionist will help in booking the room and the check in process in general. The receptionist should check first for room availability and make sure the reservation is done for a single room, double room, or a suite. After the customer finishes his/her stay in XYZ hotels, the receptionist will help in the checkout process by issuing a bill containing a bill number and the customer's name. Before the payment is done the manager checks the bill and gives the confirmation. Besides confirming the bill, the manager also handles

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

Clients wishing to put their property on the market visit the estate agent, who will take details of their house, flat or bungalow and enter them on a card which is filed according to the area, price range and type of property. Potential buyers complete a similar type of card which is filed by buyer name in an A4 binder. Weekly, the estate agent matches the potential buyer's requirements with the available properties and sends them the details of selected properties. When a sale is completed, the buyer confirms that the contracts have been exchanged, client details are removed from the property file, and an invoice is sent to the client. The client receives the top copy of a three-part set, with the other two copies being filed. On receipt of the payment the invoice copies are stamped and archived. Invoices are checked on a monthly basis and for those accounts not settled within two months a reminder (the third copy of the invoice) is sent to the client. Q:Create a Level 1…
System Description: Branches Dream Home has branch offices in cities throughout the United Kingdom. Each branch office is allocated members of staff, including a Manager, who manages the operations of the office. The data describing a branch office includes a unique branch number, address (street, city, and postcode), telephone numbers (up to a maximum of three), and the name of the member of staff who currently manages the office. Additional data is held on each Manager, which includes the date that the Manager assumed his or her position at the current branch office, and a monthly bonus payment based upon his or her performance in the property for rent market. Staff Members of staff with the role of Supervisor are responsible for the day-to-day activities of an allocated group of staff called Assistants (up to a maximum of 10, at any one time). Not all members of staff are assigned to a Supervisor. The data stored regarding each member of staff includes staff number, name, address,…
System Description: Branches Dream Home has branch offices in cities throughout the United Kingdom. Each branch office is allocated members of staff, including a Manager, who manages the operations of the office. The data describing a branch office includes a unique branch number, address (street, city, and postcode), telephone numbers (up to a maximum of three), and the name of the member of staff who currently manages the office. Additional data is held on each Manager, which includes the date that the Manager assumed his or her position at the current branch office, and a monthly bonus payment based upon his or her performance in the property for rent market. Staff Members of staff with the role of Supervisor are responsible for the day-to-day activities of an allocated group of staff called Assistants (up to a maximum of 10, at any one time). Not all members of staff are assigned to a Supervisor. The data stored regarding each member of staff includes staff number, name, address,…
System Description: Branches Dream Home has branch offices in cities throughout the United Kingdom. Each branch office is allocated members of staff, including a Manager, who manages the operations of the office. The data describing a branch office includes a unique branch number, address (street, city, and postcode), telephone numbers (up to a maximum of three), and the name of the member of staff who currently manages the office. Additional data is held on each Manager, which includes the date that the Manager assumed his or her position at the current branch office, and a monthly bonus payment based upon his or her performance in the property for rent market. Staff Members of staff with the role of Supervisor are responsible for the day-to-day activities of an allocated group of staff called Assistants (up to a maximum of 10, at any one time). Not all members of staff are assigned to a Supervisor. The data stored regarding each member of staff includes staff number, name, address,…
Draw the DFD for a distance education university. The enrolment process works as follows: Students send in an application form containing their personal details, and their desired course The university checks that the course is available and that the student has necessary academic qualifications. If the course is available the student is enrolled in the course, and the university confirms the enrolment by sending a confirmation letter to the student. If the course is unavailable the student is sent a rejection letter. Step 1 Read the problem description carefully looking for: * People / organizations / things that supply information to or use information from the system => external entities (EE) * Actions/doing words/verbs => Processes (P) * Movement/exchange of information/data between external entities to processes, and processes to processes => data flows (DF) * Store/record information/data => data stores(DS) Output : * A student (EE) sends in an application…
Premier University's admissions process is well-known to you. Students can access the enrollment portion of their accounts by logging in. Afterwards, individuals can choose the courses they wish to take. When all the courses are submitted, they move on to the awaiting requests. Each request that has been put on hold is approved by the adviser. For the whole registration process, create an SRS document
The State of New York certifies firefighters through- out the state and must keep track of all of them, as well as of the state’s fire departments. Each fire department has a unique department number, a name that also identifies its locale (city, county, etc.), the year it was established, and its main telephone number. Each certified firefighter has a unique fire- fighter number, a name, year of certification, home telephone number, and a rank (firefighter, fire lieu- tenant, fire captain, etc.) The state wants to record the fire department for which each firefighter currently works and each firefighter’s supervisor. Supervi- sors are always higher-ranking certified firefighters. Construct a relational database for New York’s fire departments and firefighters.
A college offers correspondence courses to students. Each course lasts 20 weeks and is based on a weekly study module and progress test. At the end of the course students sit an invigilated examination. The college Registrar deals with enquiries and applications, and students applying who have sufficient qualifications are asked to register by completing and submitting an application form. After approval by the Academic Director, the application form is returned to the Registrar who creates a student file. The Accounts department receive the application form and using information from the student file creates an invoice that is sent to the student. Payments made are registered on the invoice file. The first batch of student material and tests is issued from the library only to students who have paid fees (this information is taken from the invoice file). Progress tests are marked by academic staff and the results, together with comments, are sent out with next week’s study block. The…
R problem Which department shows more favor to female students on the UCB admissions package available in R. Pls answer it with the code, thank you in advance
Business Rules: Each musician at NewTalent should have a name, address, and phone number on the system. The Instruments used in the songs have a unique name, musical genre (i.e. rock, pop, hip hop), and type (i.e. string, piano, guitar). Every album recorded under the NewTalent label has a title, copyright date, format, and an album identifier. Each song recorded has a title and an author. Musicians can play several instruments, and an instrument can be played by multiple musicians. Every album contains several songs, but a song can only appear on one album. Songs are performed by one or more musicians, and a musician can perform numerous songs. Each album has one musician acting as its producer, although a musician can produce multiple albums. Create an ERD for the above scenario that describes its business rules. Use Crow's Foot notations and make sure to include all of the following: All entities correctly identified with Primary key and any foreign key attributes.…
Explain how many fields questions should be asked on a single request for information form ?
A furniture shop wants to sell different types of furniture in online mode. The customers can view the furniture and place orders online. The portal sells different type of furniture such as chairs, tables, sofa etc. For each of the furniture, the portal maintains its unique code, furniture name, the furniture description (such as wooden, plastic), the year it was manufactured and price. Customers can place order for the furniture of their interest. Information about customers such as their name, PAN number, address, phone number and email are collected during ordering. A customer can place more than one order. Each order may comprise of more than one furniture. The customers who place orders with order amount exceeding Rs. 50000 are given a discount of 5% on the order price. In each order, the furniture code, quantity, furniture name, order amount and discount are recorded. Draw the ER-diagram and make sure to indicate key attributes, cardinality and participation constraint