Assignment1
For this homework assignment you will create an Entity Relationship model for a business case and then convert the model to a set of relations.
·Read through the following business case for the “BZ Hotel International, Inc.”
·Create an Entity relationship model with the necessary entities, attributes, identifiers and relationships to capture the data requirements.
·All relationships should be labeled with verb phrases.
·Use UML notation for this work.
·Relationship lines should not cross.
·Write out two “relationship sentences” for each relationship using the format:
One may be (or must be) one (or many)
·The following notes can be followed as examples:
Ø Drawing ER Diagrams using Powerpoint:
http://holowczak.com/drawing-entity-relationship-diagrams-using-powerpoint/
(skip to the UML notation part)
·Once your ER model is completed, convert the ER model to a set of Relations.
·Clearly indicate a key (key) and any foreign keys (fk) for each Relation. Each relation should only be shown one time.
·This is an individual assignment. Collaboration or copying another student’s work is not permitted
Business Case:
BZ Hotels International, Inc.
BZ Resorts International, Inc is a company operating a chain of boutique hotels and resorts all over the world. It needs to develop an online booking website, and the information system that will assist with data needs of the business. The system will allow its customer to book online. Currently, BZ chain consists of 10 hotels. Each hotel offers consists of rooms of various types, called accommodations. The website will provide hotel description and amenities. Hotel guests can book their stay by specifying the hotel, type of room, number of travelers, and the dates of stay.
The system should provide the following information:
Hotel contains hotel details, such as hotel name and location (city, state, phone), general description, and list of amenities (such as pool, tennis courts, spa, etc). Each Hotel in the chain is identified by a unique hotel code.
Room contains room details for each room. Each room lists room number, and accommodation type. A hotel can have a number of rooms of each type.
Accommodation type contains information of room type (single room, suite, cottage, etc.), view (ocean view, pool , mountain, etc.), number and type of beds, size in sq. feet, and price.
Booking contains details of the bookings such as room , paying guest, dates of stay (from date, to date), number of guests.
Guest contains details for the paying guest, such as Guest name, address, phone, state ID, credit card number.
Assignment Submission
What you will hand in:
1. An E-R diagram with all of the entities, attributes, identifiers, and relationships. Be sure all relationships are labeled appropriately with verb phrases and the diagram includes an appropriate legend (Name of the Model, Created by, Date/Time, Your Name and Course information,etc.)
2. A set of “Relationship Sentences”
3. The initial set of relations resulting from the conversion from E-R to relational. Clearly indicate keys and foreign keys. For foreign keys specify which table they reference. Indicate any other keys (surrogate, alternate, secondary).