Reference no: EM132400924
Middle East College
Module: Database Systems Administration (COMP 1011)
Level: 6
This assignment will assess the following learning outcomes:
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:
A laboratory has several chemists who work on one or more tasks. A chemist may use certain kinds of equipment on each task. A chemist is described by an id, phone number, address, work experience etc. Attributes of equipment include equipment number, cost and manufacturer name. A task is described by task id, task start date and client name. A task has more than one chemist working on it. A chemist must have at least on equipment assigned to him. Equipment can't be assigned to more than one chemist at a time. Hence, a task must have minimum one equipment assigned.
A manufacturer produces more than one equipment. However, equipment belongs to exactly one manufacturer. Manufacturer attributes include manufacturer id, manufacturer name and manufacturer address. A chemist may or may not have an advanced certification. A certification may be completed by more than one chemist. Attributes of certification include certificate name, register number and name of the awarding body.
Task 1
Work Proposal:
Submit a work proposal for this assignment on or before of 5th Week i.e. 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 through the link available in Moodle.
Task 2:
Discuss about the following:
a) architecture of ORACLE Transaction Processing in Distributed System
[Your research must covers Oracle Remote Transactions, SQL for Distributed Systems, Database Naming and Link Resolution]
b) Managing the Distributed Transactions.
(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: [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 [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 an index to any TWO tables you created above.
v. Create two SEQUENCES and the use it for insert data into any two different tables.
Task 4:
"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 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 explain about the data protection strategies of the organization .
b) Discuss about :
• Assess the Recovery Requirements.
• Back Up and Recovery Foundations.
c) Discuss about the database software Recovery Manger, Recovery Area, Recovery features and best practices.
Attachment:- Database Systems Administration.rar