Tasks Objectives:
1. Undertake operations required of a Database Administrator
2. Manage client-server connections using RDBMS Net Services
3. Evaluate requirements and select appropriate parameters to ensure effective storage management in a database system.
Task # 1 Submit a work proposal 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-4.
- Resources identified
The work proposal must be submitted in a word file through the link available in Moodle.
Task # 2 FreshMart Co. is an upcoming hyper market chain in the gulf region. They are planning to launch several branches across the gulf countries. The various branches of FreshMart Co. would be spread across different cities of the gulf region and their head office would be located in Muscat city. These chains of hyper markets work round the clock. The management of this organization is also planning to provide online shopping facility for its customers.
Consider you are working as a DBA for developing a system for this organization.
Identify and elaborate a suitable database architecture for implementing the various business requirements of FreshMart Co.
Discuss the various challenges you may face as a DBA in establishing application and data security of FreshMart Co.
Task # 3 Reade the research article "DATABASE SECURITY - ATTACKS AND CONTROL METHODS" As a database administrator, summarize in your own words (not more than 1.5 pages) on the control methods for the database threats. List and discuss at least five methods.
The given article is for your reference only and your answer should not be specific for a certain database system but it should be a generic one. You may consult various other sources and need to provide the desired references appropriately.
Task # 4 Your database lab is a networked lab. Provide the details of parameters that need to be set at database server and client side for proper connectivity between them.
You may consider ORACLE DBMS software in the lab as back end. Create simple form using VB.NET or ASP.NET or JAVA API as front end tool. Explain the necessary steps with relevant commands to configure the database connectivity to the application.
Article - International Journal of Information Sciences and Techniques (IJIST) Vol.6, No.1/2, March 2016
DATABASE SECURITY - ATTACKS AND CONTROL METHODS by Mubina Malik and Trisha Patel