Objectives:
1. Create and maintain a database server
2. Manage database instances
3. Manage database storage
Task # 1
1 Submit a work proposal for this assignment
- 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.
Task # 2 Arabian Beats is a company that organizes musical events in Sultanate of Oman. The company maintains information about its member music bands and the recording they have made. Each music band (A music band is defined by its registration number, name, location and rating) has at least one and possibly many musicians (A musician is defined by his identity number, name and the instrument he plays). A musician belongs to exactly one music band.
A musician has exactly one university degree (A degree has a number, name and degree certificate has name of the degree awarding university). A degree is awarded to more than one musician. The music band has more than one composition to their credit (A composition has composition id, name and rating).
A particular composition is recorded exactly by a music band. Each composition is directed by a music director (Music director has identification number, name and address). A music director may not direct any composition or may direct more than one composition. A music director has exactly one university degree.
In view of the given scenario discuss the following:
a) As DBA discuss how would you Monitor database performance for Arabian Beats.
b) As a database administrator perform the following tasks: [Lab demo is required to manage instance for the above scenario. There will be no marks without a lab demo. The lab demo schedule will be announce in week #8]
1. Create appropriate tablespace for the above scenario as per OFA.
2. Create a Schema with appropriate privileges and use the above created (1i)tablespace as default table space.
3. Create appropriate tables for the above ER-Diagram by identifying and adding foreign keys to the required entities as per the scenario.
4. Create at least four views of which two should be complex views.
5. Create two indexes.
6. Create two synonyms.
Task # 3
The web link to a research paper related with database security is given below: Baccam S., "SANS Oracle Database Security Course author/instructor", 2015, https://www.sans.org/reading-room/whitepapers/analyst/oracle- database-security-secure-34885
(this link is given in college Moodle webpage)
Discuss the following in your own words:
a) Discuss the need of having database security in any institution aslo as DBA what you need to secure.
b) Discuss the differeces between the Authentication and Auditing with appropriate example .
Note:
- The solution must be in your words and should not exceed 3 pages.
- The given research paper is for your reference only and you may refer various authentic resources and provide the references for the same.
- You may include necessary examples and diagrams if any.