Full Title:Database Management Systems
Module Code:DBMS C7Z08
 
Credits: 5
Valid From:Semester 1 - 2009/10 ( September 2009 )
Module Delivered in No Programmes
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.
Learning Outcomes:
On successful completion of this module the learner should be able to
  1. Discuss the role and core functions of a DBMS
  2. Construct advanced Data Manipulation statements
  3. Understand the fundamentals of Transaction Management
  4. Understand the fundamental concepts of Distributed Databases
 

Module Content & Assessment

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
Assessment Breakdown%
Course Work50.00%
End of Module Formal Examination50.00%

Full Time

Course Work
Assessment Type Assessment Description Outcome addressed % of total Marks Out Of Pass Marks Assessment Date Duration
Continuous Assessment The continuous assessment component will normally consist of a mid-term multiple-choice test, and one group-based, application-oriented or case-based assignment. 2,4 50.00 0 0 n/a 0
No Project
No Practical
End of Module Formal Examination
Assessment Type Assessment Description Outcome addressed % of total Marks Out Of Pass Marks Assessment Date Duration
Formal Exam End-of-Semester Final Examination 1,2,3,4 50.00 0 0 End-of-Semester 0
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 & 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   3.00 Every Week 3.00
Independent Study   2.00 Every Week 2.00
Total Weekly Learner Workload 9.00
Total Weekly Contact Hours 4.00
This course has no Part Time workload.
Resources
Recommended Book Resources
  • Connolly, Thomas, Begg, Carolyn 2009, Database Systems, 4th Ed., 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. Ed., Addison-Wesley [ISBN: 0-321-1222-6]
  • Ramakrishnan, Raghu and Gehrke, Johannes 2006, Database Management Systems, 3rd ed. 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 Ed., Addison-Wesley [ISBN: 0-321-19784-4]
This module does not have any article/paper resources
Other Resources