Task 1:
Discuss all types of Startup and shutdown modes in database Server.

Task 2:

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 at least one complex View for any tables in the scenario and show the result.

v. Create any one sequence to insert the value into any one of the tables.

Task 3:

Name of orignaztion in Oman Air

There are many steps to secure your system and its data. But one of the first and one that too few organizations take is the development of a security policies that outlines and maps out the enforcement of a security plan that identifies the methods to be followed to maintain security in a system.

Choose an organization in Sultanate of Oman with which you are familiar, possibly your employer, your college or an organization where a friend works.

a) Write the introduction and background of the organization.

b) Identify any three security policies in the selected organization. Investigate and prepare report on these policies for the chosen organization.

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 Harvard Referencing Style in your assignment.