Short Title:Information Systems
Full Title:Information Systems
Module Code:INFO H1028
 
Credits: 5
Field of Study:Computing
Module Delivered in 1 programme(s)
Reviewed By:FINBARR FEENEY
Module Author:ROISIN FAHERTY
Module Description:Basic database design and development
Learning Outcomes
On successful completion of this module the learner will be able to:
LO1 Design a relational database schema for a software application
LO2 Devise a set of relational tables and develop the relational database.
LO3 Query a relational database using SQL
LO4 Develop Procedures/Functions/Triggers in SQL
 

Module Content & Assessment

Course Work
Assessment Type Assessment Description Outcome addressed % of total Assessment Date
Practical/Skills Evaluation CA1 - In -Lab. Typical Task: Given a hypothetical business description students would be required to design a relational database schema. The schema will then be implemented and populated with test data. 1,2 25.00 Week 8
Practical/Skills Evaluation CA2 - In-Lab, individual: Typical Task: To demonstrate their ability to successfully query a relational database. Students would be given a database and asked to retrieve information. Queries would include all SQL constructs covered e.g. group by, order by, aggregate functions,Union, intersect, joins,sub-queries, Procedures, functions and triggers. 3,4 25.00 Week 13
End of Module Formal Examination
Assessment Type Assessment Description Outcome addressed % of total Assessment Date
Formal Exam End-of-Semester Final Examination 1,2,3,4 50.00 End-of-Semester

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
Lecture No Description 2.00 Every Week 2.00
Lab No Description 2.00 Every Week 2.00
Independent Learning No Description 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 No Description 2.00 Every Week 2.00
Lab No Description 2.00 Every Week 2.00
Independent Learning No Description 2.00 Every Week 2.00
Total Weekly Learner Workload 6.00
Total Weekly Contact Hours 4.00
 

Module Resources

Recommended Book Resources
  • Larry Rockoff 2017, The Language Of SQL, 2nd Edition Ed., Addison-Wesley [ISBN: 9780134658254]
  • Chris Fehily 2015, SQL(Database Programming), 2nd Edition Ed., Questing Vole Press [ISBN: 9781937842314]
  • N.Umanath & R. Scamell 2015, Data Modeling and Database Deign, 2nd Edition Ed., Cengage Learning [ISBN: 1285085256]
  • Michael J. Hernandez., Database design for mere mortals, 5th Edition Ed., Boston; Addison-Wesley [ISBN: 0321884493]
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_KCOMP_HD Higher Diploma in Science in Computing 1 Mandatory