Question: This database will organize a hotels office records. The database will store Guest personal information, guest's Credit Card information, Room information, and guest Transaction information.

This database will organize a hotels office records. The database will store Guest personal information, guest's Credit Card information, Room information, and guest Transaction information.

Guest information includes: First_Name, Last_Name, Middle_Initial, Address, Phone, and Guest_ID.

Room information includes: Available, Occupied, Room_Number, and Rate.

Transaction information includes: Guest_ID, ID, Number, Check_In, Check_Out, and Rate.

Credit Card information includes: Card_Number, Expiration_Date, Security_Code, Name_on_Card, and Guest_ID.

Deliveries and points are as follows:

1 List the entities and attributes.

2 -Must draw ERD for the following proposal.

3 -Draw the Logical RDBMS table design for above.

Step by Step Solution

★★★★★

3.52 Rating (152 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To address the given question lets break down the solution into steps to effectively design a database for organizing hotel office records This involv... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

A Co. has annual fixed Costs Of % 1,40,000. In 2012 sales amounted to 6,00,000, as Compared with 2% 4,950,000 in 2011, and profit in 2012 was 2 42,000 higher than that in 2011. i) At what level of...

A security code consists of a person's first and last initials followed by four digits. (a) What is the probability of guessing a person's security code on the first try? (b) What is the probability...

Credit Card Sales A local fast-food store is considering accepting major credit cards in its outlets. Current annual sales are $800,000 per outlet. The company can purchase the equipment needed to...

KINGS OWN INSTITUTE* Success in Higher Education ICT106 DATA COMMUNICATIONS AND NETWORKS T223 Page 1 of 18 AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD ABN: 72 132 629 979 CRICOS 03171A...

XBRL Audit Instructions With this project you will explore Starbucks' use of XBRL in filing 10-Ks with the SEC. This audit will require you to look at the underlying data in the electronic filing of...

Hello, i need help with question 6 of Part II: Additional Analysis of the CAFR (page 7 of the Case pdf) . I have uploaded the documents needed to answer this question. CITY OF PROVIDENCE, RHODE...

Scenario You and your group work for a multi-national consulting firm. Your team is a group of capital budget consultants and are seeking new engagements. You intend on responding to a Request for...

Hi there , I need help. for my work i need a relevant and well written introduction as well as conclusion to the following below. My work is complete i just need a introduction and conclusion please...

Read the Southwest ApplianceInherent Risk andControlDesign I uploadedthat describesTask 3 beginning on page 20. You will also need to refer back to the case description to perform the assigned task....

Compare and contrast optimization techniques to simulation techniques.

Q.3: find the sum of the following series: 1.- 1 2. Ek=2 k-1 k+1 3.(-1)k-1 , ZK3D1 6k-1 4.-21n(1 Lk=2 In(1 k2. 5.2n=2 n+2 100 n+4 6.2k=12k 2k+1

Compute the following indefinite integral b y first filling out the right triangle below, then performing the corresponding trigonometric substitution. x 2 - 9 2 x d x

Choose any podcast related to macroeconomics, then choose a specific current episode of that podcast that is different from your earlier choices. Your reference will be the name of, and link to, your...

Suppose you borrow money from your parents for college tuition on January 1, 2015. Your parents require four annual payments of $30,000 each, with the first payment due on January 1, 2019. They are...

5. The position of an object as a function of time is given by x = - ct, where and x and t are in SI units. What is the instantaneous velocity of the object when A foul ball is hit straight up into...

Red Raider Company uses a plantwide overhead rate with direct labor hours as the allocation base. Next year, 400,000 units are expected to be produced taking .90 direct-labor hours each. How much...

Analysis: refer to the situation and to figure 3 1. Why do the two sticks rotate to the floor at a different rate or speed? (Hint: Use the moment of inertia) Situation B: Two sticks as shown in...

An organization has a culture in which risk-taking and innovation are highly valued. How might leaders balance the need for innovation with risk management? Group of answer choices discouraging...

The Final Project is to develop a simple database system. The database is to handle multiple records, each composed of several fields. The database will store its information to a file, addition and...

In C++, this project is to develop a simple database system. The database is to handle multiple records, each composed of several fields. The database will store its information to a file, addition...

In C++ develop a simple database system. The database is to handle multiple records, each composed of several fields. The database will store its information to a file, addition and deletion of...

C++ Project Overview The Final Project is to develop a simple database system. The database is to handle multiple records, each composed of several fields. The database will store its information to...