User Account

All Pages

Create an entity-relationship model for the Hokie Hotel

Assignment Help Database Management System
Reference no: EM131666922

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

Verified Expert

In this assignment we have create the er diagram from current senario. In this assignment we have create the table and perform the operations like inser and select.in the er digram we have done relationship and make operation to make the table in normalization form.

Reference no: EM131666922

Questions Cloud

What characteristics make the landscapes ordinary : What characteristics make these landscapes ordinary, symbolic, sacred (religious), or derelict? What impact or meaning does this landscape have for you?
Propose a social media marketing plan : Briefly describe your company and product or service, and propose a social media marketing plan to get your company off the ground.
Prepare a standard operating environment : COS20016 - Comprehensiveness and depth of the plan and Rationales presented in the plan - Harvard Referencing Style for all references that you use
Benefits of affirmative action and diversity management : What are two benefits of affirmative action and diversity management? What are two challenges of each?
Create an entity-relationship model for the Hokie Hotel : Assignment - Review of Relational DBMS Concepts. Create an entity-relationship model for the Hokie Hotel business situation using UML class notation
Engage in global marketing : Would you say that your organization is socially responsible and demonstrates the Social Marketing Concept?
Define sequence of exchanges that makes money instantly : The input is a collection of currencies and their exchange rates. Is there a sequence of exchanges that makes money instantly?
What is emphasized is the idea of a calculated risk : What is emphasized is the idea of a calculated risk, which is different from the everyday notion of risk. Explain why you or your leader decided to take risk.
Product development strategy : a) Discuss how product lifecycle affects product development strategy.

Reviews

len1666922

10/3/2017 1:47:35 AM

Subject: Advanced Database Management Systems. Detailed Question: Please provide quote based on guidelines and submissions instructions in the attached document. Briefly describe the data for the Hokie Hotel, 1 page. (5 points) Using UML Class Diagramming notation, create a complete model for all of the data needed for this business situation. Use MS Visio or other tool to draw your diagram. Do not add attributes to the diagram. Record your attributes as a relational model, i.e., class name and list of attribute names, e.g., Patient(C_Patient_PA, T_PatientFirstName_PA, d_BirthDate_PA). Use the following naming convention for your attributes: c_ indicates a key or foreign key attribute; d_ is a date variable; i_ indicates an integer, n_ indicates some numeric value with decimal places, and t_ indicates an attribute contains a text or string value. Also, add a two character class abbreviation, e.g., _pa, indicating the class the attribute is in the Patient table. Note any assumptions. (20 points)

len1666922

10/3/2017 1:47:30 AM

Evaluate your model to determine its normal form. Briefly, 1 paragraph, explain what normal form your model is in and why this is the appropriate normal form. Note any assumptions. (10 points) Write the create table SQL statements needed to implement the ten most important tables in your relational model. Be sure to include appropriate constraints for keys and foreign keys. Use Notepad++ to create a file with .sql extension for this part of the assignment and also submit that file to the assignment 1 folder. (20 points)

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd