Short Title:Database Fundamentals
Full Title:Database Fundamentals
Module Code:DATA H1000
 
Credits: 5
Field of Study:Computer Science
Module Delivered in 8 programme(s)
Reviewed By:FINBARR FEENEY
Module Author:FRANCES CLYNES
Module Description:This module will introduce the learner to the basic concepts in the theory, design and implementation of relational databases and how it fits into the area of information management. The student will learn basic database design techniques and will gain expertise in the main constructs of SQL. Students will be introduced to cloud-based databases and will learn how to connect to a cloud-based relational database, and run SQL queries in the cloud.
Learning Outcomes
On successful completion of this module the learner will be able to:
LO1 Demonstrate a solid knowledge of and appreciation for the principles and foundations of relational database systems
LO2 Explain relational database terminology and concepts.
LO3 Explain the architecture and main functions of a DBMS.
LO4 Apply basic ER modelling and design techniques to produce a database schema.
LO5 Use SQL to define and manipulate data in a relational database (e.g. Oracle).
LO6 Explain the concept of and connect to, a cloud-based database
LO7 Run SQL queries in a cloud-based relational database
 

Module Content & Assessment

Course Work
Assessment Type Assessment Description Outcome addressed % of total Assessment Date
Continuous Assessment CA1 - An In-Lab assessment to test the students knowledge of the basic database concepts and writing of some basic DML in SQL. 1,2,5 40.00 Week 7
Continuous Assessment CA2 - An in-lab assessment where students will be required to connect to a cloud-based relational database, and run SQL queries in the cloud 1,5,6,7 30.00 Week 11
Multiple Choice Questions Students will be given two quizzes which will be made up of short answer, true/false, multiple choice answer. These quizzes will cover the main concepts presented in class. 1,2,3,6 20.00 Ongoing
Laboratory Students are required complete weekly exercises in the computer lab. 4,5 10.00 Every Week
No End of Module Formal Examination

IT Tallaght 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
Tutorial No Description 2.00 Every Week 2.00
Lab No Description 2.00 Every Week 2.00
Total Weekly Learner Workload 4.00
Total Weekly Contact Hours 4.00
Workload: Part Time
Workload Type Workload Description Hours Frequency Average Weekly Learner Workload
Lecture No Description 2.00 Every Week 2.00
Lab No Description 2.00 Every Week 2.00
Total Weekly Learner Workload 4.00
Total Weekly Contact Hours 4.00
 

Module Resources

Required Book Resources
  • Mark Lassoff 2014, SQL Database For Beginners [ISBN: 0099040207X]
Recommended Book Resources
  • Jeffrey A. Hoffer, V. Ramesh, Heikki Topi 2013, Modern database management, 11th Ed., Prentice Hall Upper Saddle River, N.J. [ISBN: 9780132662253]
  • Thomas M. Connolly, Carolyn E. Begg 2013, Database systems, 6th Ed., Pearson [ISBN: 0321523067]
  • Ramez Elmasri, Shamkrant Navathe, 2014, Fundamentals of Database Systems [ISBN: 0136086209]
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 2 Mandatory
TA_KACOI_B Bachelor of Science (Honours) in Computing with Language (French/ German/ Spanish) 2 Mandatory
TA_KACOS_B Bachelor of Science (Honours) in Computing with Software Development 2 Mandatory
TA_KACOD_B Bachelor of Science (Hons) in Computing with Data Analytics 2 Mandatory
TA_KACTM_D Bachelor of Science in Computing with Information Technology Management 2 Mandatory
TA_KACOS_D Bachelor of Science in Computing with Software Development 2 Mandatory
TA_KITMG_D Bachelor of Science in IT Management 2 Mandatory
TA_KCOMP_C Higher Certificate in Science in Computing 2 Mandatory