Short Title:Advanced Database Technologies
Full Title:Advanced Database Technologies
Module Code:DBAS H2001
 
Credits: 5
Field of Study:Computer Science
Module Delivered in 8 programme(s)
Reviewed By:FINBARR FEENEY
Module Author:ROISIN FAHERTY
Module Description:This subject aims to build upon the basic database skills acquired in Database Fundamentals. The student will learn database design and implementation techniques, transaction management and will gain experience in the use of a cloud database.
Learning Outcomes
On successful completion of this module the learner will be able to:
LO1 Explain the architecture and main functions of a DBMS
LO2 Apply appropriate modelling and design techniques to produce a database schema
LO3 Use procedures and functions to aid abstraction and enforce referential integrity
LO4 Create and use an RDS cloud instance.
LO5 Understand the theory of transaction management in a database.
 

Module Content & Assessment

Course Work
Assessment Type Assessment Description Outcome addressed % of total Assessment Date
Continuous Assessment CA1- given a business problem the student has to derive an appropriate ERD ( Database Schema). The student is then required to create the tables for this schema insert data and query the tables. 2 30.00 n/a
Continuous Assessment CA2 - the student is given a business problem and a set of tables. The student is required to create a database program which will solve the business need. The problem would typically require, but is not limited to, any of the following to produce the solution: Procedures,Functions, Triggers, Constraints and Exception Handling 3 20.00 n/a
Laboratory CA3 - This CA has two aspects firstly the students will Normalise a given set of data through 1st, 2nd and 3rd Normal forms, detailing their process as they progress. The second part requires the students to create a DB instance in the cloud and create the normalized tables in the cloud DB and test them. Testing will involve writing some SQL queries, views, indexes etc.. 2,3,4 30.00 n/a
Multiple Choice Questions The students will be required to complete a number of moodle quizzes based on the course material. 1,2,3 20.00 n/a
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 Class Based Instruction 2.00 Every Week 2.00
Lab Lab Based Instruction 2.00 Every Week 2.00
Independent Learning Time Complete Lab Assignments and Cover Reading material to supplement learning 2.00 Every Week 2.00
Total Weekly Learner Workload 6.00
Total Weekly Contact Hours 4.00
Workload: Part Time
Workload Type Workload Description Hours Frequency Average Weekly Learner Workload
Lecture Class Based Instruction 2.00 Every Second Week 1.00
Lab Lab Based Instruction 2.00 Every Second Week 1.00
Independent Learning Time Completion of Lab Assignments & Cover reading material to supplement learning 2.00 Every Week 2.00
Total Weekly Learner Workload 4.00
Total Weekly Contact Hours 2.00
 

Module Resources

Required Book Resources
  • Elmasari, Navathe 2016, Database Systems: Global Edition, 6th Edition Ed., Pearson Education [ISBN: 1-292-09761-2]
  • Carlos Coronel , Steven Morris 2014, Database Systems: Design, Implementation, & Management, 11th Ed., Cengage Learning [ISBN: 978128519614]
Recommended Book Resources
  • Sergio Garrido Barrientos 2016, Database Design - A Practical Focus, 1st Edition Ed., Safe Creative Spain [ISBN: 160603807189]
  • Michael McLaughlin, Oracle Database 11g: PL/SQL Programming, McGraw Hill [ISBN: 978-0-07-149445-8]
  • McFadden, F., Hoffer, J. & Prescott, M. 2013, Modern Database Management, Longman Higher Education [ISBN: 97801326622]
This module does not have any article/paper resources
This module does not have any other resources
 

Module Delivered in

Programme Code Programme Semester Delivery
TA_KACTM_B Bachelor of Science (Honours) in Computing with Information Technology Management 3 Mandatory
TA_KACOI_B Bachelor of Science (Honours) in Computing with Language (French/ German/ Spanish) 3 Mandatory
TA_KACOS_B Bachelor of Science (Honours) in Computing with Software Development 3 Mandatory
TA_KACOD_B Bachelor of Science (Hons) in Computing with Data Analytics 3 Mandatory
TA_KACTM_D Bachelor of Science in Computing with Information Technology Management 3 Mandatory
TA_KACOS_D Bachelor of Science in Computing with Software Development 3 Mandatory
TA_KITMG_D Bachelor of Science in IT Management 3 Mandatory
TA_KCOMP_C Higher Certificate in Science in Computing 3 Mandatory