Reference no: EM13943819
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
|
What other factors must managers address
: The concept of opportunity cost and examination of how to calculate the cost of alternatives over single and multiple time periods
|
|
Construct an x bar- chart
: Construct an x bar- Chart. (Make sure to determine the upper and lower control limits.) Is the process in control? Explain why or why not. Construct an R- Chart. (Make sure to determine the upper and lower control limits.)
|
|
Compute free cash flow and the cash flow adequacy ratio
: Rollins Inc. is considering expanding its operations into different regions of the country. Compute free cash flow and the cash flow adequacy ratio. Comment on Rollins' ability to expand its operations.
|
|
How does character development help control stress
: How does character development help control stress management, contribute to manners, and strengthen dealings with the public.
|
|
Query this database for several types of information & sort
: 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.
|
|
Identify the groups type and structure
: Create an 8- to 12-slide Microsoft PowerPoint presentation covering either three existing or three new different group types, explaining how they benefit addiction treatment approaches. Include the following: Identify the groups' type
|
|
Compute the amount of cash collected from customers
: Singleton Inc. had accounts receivable of $365,000 at January 1, 2009, and $410,000 at December 31, 2009. Compute the amount of cash collected from customers.
|
|
Determine the rotation angle of the second degree of freedom
: Determine the rotation angle of the second degree of freedom, theta2, that must be used to bring the effector to the specified configuration.
|
|
Compute the amount of cash payments to suppliers
: Blackmon Company reported net income of $805,000 and cost of goods sold of $1,525,000 on its 2009 income statement. Compute the amount of cash payments to suppliers.
|