DBMS C7Z08 - Database Management Systems

Module Details

Module Code: DBMS C7Z08
Full Title: Database Management Systems
Valid From:: Semester 1 - 2009/10 ( September 2009 )
Language of Instruction: 
Duration: 1 Semester
Credits:: 5
Module Owner::  
Departments: Unknown
Module Description: Students completing this module will understand the role and core functions of a DBMS and the fundamentals of Transaction Management. The student will also have gained a fundamental knowledge of Distributed Databases.
 
Module Learning Outcome
On successful completion of this module the learner will be able to:
# Module Learning Outcome Description
MLO1 Discuss the role and core functions of a DBMS
MLO2 Construct advanced Data Manipulation statements
MLO3 Understand the fundamentals of Transaction Management
MLO4 Understand the fundamental concepts of Distributed Databases
Pre-requisite learning
Module Recommendations
This is prior learning (or a practical skill) that is strongly recommended before enrolment in this module. You may enrol in this module if you have not acquired the recommended learning but you will have considerable difficulty in passing (i.e. achieving the learning outcomes of) the module. While the prior learning is expressed as named DkIT module(s) it also allows for learning (in another module or modules) which is equivalent to the learning specified in the named module(s).
No recommendations listed
 
Module Indicative Content
DBMS Environment and Architecture
International Standards (OSI, ANSI-SPARC, etc.); Three-Level Architecture, Models, DBMS Components
Fundamentals of Transaction Management
Transaction Concepts: ACID Properties, COMMIT & ROLLBACK; Concurrency Control: interference, locking, deadlock; Recovery Management: transaction log, recovery process
Distributed Database Fundamentals
Concepts, DDBMS Architecture; Fragmentation and Allocation; Transparency
Database Application Development
DDL and DML; Advanced SQL
Case Studies
Case studies considering the architecture, configuration and deployment issues of a range of typical DBMS deployments; Open-Source Solutions
Module Assessment
Assessment Breakdown%
Course Work50.00%
Final Examination50.00%
Module Special Regulation
 

Assessments

Full-time

Course Work
Assessment Type Continuous Assessment % of Total Mark 50
Marks Out Of 0 Pass Mark 0
Timing n/a Learning Outcome 2,4
Duration in minutes 0
Assessment Description
The continuous assessment component will normally consist of a mid-term multiple-choice test, and one group-based, application-oriented or case-based assignment.
No Project
No Practical
Final Examination
Assessment Type Formal Exam % of Total Mark 50
Marks Out Of 0 Pass Mark 0
Timing End-of-Semester Learning Outcome 1,2,3,4
Duration in minutes 0
Assessment Description
End-of-Semester Final Examination
Reassessment Requirement
A repeat examination
Reassessment of this module will consist of a repeat examination. It is possible that there will also be a requirement to be reassessed in a coursework element.

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

 

Module Workload

Workload: Full-time
Workload Type Contact Type Workload Description Frequency Average Weekly Learner Workload Hours
Lecture Contact   Every Week 2.00 2
Practical Contact   Every Week 2.00 2
Directed Reading Non Contact   Every Week 3.00 3
Independent Study Non Contact   Every Week 2.00 2
Total Weekly Learner Workload 9.00
Total Weekly Contact Hours 4.00
This module has no Part-time workload.
 
Module Resources
Recommended Book Resources
  • Connolly, Thomas, Begg, Carolyn. (2009), Database Systems, 4th. Addison-Wesley, [ISBN: 0321523067].
  • Mannino, Michael V.. (2005), Database Design, Application Development and Administration, McGraw-Hill, [ISBN: 0071214895].
  • Elmasri, R. & Navathe, S.B.. (2006), Fundamentals of Database Systems,, 5th ed.. Addison-Wesley, [ISBN: 0-321-1222-6].
  • Ramakrishnan, Raghu and Gehrke, Johannes. (2006), Database Management Systems, 3rd ed.. McGraw-Hill, [ISBN: 0071151109].
  • Perry J. & Post G.. (2006), Introduction to Oracle 10g, Prentice-Hall,, [ISBN: 0131957406].
  • Date C.J.. (2004), An Introduction to Database Systems, 8th. Addison-Wesley, [ISBN: 0-321-19784-4].
This module does not have any article/paper resources
Other Resources