This module provides the learner with fundamental skills to design information systems, focussing on the design and implementation of database systems.
The aims of this module are:
- Enable the student to create new relational databases by devising a high-level conceptual data model
- Transform that data model into a relational schema
- Implement the relational schema correctly and robustly in SQL.
*Curricular information is subject to change
Relational Database Design (45%)
- ER diagrams and mapping to a relational schema
- Data normalisation
- Relational integrity
- Keys
- Indexes
- Database transactions
- ACID properties
SQL (35%)
- Schema definition and data manipulation in SQL
- SQL queries
- Introduction to stored procedures
Non-relational storage (20%)
- Schema-less storage (no SQL)
- XML and XML Schema
Lectures, self-study, tutorials and practical lab sessions and exercises.
Modules will be simultaneously delivered on campus, in class and live streamed for online participants. There will be both lecture style and lab style classes. Stidents are expected to attend all of your lectures and labs. Attendance will be recorded in most labs and lectures. You will access all your online materials through the official TU Dublin virtual learning environment, Brightspace, using your student credentials.
| Module Content & Assessment | |
|---|---|
| Assessment Breakdown | % |
| Other Assessment(s) | 100 |