Querying a Database
Complete and submit Cases and Places 2, p. AC 135. You will use the BeachCondo Rentals database created in the case study for Unit 2. You will query this database for several types of information and sort the results. You will create and save six queries, and will submit the database containing the queries.
The steps for the queries are listed in the textbook alphabetically. Use this alphabetic list for naming your queries as you save them. For instance, name the query created in step a as Query A, and so forth.
2: Querying the BeachCondo Rentals Database
a. Find all the units that rent for less than $1,000 per week and have at least two bedrooms. The user should see all fields in the query result.
b. Find all units that are on the fourth floor. (Hint: The first digit of the Unit Number field indicates the floor.) Include the Unit Number and the Weekly Rate fields in the query result.
c. Find all units that have more than one bedroom and more than one bathroom and provide linens. Include the Unit Number, Bedrooms, and Weekly Rate fields in the query results.
d. Owner BE20 offers a 15% discount on the weekly rate if renters rent fore more than one week. What is the discounted weekly rate for his units? Your result should include the unit number, bedrooms, bathrooms, sleeps and discounted weekly rate in your results. Be sure the discounted rate appears as currency.
e. List the owner's first and last name as well as telephone number. Also include the unit number and the weekly rate. All owners should appear in the result even if they currently have no rental units.
f. Find the highest and lowest weekly rate.
Attachment:- ShastaRama_1.zip