Full Title:Database Programming
Language of Instruction:English
Module Code:DBMS C7003
 
Credits: 5
Valid From:Semester 1 - 2016/17 ( September 2016 )
Module Delivered in 4 programme(s)
Module Description:Students completing this module will understand and be able to apply database design techniques. They will have designed and implemented a database system and carried out data manipulation and data definition statements.
Learning Outcomes:
On successful completion of this module the learner should be able to
  1. Demonstrate an understanding of applying database design techniques.
  2. Demonstrate an understanding of the Relational Model and the application of Relational Integrity Rules.
  3. Construct Data Manipulation Statements.
  4. Construct Data Definition Statements.
 

Module Content & Assessment

Indicative Content
The Relational Data Model
History, Mathematical Relations, Relational Algebra; ANSI-SPARC Database Schema
Database Analysis and Design
Database Development Process (Conceptual, Logical, Physical); Data Redundancy and Update Anomalies; Functional Dependencies, Identification of Primary Key; Normalisation Process (up to Third Normal Form)
Integrity Constraints - Definition and Application
Nulls, Entity, Referential, Domain, General/Business
SQL: Data Manipulation
Simple Queries, Sorting, Aggregate Functions; Grouping, Subqueries; Simple Joins; Update, Insert, Delete
SQL: Data Definition
Creating and Managing Tables; Required Data, Domain Constraints, General Constraints; Entity Integrity, Referential Integrity Application; Creating and using Sequences; Views and Access Control
SQL: Functions
Using Character and Number functions; Data and conversion functions
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
Continuous Assessment The continuous assessment component will normally consist of three assessments; one practical lab-based test, one multiple choice test and one group project. The assessment criteria for continuous assessments will be concerned with the students' demonstrating their understanding by applying both logical design and physical design techniques, and appropriate querying of the database. 1,2,3,4 100.00 0 0 n/a 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
Continuous Assessment The continuous assessment component will normally consist of three assessments; one practical lab-based test, one multiple choice test and one group project. The assessment criteria for continuous assessments will be concerned with the students' demonstrating their understanding by applying both logical design and physical design techniques, and appropriate querying of the database. 1,2,3,4 100.00 0 0 n/a 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.

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   4.00 Every Week 4.00
Directed Reading   2.00 Every Week 2.00
Independent Study   1.00 Every Week 1.00
Total Weekly Learner Workload 8.00
Total Weekly Contact Hours 5.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
  • Stephen Morris, Peter Rob, Carlos Coronel, Keeley Crocket 2013, Database Principles: Fundamentals of Design, Implementations and Management, 2nd Ed., Cengage Learning, Inc [ISBN: 140806636X]
  • Connolly, Thomas & Begg, Carolyn, Database Systems ISBN: 0321523067, Addison-Wesley, 2009
  • Alice Rischert 2009, Oracle SQL by Example, 4th Ed., Prentice Hall [ISBN: 0137142838]
  • Feuerstein, S. , Pribyl, B 2009, Oracle PL/SQL Programming, 5th Ed., O'Reilly Media [ISBN: B00E294R4K]
This module does not have any article/paper resources
Other Resources

Module Delivered in

Programme Code Programme Semester Delivery
DK_KCOMP_7 Bachelor of Science in Computing 3 Mandatory
DK_KCEDD_7 Certificate in Database Development 1 Elective
DK_KCEDD_7 Certificate in Database Development 2 Elective
DK_KCMP7_6 [Exit Award from L7] Higher Certificate in Science in Computing 3 Mandatory