In this assignment, students will determine if the database performance can be improved by monitoring response times for frequently used queries, and if the queries were written correctly to produce the expected results.

In a 500- to 750-word document, address the following:

1. Explain the phases and function of the query optimizer.
2. Identify the tools to edit query optimizer strategies.
3. Explain how performance of a database system is measured.
4. Differentiate between response time and throughput.
5. Explain how the physical design of a database influences performance tuning.
6. Explain three ways queries can be altered to increase database performance.
7. Present specific examples to illustrate how implementing each query alteration could optimize the database.

Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student Success Center. Make sure to cite relevant sources to support your ideas.

I’m working on a micro economics multi-part question and need an explanation to help me study.

1. The accompanying table shows the price and monthly demand for barrels of gosum berries in Gondwanaland.

Price of gosum berries per barrel	Native Demand for gosum berries per month
$100	0
$90	100
$80	200
$70	300
$60	400
$50	500
$40	600
$30	700
$20	800
$10	900
$0	1000

1. Using the midpoint method (show your work), calculate the price elasticity of demand when the price of a barrel of gosum berries rises from $10 to $20. What kind of elasticity is this value that you computed for the price elasticity of demand and what does it mean for how demand will change based on a change in price within this price range? (10 points)

1. Using the midpoint method (show your work), calculate the price elasticity of demand when the price of a barrel of gosum berries rises from $70 to $80. What kind of elasticity is this value that you computed for the price elasticity of demand and what does it mean for how demand will change based on a change in price within this price range? (10 points)

1. Notice that the estimates from (a) and (b) above are different. Why do price elasticity of demand estimates change along the demand curve? (10 points)

2. Matilda is downloading music and videos from an online site. She is currently buying three music downloads that cost $3 each and two video downloads that also cost $3 each. The table below indicates what she reports as the marginal utility of the last music download and of the last video download in this combination of purchases.

	Quantity	Price per Download	MU per download
Music downloads	3	$3	60
Video downloads	2	$3	45

As an assignment for her Microeconomics course, Matilda used the marginal utilities that she gave to her 3^rd music download and her 2^nd video download to complete the Experiment Tally Sheet below. Her available budget was $19.00.

Downloads of	mu (score) from 1 to 100	Price of each $3.00	Money spent on	Downloads of	mu (score) from 1 to 100	Price of each $3.00	Money spent on	Total Money	Total Budget
music	mu	mu/$	music	videos	mu	mu/$	videos	Spent	Remaining
1st	?	?	$3.00	1st	?	?	$3.00	$6.00	$13.00
2nd	?	?		2nd	45	15	$3.00	$12.00	$7.00
3rd	60	20	$3.00	3rd				$15.00	$4.00
4th				4th

Total money spent on music: $9.00

Total money spent on videos: $6.00

Total money spent: $15.00

Total budget remaining: $4.00

• A consumer maximizes utility when the last dollar spent on any good generates the same satisfaction as the last dollar spent on every other good. Is Matilda maximizing her utility? Explain your answer. (3 points)
• Should Matilda consume one more video download, to move her closer to her optimum utility? Explain your answer. (3 points)
• Should Matilda consume one less music download and one more video download, to move her closer to her optimum utility? Explain your answer. (3 points)
• Should Matilda consume one more music download, to move her closer to her optimum utility? Explain your answer. (3 points)

3. Brandon and his family often rent movies from the new internet movie streaming service, Xanadu. The table below shows Brandon’s demand schedule for eight movie rentals that Brandon’s family is interested in watching.

Number of internet movie rentals	Willingness to pay each rental
1st	$7
2nd	$6
3rd	$5
4th	$4
5th	$3
6th	$2
7th	$1
8th	$0

a. If the price of each movie rental from Xanadu is $3, how many movie rentals will Brandon buy and how much consumer surplus does Brandon receive? Explain your answer. (5 points)

