COMP06292 2021 Database Fundamentals
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
2021 - Full Academic Year 2021-22
End Term
9999 - The End of Time
Author(s)
Aine Doherty, Mary Carden
Programme Membership
SG_MBUSI_H08 202100 Bachelor of Arts (Honours) in Business and ICT
SG_MBUSI_H08 202200 Bachelor of Arts (Honours) in Business and 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 | Coursework Assessment | Multiple Choice/Short Answer Test | 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 |
| Practical / Laboratory | 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
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.