Reference no: EM131283714
Task 1: Objectives:
1. Create and maintain a database server
2. Manage database instances
3. Manage database storage
Task Submit a work proposal for assignment
- Understanding of deliverables - a detail description of deliverables
- General overview of proposed plan - initial understanding of solution for the task-2 to task-3.
- Resources identified
The work proposal must be submitted in a word file through the link available in Moodie.
Task
Arabian Beats is a company that organizes musical events in Sultanate of Oman. The company maintains information about its member music bands and the recording they have made. Each music band (A music band is defined by its registration number, name, location and rating) has at least one and possibly many musicians (A musician is defined by his identity number, name and the instrument he plays). A musician belongs to exactly one music band. A musician has exactly one university degree (A degree has a number, name and degree certificate has name of the degree awarding university). A degree is awarded to more than one musician. The music band has more than one composition to their credit (A composition has composition id. name and rating). Aparticular composition is recorded exactly by a music band. Each composition is directed by a music director (Music director has identification number, name and address). A music director may not direct any composition or may direct more than one composition. A music director has exactly one university degree.
In view of the given scenario discuss the following:
a) As DBA discuss how would you Monitor database performance for Arabian Beats.
b) As a database administrator perform the following tasks: (Lab demo is required to manage instance for the above scenario. There will be no marks without a lab demo. The lab demo schedule will be announce in week #8]
1. Create appropriate tablespace for the above scenario as per OFA.
2. Create a Schema with appropriate privileges and use the above created (1i)tablespace as default table space.
3. Create appropriate tables for the above ER-Diagram by identifying and adding foreign keys to the required entities as per the scenario.
4. Create at least four views of which two should be complex views.
5. Create two indexes.
6. Create two synonyms.
|
Beneficial for the student to develop
: You are hired to teach a struggling student more effective study skills. Drawing from research findings regarding effective study strategies, identify one strategy that you think would be beneficial for the student to develop.
|
|
How could you change those perceptions
: What was the most surprising myth you read about in your text regarding suicide? Why? How could you change those perceptions?
|
|
Analyze a set of facts that occurred in company
: Identify the issue that you are dealing with; present the problem to your boss. Is it a concern about discriminatory treatment? Are the employees engaging in concerted activity?
|
|
Define supply chain management
: Define Supply Chain Management and its role in a company's ability to compete effectively in the market.
|
|
Create and maintain a database server
: Create appropriate tablespace for the above scenario as per OFA and create a Schema with appropriate privileges and use the above created (1i)tablespace as default table space.
|
|
From the photos and other information presented
: From the photos and other information presented on this page and from other sources you may find, evaluate the work using the critical analysis example at the conclusion of Chapter 4 as a guide.
|
|
Tolerable characteristics of being a team member
: Then, reflect on an experience that you had being a member of a team. Classify the good, bad, and tolerable characteristics of being a team member.
|
|
What is the accessible population
: Dr. Kim wants to conduct a study on memory in nursing home residents. He contacts local nursing homes and selects 50 residents from their resident lists to participate in his study.
|
|
What strategies might implement in assessing suicide risk
: A friend of yours has called you and said he does not want to be alive anymore, that the world would be better without him. From a professional perspective, what strategies might you implement in assessing suicide risk?
|