What is the average standard price of rooms in hotel 2

Assignment Help Database Management System

Reference no: EM131842186

Individual Assignment

1. A small city government would like your help developing a data model and database for local parks.

a. Draw a data model (ERD) for a PARK entity with the attributes: ParkID, ParkName, Park Address, and ParkEstablishDate. Add 2 more attributes that you think the city practice might like to record for each park.

Copy this entity into the grade sheet on page 2BELOW the grading sheet and Submit this as a Word document named using the following convention LastNameHMWK1Model (fullerHMWK1Model).

b. Create a table (in a new database) in MS ACCESS for the PARK entity and attributes described above. Make sure to choose an appropriate data type for each field. Save your database using the convention LastNameHMWK1DB (e.g., FullerHMWK1DB). Make sure to designate the primary key.

c. Add data to your table. Add 3 records (rows) to your database. You should incorporate yourlast name in the name of one of the parks . Aside from your name, the rest of the data should be fictitious.

2. Using Access and the hotelSpring18 database, code the SQL for the following queries. You will create and save each query separately and name the queries query 1 through query 7. Please be sure to save each query under the appropriate name.

The query you save under query 1 will be graded as query 1, etc. Each problem must be answered with a single query om a single table as demonstrated in Chapter 3. Do not change any of the data in the hotel spring 18 database. Rename this database to include your last name (e.g., hotel spring 18 Fuller) and submit.

Query1: List the first name, last name and street addresses of any guests that have a street name that includes "Main"

Query 2: Which guests (by number-do not add additional columns to your answer), booked rooms for less than $100. Order the result in ascending order by guest number. If any guest has booked more than 1 room for less than $100, only list that guest one time.

Query 3: List all of the information for rooms in hotel 4.

Query 4: List the bookings (by hotelNo and roomNo) in hotel 5 that began during may 2014

Query 5: How many times has guest 8 booked rooms in hotel 2?

Query 6: What is the average standard price of rooms in hotel 2? Label the resulting column as "Hotel2Average"

Query 7:List the hotels (by name and location) that are not located in Stillwater or tulsa.

Reference no: EM131842186

Questions Cloud

What defenses will the bank assert : Assume that the jurisdiction does not recognize assumption of risk or contributory negligence. The jurisdiction does recognize the defense of comparative.

Why do nonhuman animals deserve or not deserve : Why do nonhuman animals deserve or not deserve moral consideration? What, if anything, makes us morally different from animals?

What causes and factors contributed to the health disparity : Provide two examples of social institutions that are prevalent in American society and explain their functions. How have social institutions played

What assumptions are necessary for part 1 to be true : -Does your argument give good reasons to believe these assumptions are true, or is it just an example of those assumptions?

What is the average standard price of rooms in hotel 2 : List the first name, last name and street addresses of any guests that have a street name that includes "Main"

Something of intrinsic value : According to Aristotle, if we're not motivated by something of intrinsic value, our choices are irrational. Why does he think this

Explain one criticism of both mill and kant : Explain one criticism of both Mill and Kant. Afterward, argue for which ethical approach, on your view is superior. Be specific and provide reasons

Calculate the expected rate on five year treasury bond : Determinants of Interest Rates for Individual Securities. Calculate the expected rate on a 5-year Treasury bond purchased five years from today, E(5r5).

Affirmative proposition : Under what circumstances could one deny the consequent (modus tollens) with an affirmative proposition?

User Account

All Pages