PROG C7015 - Introduction to Databases

Module Details

Module Code: PROG C7015
Full Title: Introduction to Databases
Valid From:: Semester 1 - 2019/20 ( June 2019 )
Language of Instruction:English
Duration: 1 Semester
Credits:: 5
Module Owner:: Roisin Mulligan
Departments: Unknown
Module Description: This module will introduce students to the principles and techniques involved in creating and using relational databases.
 
Module Learning Outcome
On successful completion of this module the learner will be able to:
# Module Learning Outcome Description
MLO1 Apply the basic concepts in the development of a relational database
MLO2 Create tables and relationships.
MLO3 Design various types of queries.
MLO4 Create more complex sub-queries.
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 Concepts.
DBMS, database elements
Tables
Data types.
Relationships
Data Integrity
Queries
Create, Add Criteria, and Query Types
Sub-queries
Create, Aggregate functions, Grouping.
Module Assessment
Assessment Breakdown%
Course Work100.00%
Module Special Regulation
 

Assessments

Full Time On Campus

Course Work
Assessment Type Class Test % of Total Mark 50
Marks Out Of 0 Pass Mark 0
Timing Week 6 Learning Outcome 1,2,3
Duration in minutes 0
Assessment Description
Practical/Skills Evaluation
Assessment Type Class Test % of Total Mark 50
Marks Out Of 0 Pass Mark 0
Timing End-of-Semester Learning Outcome 2,3,4
Duration in minutes 0
Assessment Description
Database Implementation and Manipulation
No Project
No Practical
No Final Examination

Part Time On Campus

Course Work
Assessment Type Class Test % of Total Mark 50
Marks Out Of 0 Pass Mark 0
Timing Week 6 Learning Outcome 1,2,3
Duration in minutes 0
Assessment Description
Practical/Skills Evaluation
Assessment Type Class Test % of Total Mark 50
Marks Out Of 0 Pass Mark 0
Timing End-of-Semester Learning Outcome 2,3,4
Duration in minutes 0
Assessment Description
Database Implementation and Manipulation
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 On Campus
Workload Type Contact Type Workload Description Frequency Average Weekly Learner Workload Hours
Practical Contact No Description Every Week 4.00 4
Directed Reading Non Contact No Description Every Week 2.00 2
Independent Study Non Contact No Description Every Week 2.00 2
Total Weekly Learner Workload 8.00
Total Weekly Contact Hours 4.00
Workload: Part Time On Campus
Workload Type Contact Type Workload Description Frequency Average Weekly Learner Workload Hours
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 2.00 2
Total Weekly Learner Workload 8.00
Total Weekly Contact Hours 3.00
 
Module Resources
Supplementary Book Resources
  • Connolly, T & Begg, C. (2015), Database Systems, 6th. Pearson, [ISBN: 1292061189].
  • Date, C.J. (2004), Introduction to Database Systems, 8th. Pearson, [ISBN: 9780321197849].
This module does not have any article/paper resources
Other Resources