Short Title:Database
Full Title:Database
Module Code:DATA H3004
 
Credits: 5
Field of Study:Computer Science
Module Delivered in 1 programme(s)
Reviewed By:FINBARR FEENEY
Module Author:Lorraine Carmody
Module Description:This module will introduce the learner to the comprehensive concepts of the theory, design, modelling and implementation of relational databases and how it fits into the area of information and data management. The student will learn core database design techniques and will gain expertise in the main constructs of SQL.
Learning Outcomes
On successful completion of this module the learner will be able to:
LO1 Display an understanding of the theory, design and implementation of relational databases.
LO2 Construct SQL to define and manipulate data in a relational database (e.g. Oracle).
LO3 Apply Top down ER modelling design techniques to produce a database schema.
LO4 Apply Bottom Up Normalisation design techniques to produce a database schema.
 

Module Content & Assessment

Course Work
Assessment Type Assessment Description Outcome addressed % of total Assessment Date
Laboratory This CA will take place in-lab. The student will create SQL statements for a given list of tasks. 1,2 30.00 Week 4
Continuous Assessment CA2 - Students will design and implement a real-world database, using the techniques learned in class. 1,2,3 30.00 Week 8
Multiple Choice Questions Students will be given one quiz which will be made up of a range of answers. This quiz will cover the main concepts presented in class. 1,2,3,4 30.00 Week 10
Laboratory Students are required complete weekly exercises in the computer lab. 2,3,4 10.00 Every Week
No End of Module Formal Examination

TU Dublin – Tallaght Campus reserves the right to alter the nature and timings of assessment

 

Module Workload

Workload: Full Time
Workload Type Workload Description Hours Frequency Average Weekly Learner Workload
Lecture Introduction to Relational Databases, Database Design, ER Modeling, Data Manipulation, Data Definition 2.00 Every Week 2.00
Lab Practical exercises based on SQL, ERD Modelling and Database Design 2.00 Every Week 2.00
Independent Learning Reading, Group Work 4.00 Every Week 4.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 Introduction to Relational Databases, Database Design, ER Modeling, Data Manipulation, Data Definition 2.00 Every Second Week 1.00
Lab Practical exercises based on SQL, ERD Modelling and Database Design 2.00 Every Second Week 1.00
Independent Learning Reading, Group Work 4.00 Every Week 4.00
Total Weekly Learner Workload 6.00
Total Weekly Contact Hours 2.00
 

Module Resources

Required Book Resources
  • Bruce Berke 2018, The Complete Beginner’s Guide To Learn SQL Programming
Recommended Book Resources
  • Jeffrey A. Hoffer, V. Ramesh, Heikki Topi 2016, Modern database management, Pearson Upper Saddle River, N.J. [ISBN: 0136088392]
  • Ramez Elmasri, Shamkrant Navathe, 2016, Fundamentals of Database Systems, 3 Ed.
This module does not have any article/paper resources
Other Resources
 

Module Delivered in

Programme Code Programme Semester Delivery
TA_BDAMKT_D BSc in Data Analytics with Digital Marketing 1 Mandatory