Reference no: EM132838954
COMP 30021 Database Administration - Middle East College
Learning Outcome 1: Create and maintain a database Server.
Learning Outcome 2: Implement Database security policies
Assignment Objective
The objective is to enable the student to work on a relational database server and involve in creating, securing and maintaining of objects needed for databases and implement database security policies. The theoretical design aspects of ER diagrams that were learnt in the pre-requisite module are being reinforced on implementation mode. Hence, student's ability to think and engage with the topic is tested.
Assignment Tasks
1) Task 1 - Submit a work proposal for this assignment
• Understanding of deliverables - a detail description of deliverables.
• General overview of proposed plan.
• References and resources needed for completion of the given tasks.
2) Task 2 - Assume that you are working as a database administrator for XYZ Company. You are asked write the code(Text) and result(Screenshot of result) with discussion of Tablespace Management as given below,
a.
i. create tablespace having size of 0.5 MB.
ii. create a table with four columns in the tablespace created.
iii. Display current size and free size available in created tablespace in terms of bytes only.
iv. Insert values until it now longer has space for new rows.
v. use appropriate technique to increase its size and reinsert some rows, so that around 50% of tablespace size is free.
b. Create two users using your DBA permissions. Allot tablespace created to these users.
c.
i. Create two different roles and Grant appropriate privileges to these roles.
ii. Allot roles to created users.
iii. Through the Login credentials of the appropriate user, create two table with four different types of constraints each including check constraint.
iv. Create a view, combing the above created two tables using join and grant permission for another appropriate user for the created view.
d.
i. Revoke the privileges from the roles.
ii. Revoke the privileges from the roles.
3) Task 3 - Register yourself for the below given Massive Open Online Course (MOOC). Write a reflective report on the contents learnt (DBMS, Relational Database Management System (RDMS), database servers, SQL Server Management Studio) from the completed course in about 400 words. Also attach the proof of completion of the said course. The proof can be an email intimating your success in the course by the relevant organization OR the copy of Certificate issued by the organization.
Attachment:- Database Administration.rar