Full Title:Database Management Systems
Language of Instruction:English
Module Code:DBMS C7005
 
Credits: 5
Valid From:Semester 1 - 2016/17 ( September 2016 )
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 and non-relational 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. Demonstrate a thorough understanding of the Transaction Management theory and practice
  4. Demonstrate an understanding of the fundamental concepts of Distributed Databases
  5. Discuss the role and nature of non-relational 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
Database Recovery
Recovery Management: transaction log, recovery process; Checkpoints
SQL: Advanced Joins & Functions
Outer Joins; Single-row Functions
Database Application Development
DDL and DML; Advanced SQL; Set Operators
Stored Procedures
Developing stored database procedures
Non-Relational Databases
Key-value stores, document store, scalability
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,5 50.00 0 0 End-of-Semester 0

Part 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,5 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   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, 4th Ed., Addison-Wesley [ISBN: 0321523067]
  • Elmasri, R. & Navathe, S.B. 2010, Fundamentals of Database Systems,, 6th ed. Ed., Addison-Wesley [ISBN: 0136086209]
  • Stephen Morris, Peter Rob, Carlos Coronel, Keeley Crocket 2013, Database Priniciples: Fundamentals of Design, Implementations and Management, 2nd Ed. Ed., Cengage Learning, Inc. [ISBN: 140806636X]
  • Peter Lake, Paul Crowther 2013, Concise Guide to Databases: A Practical Introduction (Undergraduate Topics in Computer Science),, Springer
This module does not have any article/paper resources
Other Resources