Short Title:Information Systems
Full Title:Information Systems
Module Code:INFO H1028
 
Credits: 5
NFQ Level:8
Field of Study:Computing
Module Delivered in no programmes
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
Pre-requisite learning
Co-requisite Modules
No Co-requisite modules listed
 

Module Content & Assessment

Content (The percentage workload breakdown is inidcative and subject to change) %
Relational Database Design
Relational Database design - ER diagrams to include deriving entities, attributes, relationships and cardinality,Primary Keys, Foreign Keys. Mapping ERDs to a relational schema, data normalisation, relational integrity, keys, indexes; database transactions, ACID properties
45.00%
SQL
Schema definition: Create, Drop, Alter tables, Data manipulation in SQL: Insert, update and Delete tables and rows. SQL queries: basic queries, grouping, ordering, Built in SQL functions, joins, subqueries.
35.00%
Database Objects
An introduction to basic database objects to include: sequences, views, indexes, stored procedures, functions and triggers.
20.00%
Assessment Breakdown%
Course Work50.00%
End of Module Formal Examination50.00%
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