Full Title:Database Administration
Language of Instruction:English
Module Code:DBMS C7006
 
Credits: 5
Valid From:Semester 1 - 2016/17 ( September 2016 )
Module Delivered in 3 programme(s)
Module Description:Students completing this module will understand the role and core functions of a Database Administrator. They will also have used SQL commands for database security, integrity and backup, as well as having implemented database procedures and triggers. The student will have gained knowledge in the process of selecting and evaluating a DBMS, physical database design and performance management.
Learning Outcomes:
On successful completion of this module the learner should be able to
  1. Control databases using SQL statements for security and integrity
  2. Perform backup and recovery procedures
  3. Perform database tuning
  4. Explain the process of selecting and evaluating Database Management Systems
 

Module Content & Assessment

Indicative Content
Overview of DBA Functions and Responsibilities
Selection and Evaluation of DBMS’s; Installing the database; Implementing standards, policies and procedures; Running the database at peak performance
Physical Database Design
Examining storage level of database; File structures; Estimating database size
Backup and Recovery
Failure Types; Recovery tools; Database backup
Security
Threats and countermeasures; Access Control; System auditing; Using views
Maintaining Integrity
Using Database Triggers for integrity
Database Tuning Techniques
Indexing; File Clustering; Partitioning; Tracing queries
Assessment Breakdown%
Course Work100.00%

Full Time

Course Work
Assessment Type Assessment Description Outcome addressed % of total Marks Out Of Pass Marks Assessment Date Duration
Class Test n/a 4 30.00 0 0 n/a 0
Multiple Choice Questions n/a 1,2,3,4 20.00 0 0 n/a 0
Group Project n/a 1,3 50.00 0 0 n/a 0
No Project
No Practical
No End of Module Formal Examination

Part Time

Course Work
Assessment Type Assessment Description Outcome addressed % of total Marks Out Of Pass Marks Assessment Date Duration
Class Test n/a 4 30.00 0 0 n/a 0
Multiple Choice Questions n/a 1,2,3,4 20.00 0 0 n/a 0
Group Project n/a 1,3 50.00 0 0 n/a 0
No Project
No Practical
No End of Module Formal Examination
Reassessment Requirement
No repeat examination
Reassessment of this module will be offered solely on the basis of coursework and a repeat examination will not be offered.

DKIT reserves the right to alter the nature and timings of assessment

 

Module Workload & Resources

Workload: Full Time
Workload Type Workload Description Hours Frequency Average Weekly Learner Workload
Lecture   2.00 Every Week 2.00
Practical   2.00 Every Week 2.00
Directed Reading   2.00 Every Week 2.00
Independent Study   2.00 Every Week 2.00
Total Weekly Learner Workload 8.00
Total Weekly Contact Hours 4.00
Workload: Part Time
Workload Type Workload Description Hours Frequency Average Weekly Learner Workload
Lecture   1.00 Every Week 1.00
Practical   2.00 Every Week 2.00
Directed Reading   3.00 Every Week 3.00
Independent Study   2.00 Every Week 2.00
Total Weekly Learner Workload 8.00
Total Weekly Contact Hours 3.00
Resources
Supplementary Book Resources
  • Connolly, Thomas & Begg, Carolyn 2009, Database Systems, Addison-Wesley [ISBN: 0321523067]
  • Mannino, Michael 2011, Database Design, Application Development, and Administration, 5 Ed., ediyu [ISBN: 0983332401]
  • Craig S. Mullins 2012, Database Administration: The Complete Guide to DBA Practices and Procedures, 2nd Ed., Addison Wesley [ISBN: 0321822943]
This module does not have any article/paper resources
Other Resources

Module Delivered in

Programme Code Programme Semester Delivery
DK_KCOMP_7 Bachelor of Science in Computing 6 Group Elective 2
DK_KCEDD_7 Certificate in Database Development 1 Elective
DK_KCEDD_7 Certificate in Database Development 2 Elective