COMP08159 2019 Information Systems

General Details

Full Title
Information Systems
Transcript Title
Information Systems
Code
COMP08159
Attendance
N/A %
Subject Area
COMP - Computing
Department
COEL - Computing & Electronic Eng
Level
08 - NFQ Level 8
Credit
05 - 05 Credits
Duration
Semester
Fee
Start Term
2019 - Full Academic Year 2019-20
End Term
9999 - The End of Time
Author(s)
Una LEstrange, Colm Davey
Programme Membership
SG_KCOMP_L08 201900 Higher Diploma in Science in Computing SG_KCMPU_L08 202000 Higher Diploma in Science in Computing
Description

This module will allow the learner to design and query relational database management systems. The learner will have an intermediate level of SQL programming ability at the end of this module.

Learning Outcomes

On completion of this module the learner will/should be able to;

1.

Design a relational database schema for a software application

2.

Develop a set of relational tables and develop the relational database

3.

Query a relational database using SQL

4.

Implement basic table joins and stored procedures

Teaching and Learning Strategies

This module will be delivered online. Multiple short (20 minutes) videos will be made available on a weekly basis, along with appropriate reading materials. The learners will be encouraged to use Moodle to ask/answer questions and learn from each other.

Module Assessment Strategies

There will be two assessments (one of which is on-site or remotely proctored) in weeks 4 and 8 (20% and 30% respectively). Students will undertake a final project in the final four weeks of the semester. It is a requirement to pass this project in order to pass the project.

Repeat Assessments

The repeat project will cover all the learning outcomes. Where appropriate, learners may interviewed (onsite or via Skype etc.) to ensure ownership of the work submitted.

Indicative Syllabus

Design a relational database for a software application

  • The evolution of the relational database model
  • Database entities and attributes and relationships between them
  • Approaches for good database design (e.g. normalization)
  • Database data types, sharding, ACID properties etc.

Develop a set of relational tables and develop the relational database

  • The three stages of normalization and alternatives
  • Database data types (int, char, money etc.)
  • Developing an entity relationship diagram
  • Data integrity issues when updating, deleting and inserting records
  • Primary, foreign keys etc.

Query a relational database using SQL

  • ´╗┐Introduction to SQL programming
  • SQL concepts (selecting, ordering, grouping)
  • Perform basic CRUD operations using SQL

Implement basic table and stored procedures

  • Table Joins
  • Stored procedures
  • Views

Coursework & Assessment Breakdown

Coursework & Continuous Assessment
100 %

Coursework Assessment

Title Type Form Percent Week Learning Outcomes Assessed
1 Design a database Continuous Assessment Assignment 20 % Week 4 1,2
2 Query a database Continuous Assessment Open Book Exam 30 % Week 8 3
3 Design and query a database for a provided specification with a focus on table joins and stored procedures Project Project 50 % OnGoing 1,2,3,4

Full Time Mode Workload


Type Location Description Hours Frequency Avg Workload
Lecture Lecture Theatre Lecture 2 Weekly 2.00
Laboratory Practical Computer Laboratory Lab Practical 2 Weekly 2.00
Independent Learning Not Specified Self directed learning 3 Weekly 3.00
Total Full Time Average Weekly Learner Contact Time 4.00 Hours

Online Learning Mode Workload


Type Location Description Hours Frequency Avg Workload
Online Lecture Online Lecture 4 Weekly 4.00
Independent Learning Online Self study 3 Weekly 3.00
Total Online Learning Average Weekly Learner Contact Time 4.00 Hours

Required & Recommended Book List

Recommended Reading
2016-12-30 Pro SQL Server Relational Database Design and Implementation Apress
ISBN 1484219724 ISBN-13 9781484219720
Recommended Reading
2016-07-03 SQL Server 2016 Database Design CreateSpace Independent Publishing Platform
ISBN 1535069406 ISBN-13 9781535069403
Recommended Reading
2016-03-11 NoSQL and SQL Data Modeling: Bringing Together Data, Semantics, and Software Technics Publications
ISBN 1634621093 ISBN-13 9781634621090

Module Resources

Journal Resources

None

URL Resources

http://www.sqlcourse.com/

https://www.w3schools.com/sql/

https://www.draw.io/

https://docs.microsoft.com/en-us/sql/t-sql/language-reference

Other Resources

Virtual machines

Additional Information

None