Ask a question from expert

Ask now

Database Design for a Hypothetical Hotel

3 Pages665 Words101 Views
   

Added on  2019-09-16

About This Document

This assignment focuses on designing a database for a hypothetical hotel that keeps track of all of their rooms in the hotel and all of the guests in each of the rooms. It includes tasks such as establishing relationships between tables, identifying redundancy in the design, and providing the best database design for the data provided.

Database Design for a Hypothetical Hotel

   Added on 2019-09-16

BookmarkShareRelated Documents
General DirectionsThis assignment is focused on database design, so there is no database to work with. It will be your job to design one. You will not create the database in MySQL; we will cover that topic later. Instead,you will demonstrate your understanding of design principles. In the last task, you will create your own database design. I do not want a drawing of the database design, although that may help you conceptualize the design, so I recommend it if it helps. However, do not turn in the drawing.For the final task, your database design should be a collection of tables that are described one at a time in this format. The foreign key is optional and should only be listed if it applies.tablename(column1, column2, ...columnN)primary key: columnname[foreign key: columnname]The tablename should be the name of the table and the parentheses should hold the list of all of the column names in that table. Here is an example of a table named HOTELROOM that has four columns (RoomNum, type, price, GuestNum). The Primary key column name is RoomNum and the foreign key column name is GuestNum:HOTELROOM(RoomNum, type, price, GuestNum)Primary Key:RoomNumForeign Key:GuestNumThe database design should include all tables listed in any order.Task 01:There is a hypothetical hotel that keeps track of all of their rooms in the hotel and all of the guests in each of the rooms. They have two tables that have the following structure:HOTELROOM(RoomNum, type, price)Primary Key:RoomNumGUEST(GuestNum, name, address)Primary Key:GuestNumNote that there is currently no relationship between the tables.Here is the data (see below).
Database Design for a Hypothetical Hotel_1

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database Design and Implementation: ER-Model, Relational Schema, Constraints, and Business Intelligence
|5
|1023
|448

Structured Query Language and Server Services PDF
|13
|1744
|22

BMIH4004 Practical Tasks for Hotelier Software | Desklib
|7
|3002
|369

The Database Systems and Design
|13
|1520
|16

Open International Journal of Informatics
|15
|1431
|23

Diploma of Information Technology: Assessment Task 1
|7
|1343
|389