Tasks Objectives:
1. Create and maintain a database server
2. Manage database instances
3. Manage database storage Marks
Task # 1 Submit a work proposal for this assignment which must include:
- Understanding of deliverables - a detail description of deliverables
- General overview of proposed plan - initial understanding of solution for the task-2 to task-3.
- Resources identified
The work proposal must be submitted in a word file through the link available in Moodle. 2
Task # 2 a. Assume that you are responsible for selecting a new DBMS product for Sohar Hospital.
To undertake this exercise, you must first establish a set of requirements for the hospital and then identify a set of features that a DBMS product must provide to fulfill the requirements. Discuss the process of evaluating and selecting the best DBMS product for Sohar Hospital. 4+8
b. As a database administrator perform the following tasks: [Lab demo is required. There will be no marks without a lab demo.
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 a database tables with correct relationships
NOTE : Include the necessary screenshots in the solution.
Task # 3 The web link to ORACLE white paper related with SQL LOADER is given below: Stenoish .J "Express Mode Loading with SQL*Loader in
Oracle Database 12c June 2013, ORACLE white paper is given in college Moodle webpage)
Discuss the following in your own words:
a) Discuss What is SQL LOADER.
b) Discuss the benefits of of SQL LOADER.
the draft Assignment white paper of DBA module.
How many words it should be because it's a small assignment
Attachment:- SQL LOADER.rar