Explain the average length of stay per room type

Assignment Help Database Management System
Reference no: EM13308333

1) What is the average length of stay per room type?

2) What is the average number of visitor per room type?

3) What is the base income per room (i.e., length of visit multiplied by the daily rate) during a specified period of time?

4) What is the strongest customer base? Analyze the data in the database and in the application exercise.

To complete this assignment, you will need to do data calculations. Remember to follow good database practice here by not saving your calculations as part of the data table itself (they should appear only in your queries).

Create queries and reports that will provide information to help management at the Queen's Inn to be more competitive and profitable. If you look at the original database you downloaded, you will see that it provides suggestions for the three reports that should be created for The Queen's Inn. These empty templates will give you an indication of what queries and reports you must create for this assignment.

Attachment:- Assignment.rar

Reference no: EM13308333

Questions Cloud

Obtain the force on the car : A laserpointer has a beam intensity of 37 W/m2 and a beam radius of 3.1 mm. what is the force on the car
Identify how business ethics social responsibility : Identify how business ethics, social responsibility, and sustainability are interrelated.
Determine drop structure is to be installed as grade control : To protect the channel from erosion, the normal flow velocity for the design discharge has to be reduced to 7.0 fps or below, and the flow Froude number must be reduced to 0.80 or below.
Evaluate statements of an expression language : Project involves completing and extending the C++ program that evaluates statements of an expression language contained in the module 3 case study.
Explain the average length of stay per room type : What is the average length of stay per room type. What is the average number of visitor per room type. What is the base income per room (i.e., length of visit multiplied by the daily rate) during a specified period of time
Modify the test scores program from the above debug : Also print a report of the each student's test grades, average and final grade as a table, and then print the averages of each Test and overall Test Average, as well as highest Test Grade of all Tests and the student with the highest class grade.
What is the planes new velocity : A plane is flying southeast at 200 km/h. Suddenly, it encounters wind heading 40 degrees north of east at 35 km/h. What is the planes new velocity
What is the maximum amount of cargo that can be carried : A small truck is to be driven down a 4% grade at 70mi/hr. The coefficient of road adhesion is 0.95, and it is known that the baking efficiency is 80% when the truck is empty and decreases by one percentage point for every 100 lb of cargo added.
Assume that you have the following context free grammar : What string came from this sequence of derivations? (It should be obvious whether this is a left derivation or a right derivation.)

Reviews

Write a Review

 

Database Management System Questions & Answers

  Determine the commissions paid to specific employees

Design a query that will allow the finance department to determine the commissions paid to specific employees of the sales department for the month of December.

  Converting user form into 1nf and 2nf

Complete database exercise by converting user form located the evaluation procedures section of the syllabus into 1NF and 2NF.

  Write query to perform inner join of grade and student

Write a query that performs an inner join of the grade, student, and grade_type tables using ANSI SQL 99 syntax (JOIN ON).

  Compute numbers of married men-single men from table

Compute the numbers of married men, single men, married women and single women. Print these numbers on a student summary report.

  Gathering information using cross indexed

Using data mining, it is possible to gather information which has been buried that can be manipulated and cross indexed which could be a valuable information gathering technique for entities.

  Write benefits of using dbms to manage data in program

Describe briefly what are the main benefits of using DBMS to manage data in program applications involving extensive data access.

  Examine hard-to-obtain data from two separate databases

You are interested in examining some hard-to-obtain data from two separate databases. Each database comprises numerical values - so there are 2n values total

  Find bcnf decomposition of relation schema

Consider a relation schema r(A,B,C,D,E, F) and a set of functional dependencies {A BCD,BCDE,BD,DA}.  Determine whether or not (A,E, F) is in BCNF and justify your answer. If (A,E, F) is not in BCNF,find a BCNF decomposition of it.

  Database management challenge than relational database

What is it about a 200 MB video or audio file which makes it so much more of database management challenge than relational database the same size?

  What is the key value of the 4th index

What is the key value of the 4th index record on the top level, assuming each index record points to the record with the highest key value in a block of the next level down?

  Optimistic concurrency control sets few locks on the data

Optimistic concurrency control sets few locks on the data in the database, lowering the isolation level that you use in an application. This allows more applications to run concurrently and potentially increases the throughput of the applications. Th..

  Create an e-r diagram

You have probably seen that already when you tried to create an E-R diagram. Visio uses notation and graphical shapes that are not the same as those in your text. If you look at some of the links to schemas, you will see a similar sort of thing.

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!

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