Teaching Responsibility
LJMU Schools involved in Delivery:
Computer Science and Mathematics
Learning Methods
Lecture
Practical
Module Offerings
5202COMP-SEP-CTY
Aims
To implement relational database designs using a Relational Database Management System (RDBMS)
To employ database connectivity technologies in developing data driven applications.
To investigate the administration of a RDBMS.
To critically evaluate and implement alternative / non-relational database designs using NoSQL.
Learning Outcomes
1.
Design and implement a relational database to support a given computing problem
2.
Develop a data driven application using a database
3.
Critically evaluate the advantages & disadvantages of NoSQL.
4.
Design and implement an appropriate non-relational database
Module Content
Outline Syllabus:Introducing RDBMS
SQL
-Components & DDL (for Tables)
-DML (for SELECT)
-DML (for JOINS & INSERT - UPDATE - DELETE)
-Views & Indices (DDL & DML)
-SPROCs & Triggers (DDL & DML)
Connectivity
-Client Server vs Embedded DBs
-Connectivity APIs
Administration of RDBMS
-Security & Permissions
-Replicating Data
-Optimizing Queries
NoSQL
-Key-Value & Document Store
Module Overview:
In this module you will explore the operation of database systems through a scrutiny of modern RDBMS (Relational Data Base Management Systems), the SQL (Structured Query Language) and database connectivity APIs (Application Programming Interfaces). The module continues by exploring some of the managerial considerations of large-scale RDBMS. The module concludes by exploring the operation of emerging NoSQL (Not Only SQL) database systems. Overall, you will design relational databases, develop date driven applications, critically evaluate applications, and design appropriate non-relational databases.
In this module you will explore the operation of database systems through a scrutiny of modern RDBMS (Relational Data Base Management Systems), the SQL (Structured Query Language) and database connectivity APIs (Application Programming Interfaces). The module continues by exploring some of the managerial considerations of large-scale RDBMS. The module concludes by exploring the operation of emerging NoSQL (Not Only SQL) database systems. Overall, you will design relational databases, develop date driven applications, critically evaluate applications, and design appropriate non-relational databases.
Additional Information:The module begins by exploring the operation of database systems through a scrutiny of modern RDBMS (Relational Database Management Systems), the SQL (Structured Query Language) and database connectivity APIs (Application Programming Interfaces). The module continues by exploring some of the managerial considerations of large-scale RDBMS. The module concludes by exploring the operation of emerging NoSQL (Not Only SQL) database systems. This module thusly represents the logical follow-on to NQF4’s Data Modelling module.