DATABASE SYSTEMS ADMINISTRATION

This assignment will assess the following learning outcomes:

Learning Outcomes

1. Create and maintain a database server

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

3. Devise and implement database security policies Analyze the scenario and answer the following questions:

Barka Event Management Services is an F&B company providing event management services to medium and large functions. Each function to which company is providing event management service is called an event. Company has many employees working in different shifts. An event is described by event id, event name, and customer id and start date. The attributes of employee include employee id, name, address and birth date. A shift is defined by the shift number, shift timing and shift name. An event must have at least one employee assigned and may have any number of employees assigned.

An employee may be assigned to maximum one event at a time or may not be assigned to any event. More than one employees work in a shift. An employee may or may not have any shift or may have more than one shift assigned. An event may have one or more shifts. A shift belongs to more than one event.

Each employee has a specialization certificate. Attributes of certificate are certificate number, certificate name and description. An employee should have at least one specialization certification or may have more than one certification. A specialization certificate may not be held by any employee or may be held by many employees.

Task 1: Submit a work proposal for this assignment on or before end of 5th Week, which must include:

- Understanding of deliverables - a detail description of deliverables
- General overview of task 2 - initial understanding of solution to task2

The work proposal must be submitted in a word file through the link available in Moodle.

Task 2:

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

Task 3:

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 4:

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.