Module Details

Module Code: DBMS C7008
Full Title: Database Management
Valid From: Semester 1 - 2019/20 ( June 2019 )
Language of Instruction:English
Duration: 1 Semester
Credits: 5
Module Owner:: Stephen Larkin
Departments: Unknown
Module Description: A student completing this module will have the ability to design, implement and test database transaction code, stored procedures and triggers. The student will also have gained a fundamental knowledge of Distributed Databases and non-relational databases.
 
Module Learning Outcome
On successful completion of this module the learner will be able to:
# Module Learning Outcome Description
MLO1 Construct advanced Data Manipulation statements.
MLO2 Encapsulate procedural database operations using stored procedures, stored functions and triggers.
MLO3 Explain and apply Transaction Management theory.
MLO4 Discuss current database development technologies and issues.
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
Database Procedural Programming
Stored Procedures, Functions,Triggers, DB Objects, Cursors, Collection Objects, Packages.
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.
Contemporary Database Development
Non-Relational Databases, Distributed Databases
Module Assessment
Assessment Breakdown%
Course Work100.00%
Module Special Regulation
 

Assessments

Full Time

Course Work
Assessment Type Continuous Assessment % of Total Mark 30
Marks Out Of 0 Pass Mark 0
Timing Week 8 Learning Outcome 2,3
Duration in minutes 0
Assessment Description
Class test
Assessment Type Continuous Assessment % of Total Mark 50
Marks Out Of 0 Pass Mark 0
Timing Week 11 Learning Outcome 1,2,3
Duration in minutes 0
Assessment Description
Group Project
Assessment Type Continuous Assessment % of Total Mark 20
Marks Out Of 0 Pass Mark 0
Timing Week 12 Learning Outcome 4
Duration in minutes 0
Assessment Description
Presentation
No Project
No Practical
No Final Examination

Part Time

Course Work
Assessment Type Continuous Assessment % of Total Mark 30
Marks Out Of 0 Pass Mark 0
Timing Week 8 Learning Outcome 2,3
Duration in minutes 0
Assessment Description
Class test
Assessment Type Continuous Assessment % of Total Mark 50
Marks Out Of 0 Pass Mark 0
Timing Week 11 Learning Outcome 1,2,3
Duration in minutes 0
Assessment Description
Group Project
Assessment Type Continuous Assessment % of Total Mark 20
Marks Out Of 0 Pass Mark 0
Timing Week 12 Learning Outcome 4
Duration in minutes 0
Assessment Description
Presentation
No Project
No Practical
No Final 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

Workload: Full Time
Workload Type Contact Type Workload Description Frequency Average Weekly Learner Workload Hours
Lecture Contact No Description Every Week 1.00 1
Practical Contact No Description Every Week 3.00 3
Directed Reading Non Contact No Description Every Week 3.00 3
Independent Study Non Contact No Description Every Week 1.00 1
Total Weekly Learner Workload 8.00
Total Weekly Contact Hours 4.00
Workload: Part Time
Workload Type Contact Type Workload Description Frequency Average Weekly Learner Workload Hours
Lecture Contact No Description Every Week 1.00 1
Practical Contact No Description Every Week 3.00 3
Directed Reading Non Contact No Description Every Week 3.00 3
Independent Study Non Contact No Description Every Week 1.00 1
Total Weekly Learner Workload 8.00
Total Weekly Contact Hours 4.00
 
Module Resources
Supplementary Book Resources
  • Connolly, Thomas, Begg, Carolyn. (2015), Database Systems, 6th. Addison-Wesley, [ISBN: 1292061189].
  • Michael Mannino. (2014), Database Design Application Development and Administration, 6th ed.. Chicago Business Press, [ISBN: 0983332428].
  • Feuerstein, S & Pribyl, B. (2014), Oracle PL/SQL Programming, 6th. O'Reilly, [ISBN: 9781449324452].
  • Stephen Morris, Peter Rob, Carlos Coronel, Keeley Crocket. (2013), Database Priniciples: Fundamentals of Design, Implementations and Management, 2nd 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