Module Code - Title:
CS4416
-
DATABASE SYSTEMS
Year Last Offered:
2023/4
Hours Per Week:
Grading Type:
N
Prerequisite Modules:
CS4513
Rationale and Purpose of the Module:
Databases, particularly relational databases and database management systems (DBMSs) are central in the design and development of modern information systems. Understanding of their structure and skills in their application are fundamental aspects of a proper foundation in any domain of software development.
Syllabus:
The concept of a DBMS and DB Architectures are introduced. This module will build upon the notion of a database as introduced in Information Modelling and Specification including revision of those concepts previously introduced, i.e. the relational data model, including issues, such as Integrity Constraints, SQL, and Views.
- Concepts of databases and DBMSs;
- Database Architectures;
- Revision of the Relational Model; SQL Tables, Views and the DDL; Referential and Existential Integrity Constraints;
- Normalisation: Functional Dependencies; 1st, 2nd 3rd, 4th Boyce Codd and Fifth Normal Forms;
- Technologies: Transaction Management; ACID properties; Security; Data Storage & Indexing; Triggers & Active DBs; Query Optimisation; Distributed Architectures;
- Use of embedded SQL, cursors, triggers;
- Object DBs and Object Relational DBs;
- Data Warehousing, Decision Support & Data Mining;
- Emerging Technologies;
Learning Outcomes:
Cognitive (Knowledge, Understanding, Application, Analysis, Evaluation, Synthesis)
1. Transform conceptual database models into relational DB schemas, integrating views to reduce and control redundancy.
2. Given a set of functional dependencies and a set of relations, enumerate all the relation keys.
3. Apply the rules of normalisation to create normalised relations in 1, 2nd, 3rd, 4th, BCNF and 5th Normal form.
4. Contrast and compare optimistic and pessimistic approaches to concurrency control in database transaction management.
5. Discuss the use of Data Warehousing, Data Mining and Decision Support Systems.
6. Compare the facilities of relational database technology with those of Object databases and Object-relational databases.
Affective (Attitudes and Values)
N/A
Psychomotor (Physical Skills)
1. Construct SQL expressions for answering complex database queries as well as for defining and modifying a relational database schema.
2. Create and modify stored procedures and triggers to implement simple database transactions.
How the Module will be Taught and what will be the Learning Experiences of the Students:
Research Findings Incorporated in to the Syllabus (If Relevant):
Prime Texts:
C. J. Date (2004)
An Introduction to Database Systems (8th edition)
, Addison Wesley
R. Elmasri and S. B. Navathe (2007)
Fundamentals of Database Systems (5th edition)
, Addison Wesley
J.D. Ullman and J. Widom (2007)
A First Course in Database Systems (3rd ed.)
, Prentice Hall
Other Relevant Texts:
R. Ramakrishnan and J. Gehrke (2003)
Database Management Systems (3rd edition)
, McGraw-Hill
P. Atzeni, S. Ceri, S. Paraboschi and R. Torlone (1999)
Database Systems: Concepts Languages and Architectures (1st edition)
, McGraw-Hill
Programme(s) in which this Module is Offered:
Semester - Year to be First Offered:
Spring
-
08/09
Module Leader:
Nikola.Nikolov@ul.ie