| Semester 1 Credit Value: | 10 |
| ECTS Credits: | 5.0 |
N/A
N/A
To introduce the fundamentals of database system design and use.
Relational Modelling.
XML representation of data.
NoSQL.
ORMs.
- To have knowledge and understanding of top-down and bottom-up approaches to database design.
- To have knowledge and understanding of models, processes and techniques used in database design.
- To be able to construct and critique entity-relationship and relational models.
- To be able to apply normalisation techniques.
- To be able to use SQL for data definition and manipulation.
- To be able to use standard SQL implementations (mySQL).
| Category | Activity | Number | Length | Student Hours | Comment |
|---|---|---|---|---|---|
| Guided Independent Study | Assessment preparation and completion | 22 | 1:00 | 22:00 | practical coursework: Database implementation activity (9 hours), Database design activity and implementation activity (9 hours). |
| Scheduled Learning And Teaching Activities | Lecture | 10 | 2:00 | 20:00 | lectures will either be live or recorded in advance. |
| Scheduled Learning And Teaching Activities | Practical | 20 | 1:00 | 20:00 | Practicals (PIP or online) |
| Scheduled Learning And Teaching Activities | Drop-in/surgery | 10 | 1:00 | 10:00 | Optional drop-in/clinic (PiP or Online) |
| Guided Independent Study | Independent study | 10 | 1:00 | 10:00 | Lecture follow-up |
| Guided Independent Study | Independent study | 1 | 18:00 | 18:00 | Background reading |
| Total | 100:00 |
Lectures will be recorded in advance or conducted live and be used to introduce the learning material and for demonstrating the key concepts by example. Students are expected to follow-up lectures within a few days by re-reading and annotating lecture notes to aid deep learning. This is a very practical subject and learning materials are supported by hands-on opportunities provided by practical classes. Students are expected to spend time on coursework outside timetabled drop-in sessions.
Students aiming for distinction marks are expected to widen their knowledge beyond the content of lecture notes through background reading.
The format of resits will be determined by the Board of Examiners
| Description | Semester | When Set | Percentage | Comment |
|---|---|---|---|---|
| Practical/lab report | 1 | M | 50 | 1 Database implementation activity (9 hours) |
| Design/Creative proj | 1 | M | 50 | 1 Database design activity and implementation activity (9 hours) |
Techniques and theory are presented in lectures and assessed with the aid of practical examples and case studies. Practical assignments are used to enforce the principles that are taught and are assessed directly.
N/A
Disclaimer: The information contained within the Module Catalogue relates to the 2023/24 academic year. In accordance with University Terms and Conditions, the University makes all reasonable efforts to deliver the modules as described. Modules may be amended on an annual basis to take account of changing staff expertise, developments in the discipline, the requirements of external bodies and partners, and student feedback. Module information for the 2024/25 entry will be published here in early-April 2024. Queries about information in the Module Catalogue should in the first instance be addressed to your School Office.