Reference no: EM131442711
Tasks Objectives:
1. Analyse requirements for the construction of a database system based on an understanding of performance issues.
2. Gather and analyse data for database performance and tuning.
3. Configure and tune a database for optimal performance
Task # 1 Submit a work proposal for this assignment by the end of week 4th i.e. 1st April, 2017 (11:55 pm) which must include:
- Understanding of deliverables - a detail description of deliverables
- General overview of proposed plan - initial understanding of solution for the task-2 and task-3.
- Resources identified
The work proposal must be submitted in a word file through the Turnitin link available in Moodle.
Task # 2
a) Discuss the key decisions you would take while creating and configuring a new database which may impact the performance of the database.
Note: The solution must be in your words and should not exceed two pages. The solution should not contain the steps in creating the database.
b) The web link to the Oracle White Paper "Guide for Developing High Performance Applications" is given in the college Moodle web page: As a Database Administrator, discuss the key areas that can allow developers to enhance performance and scalability of applications. Note: The solution for the task-2b must be given in your own words with relevant examples not exceeding 3 pages. The given white paper is for your reference only and your answer should not be limited to this paper only. You may refer various other resources and provided references for the same. Do not simply copy and paste the information from the given white paper.
Task # 3 Discuss how you would analyze and gather statistics of schema objects like tables, clusters or index.
Note: Your solution must also include the necessary SQL commands. These commands must be executed in College Database Lab and include the screenshots for the same.
Evaluation Criteria:
There will be no marks without a viva. Viva will be used as a means to measure the originality of your work.
You would be evaluated on the following:
- Originality of answer, i.e. writing in your own words with some amount of referenced material.
- Oral examination: Your Assignment marks are based on the VIVA which will be conducted upon submission of assignment. The VIVA will be based on the tasks given in the assignment. ZERO marks will be awarded to the student if she / he is absent for VIVA.
- Correct information analysis and presentation in document form.
- Adequate referencing and citation provided
|
What is the firms profit-maximizing quantity
: A firm produces candles. The market for candles is highly competitive, with candles Currently selling for $10. The firm's short-run total cost function is C= 200 + 0.2q2, so its Marginal cost is MC= 0.4q.
|
|
Topic of democracy and race
: In looking at the topic of "Democracy and Race" explain what you believe was the reason why free blacks and Native Americans were not treated as equals to while Americans during this period.
|
|
What do you find to be the benefits of a simplified rating
: Original Contribution: Now that you have analyzed the "Hospital Compare" website and readings:What do you find to be the benefits and disadvantages of a simplified rating system?How does this do as an evaluation tool?Do you think this is good policy?
|
|
Political landscape from the immediate post
: Discuss the official political landscape from the immediate post- World War I era to the early 1950's. Which president during this period was the most liberal?
|
|
Requirements for the construction of a database system
: Analyse requirements for the construction of a database system based on an understanding of performance issues and Gather and analyse data for database performance and tuning.
|
|
Discuss changes in the inflation rate
: Are the following topics ones that would be covered in microeconomics or macroeconomics? The effects of an increase in the supply of lumber on the home-building industry. Changes in the national unemployment rate.
|
|
Explain why the given conflicting situation might occur
: Explain why this conflicting situation might occur and what conclusions the analyst should accept, indicating the shortcomings and the advantages of each method.
|
|
How do you think a functionalist would interpret this
: Describe the picture in detail. How many models, gender, race, etc.What does this representation say about the values held in American culture?How do you think a functionalist would interpret this? What about conflict theorists, feminists and symboli..
|
|
Describe george washington role in the revolutionary war
: Describe George Washington's role in the Revolutionary War, including his leadership, strategies, and relationship with the Continental Army and with Congress. Provide an analysis of the factors that made his generalship successful.
|