Reference no: EM132176786

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 scenario and answer the following questions:

Consider the following scenario modelling project management activities in an organization.

A software company has many business domains. Each business domain is managed by a domain head. A business domain is characterized by domain number, domain name and domain description. Domain head has employee number, name and skill set description. A domain head can handle more than one business domain. A domain has may have more than one project or may not have any project. A project has a project number, project title, project duration, priority and project description. A project should belong to at least one domain or might belong to more than one domain. A business domain has many project managers. There should be at least one project manager in a business domain. A project manager belongs to exactly one business domain. A project manager has an employee id, name, grade and experience details. A project is managed by exactly one project manager. However, a project manager may manage more than one project or may not handle any project. All project manager reports to their respective business heads. All project should have one quality expert. A quality expert might supervise quality related activities of many projects or may not handle any project. A quality expert has an employee id, name and certification details.

Task 1:

Discuss about the all kinds Oracle Database instance architecture.

[Your research must covers Memory, Process, Application and Networking Architectures.]

Task2:

As a database administrator perform the following tasks for the scenario given above: [Lab demo is required. There will be no marks without a lab demo. The lab demo schedule will be announced in week #9]

i. Create separate physical structures for the new schema as per OFA guidelines
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 two complex views for any tables in the scenario and show the result.
v. Create any one sequence to insert the value into any one of the table you created.

Task 3:

"As a backup administrator, your principal duty is to devise, implement, and manage a backup and recovery strategy. In general, the purpose of a backup and recovery strategy is to protect the database against data loss and reconstruct the database after data loss".

In the view of above statement choose an organization in Sultanate of Oman where customer data is more valuable for them and ensuring data preservation, data transfer and more security policies and procedures for protecting their data.

Please cover the following based on the organization you selected:

a) Write the introduction and business of the organization.

b) Identify all kinds of back up options applied by the company and their recovery solutions.

[Your answer covers in the areas like Data protection, Data Preservation, Data transfer, Logical Flashback features/ flashback DB, Data recovery advisor etc...]

You are required to use appropriate literature review and use of many library resources to complete this assignment. You will achieve maximum marks for using correct Citation and CU-Harvard Referencing Style in your assignment.