Full Title:Database Development
Language of Instruction:English
Module Code:DBMS C7004
 
Credits: 5
Valid From:Semester 1 - 2016/17 ( September 2016 )
Module Delivered in No Programmes
Module Description:The aim of this module is develop students' ability to design, implement and test database transaction code, employ appropriate database abstraction strategies and utilise stored procedures and triggers.
Learning Outcomes:
On successful completion of this module the learner should be able to
  1. Encapsulate procedural database operations using stored procedures, stored function and triggers
  2. Demonstrate an understanding of basic transaction management, and an ability to construct transactions in a database-oriented program
  3. Demonstrate an understanding by constructing a data access abstraction layer in an application program
  4. Demonstrate an understanding of a selected set of current database development technologies and issues
 

Module Content & Assessment

Indicative Content
Database Procedural Programming
Stored Procedures, Functions, Triggers, DB Objects, Cursors, Collection Objects, Packages
JDBC and Database Objects
Connection, Statements, Processing Result Sets, Accessing Stored Procedures
Contemporary Database Development Topics
Case Studies, Best Practice, New Technologies
Database Abstraction
Abstraction, Data Access Objects
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
Presentation Presentation on Selected DB Topic 4 20.00 0 0 n/a 0
Continuous Assessment Assignment/Test 1,3 30.00 0 0 Week 8 0
Project Project 1,2,3 50.00 0 0 Week 12 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
Presentation Presentation on Selected DB Topic 4 20.00 0 0 n/a 0
Continuous Assessment Assignment/Test 1,3 30.00 0 0 Week 8 0
Project Project 1,2,3 50.00 0 0 Week 12 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.
Reassessment Description
A project incorporating all learning outcomes for this module will be assigned for reassessment purposes. Students will be required to present the project.

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   1.00 Every Week 1.00
Practical Lab/Lecture 3.00 Every Week 3.00
Directed Reading   3.00 Every Week 3.00
Independent Study   1.00 Every Week 1.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 Lab/Lecture 2.00 Every Week 2.00
Directed Reading   3.00 Every Week 3.00
Independent Study No Description 2.00 Every Week 2.00
Total Weekly Learner Workload 8.00
Total Weekly Contact Hours 3.00
Resources
Supplementary Book Resources
  • Boronczyk, T. 2009, Beginning PHP 6, Apache, MySQL 6 Web Development, Wrox [ISBN: 9780470471395]
  • Harrison, G. & Feuerstein, S. 2006, MySQL Stored Procedure Programming, O'Reilly [ISBN: 0596100892]
This module does not have any article/paper resources
Other Resources