b. If the price of each movie rental from Xanadu is $5, how many movie rentals will Brandon buy and how much consumer surplus does Brandon receive? Explain your answer. (5 points)

c. If the Xanadu online service offers as many movie rentals as the customer wants to download, all for a one-time fee of $25.00, how many movie rentals will Brandon download and how much consumer surplus will Brandon receive? Explain your answer. (5 points)

d. If the Xanadu online service offers as many movie rentals as the customer wants to download, all for a one-time fee of $35.00, how many movie rentals will Brandon download and how much consumer surplus will Brandon receive? Explain your answer. (5 points)

e. If the Xanadu’s market research showed that Brandon’s demand represented what most of Xanadu’s customers wanted, what would be the most that Xanadu could charge as a one-time fee for all the downloads that the customer wanted? (4 points)

4. Newspaper vending machines are designed so that once you have paid for one paper; you have access to all the papers in the machine and could take multiple papers at a time. However, other vending machines dispense only one item (the item you bought). You do not have access to all the goods (sodas, candy, snacks, etc.) at one time. Using the concept of marginal utility, explain why these vending machines differ? (6 points)

——————————————–

References:

Start the VM for assignment seven. Inside the VM, click Start, type SSMS (to open SQL Server Management Studio), and connect to the instance. Select Databases, then select the AdventureWorksDW2017 database for this assignment.

In this assignment, students will explain database data storage and implement backup and recovery procedures.

Reference the AdventureWorks CTP3 database to complete the steps below. This assignment should be submitted as a Microsoft Word document.

1. In 200–250 words, explain the process of storing database data on a disk.
2. Using what you have learned from the Topic Materials, run a complete backup of the database. Take screenshots of each step used to execute the backup process. Paste the screenshots into the Word document as record of the process.
3. Run a complete restore of the database. Take screenshots of each step used to complete the restore process. Paste the screenshots into the Word document as record of the process.

Instructions

You have had the opportunity to review all of the dimensions of the behaviorism which were influenced by Skinner’s views of overt and covert behaviors. Select one theory of behaviorism other than radical behaviorism that you believe best encapsulates your perspective and critically analyze it. In your paper, address the following:

• Within your analysis, include a synthesis of Skinner’s radical approach to behaviorism with the selected theory.
• Address the limitations and delimitations of the theory that you chose, considering how you would realign it to ensure an effective applied behavior analysis (ABA) delivery system.
  • Address the criticisms and possible deficits within your selected theory.
  • Provide a cost-benefit analysis of the selected theory, explaining how the pros outweigh the cons for its use in applied behavior analysis (ABA).
• Create a plan for realigning your selected theory in order to support effective applied behavior analysis (ABA) delivery.

Suggested Structure for Your Paper

Use these headings and sections within your paper to structure the discussion:

• Analysis of a Preferred Theory of Behaviorism.
• Limitations and Delimitations of the Theory.
• Realignment to Support Effective ABA Delivery.
• References.

Assignment Requirements

• Written communication: Written communication is free of errors that detract from the overall message.
• APA formatting: Resources and citations are formatted according to current APA style and formatting guidelines.
• References: At least 16 scholarly resources, which should be peer-reviewed journal articles or other scholarly articles written within the past 5 years.
• Length of paper: Approximately 12–15 typed, double-spaced pages, excluding title page and list of references.
• Font and font size: Times New Roman, 12 point.
• SafeAssign: Use the SafeAssign Draft option to check your writing and ensure that you have paraphrased, quoted, and cited your sources appropriately. Run a SafeAssign report, saving your paper as a draft. Based on your SafeAssign results, make any necessary changes to your paper before submitting your final assignment to your instructor for grading.
• Submit for grading: Submit your paper to the assignment link in Unit 10 for grading.

Please review the Critique of Skinner’s Principles of Behaviorism Scoring Guide to ensure that you understand and meet the grading criteria for this assignment.