Assignment - Review of Relational DBMS Concepts

1) Describe the data required for the Hokie Hotel presented in the situation described in this file: DBProblemDescriptionHokieResorts-1.docx.

2) Create an entity-relationship model for the Hokie Hotel business situation using UML class notation. This Visio file contains a template that you can use: Assignment1TemplateV1.vsdx.

3) Explain why your entity-relationship model is in third-normal-form (or justify if not 3NF).

4) Create the SQL DDL that creates the 10 most important tables represented in your UML Class diagram.

Directions: Create a MS Word document that contains your description of the data needed, ER model (which should be created with Visio or other drawing tool with UML class diagram template), relational model associating attributes with classes, and your explanation of your database normal form.

You should create your DDL file using Notepad++, which will help you to check syntax and aids our grading process. When completed, please upload your Word document and DDL text file under the "Assignments" tab.  Please use a document naming convention that allows us to determine your name.  EXAMPLE: "LastName_FirstName_Assn1.docx or .txt .sql".

Assessment - Your ER diagram, normal form explanation, and DDL will be evaluated for correctness and completeness. Correctness is how well your model represents the problem, e.g., the model includes the correct entities and relationships among them, along with appropriate attributes. Completeness is how well your model satisfies all of the requirements of the problem situation.

Attachment:- Assignment Files.rar