COMP06292 2020 Database Fundamentals

General Details

Full Title
Database Fundamentals
Transcript Title
Database Fundamentals
Code
COMP06292
Attendance
N/A %
Subject Area
COMP - Computing
Department
BUS - Business
Level
06 - NFQ Level 6
Credit
05 - 05 Credits
Duration
Semester
Fee
Start Term
2020 - Full Academic Year 2020-21
End Term
9999 - The End of Time
Author(s)
Aine Doherty, Mary Carden
Programme Membership
SG_MBUSI_H08 202000 Bachelor of Arts (Honours) in Business & ICT
Description

This module introduces the concepts of databases. As data becomes more and more valuable this module will develop database concepts and relational database terms and modelling. It will allow the student to become familiar with data storage and the rules around ensuring the integrity of data. 

Learning Outcomes

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

1.

Outline the purpose of databases and the various types of database models used to store data.

2.

Define database management systems (DBMS) and outline its objectives.

3.

Design a relational database composed of tables and define keys and relationship among tables.

4.

Explain and demonstrate the concepts of entity integrity constraints and referential integrity constraints

5.

Create a relational database and insert and manipulate data using GUI tools

Teaching and Learning Strategies

There will be one to two hours per week to to explain theory using examples where appropriate. The remaining one to two hours will be spent working in Computer labs with a database where your tutor will  give direct instruction and advice.

The students will be assigned tasks in the lab that will support the theory and show how the task can be physically understood

Module Assessment Strategies

There will be continuous assessment throughout the semester. These will allow the learner to provide a practical implementation of topics covered and receive regular feedback from their tutor. 10% of Continuous Assessment will be the form of online quizzes between weeks 3 to 8 . 

Repeat Assessments

A repeat closed exam will be set covering all learning outcomes at the repeat exam series each year.

Indicative Syllabus

Outline the purpose of databases and the various types of database models used to store data

  • Introduce database and database models and compare them (relational, dimensional, noSQL )
  • Characteristics of the Database Approach
  • Discuss their purpose and categories
  • Discuss tables, columns and datatypes

Discuss database management systems (DBMS) and outline its objectives

  • Data Models , Schemas and Instances 
  • Discuss DBMS Architecture
  • Outline DBMS Architrcture's Objectives
  • Data Independence
  • Database Languages and Interfaces

Design a relational database composed of tables and define keys and relationship among tables

  • Design databases using ER diagrams
  • Explain individual ER diagrams 
  • Define primary and foreign keys in the diagrams 
  • show the relationships and types between tables 

Explain and demonstrate the concepts of entity integrity constraints and referential integrity constraints

  • Entity types, sets and attributes
  • Introduce types of integrity constraints 
  • Discuss how data quality is ensured with the use of integrity constraints

Create a relational database and insert and manipulate data using GUI tools

  • Using graphical User Interface (GUI) client to populate a database
  • Insert tuples
  • Delete tuples,
  • Update tuples.

Coursework & Assessment Breakdown

Coursework & Continuous Assessment
40 %
End of Semester / Year Formal Exam
60 %

Coursework Assessment

Title Type Form Percent Week Learning Outcomes Assessed
1 Quizzes Continuous Assessment Multiple Choice 10 % OnGoing 1,2
2 Practical Exam Practical Practical Evaluation 30 % Week 10 3,4,5
             

End of Semester / Year Assessment

Title Type Form Percent Week Learning Outcomes Assessed
1 Final Exam Final Exam Closed Book Exam 60 % End of Semester 1,2,3,4,5
             
             

Full Time Mode Workload


Type Location Description Hours Frequency Avg Workload
Lecture Computer Laboratory Lecture 1 Weekly 1.00
Laboratory Practical Computer Laboratory Laboratory Practical 2 Weekly 2.00
Independent Learning Not Specified Independent Learning 4 Weekly 4.00
Total Full Time Average Weekly Learner Contact Time 3.00 Hours

Required & Recommended Book List

Required Reading
2016-08-19 Fundamentals of Database Systems, Global Edition
ISBN 1292097612 ISBN-13 9781292097619

For database systems courses in Computer Science This book introduces the fundamental concepts necessary for designing, using, and implementing database systems and database applications. Our presentation stresses the fundamentals of database modeling and design, the languages and models provided by the database management systems, and database system implementation techniques. The book is meant to be used as a textbook for a one- or two-semester course in database systems at the junior, senior, or graduate level, and as a reference book. The goal is to provide an in-depth and up-to-date presentation of the most important aspects of database systems and applications, and related technologies. It is assumed that readers are familiar with elementary programming and data-structuring concepts and that they have had some exposure to the basics of computer organization.

Module Resources