Reference no: EM131472505

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:

Muscat Food Services is an F&B company providing catering services to medium and large functions. Each function to which Muscat Food Services is providing catering is called an event. Muscat Food Services has many employees working in different shifts. An event is described by event id, event name, customer name 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, 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 modes in database Server.

Task 3:

a. Create an ER-diagram for the above scenario.

b. 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. Convert Entity Relationship Diagram in to database tables with correct relationships and constraints.

iv. Create at least two complex View for any tables in the schema.

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 organisation.

b) Identify any three security policies in the selected organisation. 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.