Question

Rest in Peace (RIP) is a hotel management company with 'unique' properties. RIP maintains a database...

Rest in Peace (RIP) is a hotel management company with 'unique' properties. RIP maintains a database to track their properties, rooms, bookings, and employees. Assuming you have entities for: PROPERTY - one row per property (hotel, lodge, inn, etc) ROOM - one row per room within a property EMPLOYEE - one row per employee working for RIP, Inc. 1. Using the above entities, describe a 1:M relationship and a M:N relationship. How about a 1:1 relationship? For this item, describe the relationships in terms of business rules. Remember that business rules should describe both sides of the relationship and should be able to be used to directly create the ERD.

2. Create an ERD using the relationships described in 1. Use Crow's foot notation for this.

3. If you were to covert the model as described in 2 to a set of tables and their relationships (i.e. a relational schema), what would the attributes for each of the entities be?

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The database is to handle the bookings in a company that arranges one-day guided group tours...
The database is to handle the bookings in a company that arranges one-day guided group tours from the different hotels in a resort town to various destinations. Specific details are: Every hotel is described by: A unique hotel name, address, and phone number. Every destination is described by: A unique destination name, and type. Every guide is described by: A unique guide id, name, and all the languages that he/she speaks. Every tour is described by: A date, number of...
Following is the whole proposal and for that I need a logical design (ERD), Q. Map...
Following is the whole proposal and for that I need a logical design (ERD), Q. Map all different types of entities and relationships, provide definitions of entities and relationships. Zameen.com is Pakistan's first and biggest property portal and is amongst the world's top five property portals. It was founded in 2006 and has since revolutionized Pakistan's real estate industry by linking online buyers and sellers in a very convenient way, making it a worldwide household name among Pakistanis. This is...
Please read the article and answear about questions. Determining the Value of the Business After you...
Please read the article and answear about questions. Determining the Value of the Business After you have completed a thorough and exacting investigation, you need to analyze all the infor- mation you have gathered. This is the time to consult with your business, financial, and legal advis- ers to arrive at an estimate of the value of the business. Outside advisers are impartial and are more likely to see the bad things about the business than are you. You should...
Discuss ethical issues that can be identified in this case and the mode of managing ethics...
Discuss ethical issues that can be identified in this case and the mode of managing ethics Enron finds itself in this case. How would you describe the ethical culture and levels of trust at Enron? Provide reasons for your assessment. THE FALL OF ENRON: A STAKEHOLDER FAILURE Once upon a time, there was a gleaming headquarters office tower in Houston, with a giant tilted "£"' in front, slowly revolving in the Texas sun. The Enron Corporation, which once ranked among...
What tools could AA leaders have used to increase their awareness of internal and external issues?...
What tools could AA leaders have used to increase their awareness of internal and external issues? ???ALASKA AIRLINES: NAVIGATING CHANGE In the autumn of 2007, Alaska Airlines executives adjourned at the end of a long and stressful day in the midst of a multi-day strategic planning session. Most headed outside to relax, unwind and enjoy a bonfire on the shore of Semiahmoo Spit, outside the meeting venue in Blaine, a seaport town in northwest Washington state. Meanwhile, several members of...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT