CS2S571 - Databases and Data Modelling 01 Sep 2022 - 31 Aug 2028 | Version 1
Associated Module Information
| Module Code: | CS2S571 | ||
|---|---|---|---|
| Module Title: | Databases and Data Modelling | ||
| Faculty: | Faculty of Computing, Engineering and Science | ||
| Faculty Group: | Computing and Mathematical Sciences | ||
| Faculty Sub Group: | Computer Science | ||
| Module Leader: | Shiny Verghese | ||
| Module Team: | Christopher Tubb | ||
| First Intended Intake: | SEP 2022 | Final Year of Intake: | 2027 |
| Date Closed: | |||
| Credit Value: | 20 | Credit Level: | 5 |
| Language: | English | ||
| Percentage of Module Taught in Welsh: | 0 | ||
| Equivalent Module: | |||
| HECOS codes: | 100754 - databases | ||
| HECOS Code Weighting: | 100 | ||
Document Version Information
| Version | 1 |
|---|---|
| Valid From | 01 Sep 2022 |
| Valid To | 31 Aug 2028 |
Module Aims
The module aims to explore a range of database technologies, provide theoretical and practical foundations for relational database architecture and data independence, practical use of query language and in addition highlight approaches for managing large volumes of data such as distributed/cloud and NoSQL database systems. Finally, database security will also be addressed.
Content Summary
Database systems
- Relational data model
- SQL
- Relational algebra
Database design
- Conceptual database design (ER diagrams)
- Logical database design (ER to SQL)
- Physical database design (indexes)
Review of applications that require support for massive quantities of data, with reference to distributed/cloud Databases.
Non-relational database models, management methods (NoSQL) for access to large, distributed datasets.
Database Security and integrity
Learning and Teaching Methods
| Activity Type | Hours |
|---|---|
| Lecture | 24 |
| Practical classes and workshops | 24 |
| Independent Study | 80 |
| Directed Study | 52 |
| Problem / challenge based learning | 20 |
| Total Hours Selected | 200 |
Learning Outcomes
| # | Learning Outcome |
|---|---|
| LO1 | To design a relational database including conceptual, logical and physical design, describe the components, explain the concept of data independence and demonstrate use of SQL to elicit information from a database. |
| LO2 | To compare contrast and describe major approaches to storing and processing large volumes of data, understand the difference between relational and NoSQL database, use markup language(s) to model information, and demonstrate understanding of issues concerning database security and integrity. |
Module Requisites
| Code | Title | Requisite Type |
|---|---|---|
| MOD011892 | Information Management, Assurance and Security | pre-requisite |
Assessment Criteria
| Assessment Category | Assessment Type | Description | Duration | Word Count | Weight (%) | Best of? | Pass Mark |
|---|---|---|---|---|---|---|---|
| Asynchronous Assessment | Practical Coursework 2 (Asynch) | A report that draws on knowledge and material | 0 | 2000 | 50 | No | 40 |
| Asynchronous Assessment | Practical Coursework 1 (Asynch) | A report detailing the analysis, design and implementation project. | 0 | 2000 | 50 | No | 40 |
Assessment Matrix
| Assessment Type | Learning Outcomes | ||
|---|---|---|---|
| LO1 | LO2 | ||
| Practical Coursework 2 (Asynch) | ✔ | ✔ | |
| Practical Coursework 1 (Asynch) | ✔ | ✔ | |