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.