Reference no: EM132362680

Database Systems Administration Assignment

This assignment will assess the following learning outcomes:

1. Create and maintain a Database System.

2. Design an enterprise data model that incorporates all of the data used by an organization's business processes.

3. Devise and implement database security policies.

Analyze the following scenario and answer the following questions:

Muscat Opera House wants to maintain records about the different concerts performed in a season. A concert is identified by a concert number and another attribute is concert date, which consists of month, day, year, and time. For each concert there is one conductor, a person who will conduct the concert. Information stored about conductor includes conductor id and conductor name. A conductor may conduct any number of concerts, or may not conduct any concerts. A concert includes the performance of one or more compositions, which are music or songs to be performed in a concert. A composition may be performed at one or more concerts, or may not be performed.

A composition has composition id, composer name, composition name as attributes. Each composition may require one or more soloist, or may not require a soloist. A soloist is a person who performs a given composition on a concert. A soloist may perform one or more compositions or may not perform any composition. Attributes of soloist are soloist id and soloist name. Muscat Opera House wishes to record the date when a soloist last performed a given composition.

Task 1 - Work Proposal: Submit a work proposal for this assignment which must include:

• Understanding of deliverables - a detail description of deliverables.
• General overview of task 2 - initial understanding of solution to tasks 2 and 3.

The work proposal must be submitted in a word file.

Task 2 - Discuss about the following:

a) Architecture of ORACLE Memory Structure. [Your research must covers Oracle SGA, PGA and User Session Information].

b) ORACLE Disk Utilization Structures. (The total number of words for this session would be max. 250 words in addition to relevant diagrams).

Task 3 - As a database administrator perform the following tasks for the scenario given above:

i. Create separate physical structures for the new schema as per OFA guidelines [Create and rename the table space].

ii. Create a Schema with appropriate privileges.

iii. Identify the tables from above scenario and create database tables with correct relationships and constraints.

iv. Create one complex VIEW to any two tables you created above and select data by using it.

v. Create two SEQUENCES and the use it for insert data into any two different tables.

Task 4 - "Oracle's security practices are multidimensional and reflect the various ways Oracle engages with its customers"

In the view of above statement choose an organization in Sultanate of Oman where the security of the data is critical as well as strict security policies are applied on each transactions.

You answer should cover the following:

a) Write the introduction and corporate data security Practices.

b) Discuss about the Security Practices imposed in database server of the organization chosen.

c) Discuss about Oracle Software Security Assurance.

Note - Need only task 2 and task 4. You are required to use appropriate literature review and use of many library resources to complete this assignment. Use correct Citation and CU-Harvard Referencing Style in your assignment.