Create a schema with appropriate privileges

Assignment Help Database Management System

Reference no: EM131163720

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

Reference no: EM131163720

Questions Cloud

Part interpretes program instructions : Which part interpretes program instructions and initiates all control operations?

What assumptions did you have to make to qualify the risks : What assumptions did you have to make to qualify and quantify the risks? What additional information would have made the risk management planning process easier?

Object of the classes : How does inheritance operate when using the object of the classes?

Evaluate the horizontal force f required to hold the tank : A 20°C water jet strikes a vane mounted on a tank with frictionless wheels, as in Fig. P3.61. The jet turns and falls into the tank without spilling out. If θ = 30°, evaluate the horizontal force F required to hold the tank stationary.

Create a schema with appropriate privileges : Create separate physical structures for the new schema as per OFA guidelines - Create a Schema with appropriate privileges

American psychological association : American Psychological Association (APA) style report (6th edition). Next, review the APA requirements. Then, explain what you believe to be the most challenging aspect of APA formatting.

How to set my property system : Problem: How does ANT read properties? How to set my property system?

Create an argument for diversification of your business : Create an argument for diversification of your business that will be presented to the board of directors or business investors. Develop a strategy for diversification indicating the products and industries for the diversification and how synergies m..

Calculate the horizontal force f needed to hold the barrier : Thirty percent of the jet passes through the slot. The rest splits symmetrically along the barrier. Calculate the horizontal force F needed to hold the barrier per unit thickness into the paper.

User Account

All Pages