Module Catalogue 2024/25

CSC8017 : Database Systems

CSC8017 : Database Systems

  • Offered for Year: 2024/25
  • Module Leader(s): Dr Dan Nesbitt
  • Lecturer: Dr Essam Ghadafi, Dr John Colquhoun
  • Owning School: Computing
  • Teaching Location: Newcastle City Campus
Semesters

Your programme is made up of credits, the total differs on programme to programme.

Semester 1 Credit Value: 10
ECTS Credits: 5.0
European Credit Transfer System
Pre-requisite

Modules you must have done previously to study this module

Pre Requisite Comment

N/A

Co-Requisite

Modules you need to take at the same time

Co Requisite Comment

N/A

Aims

To introduce the fundamentals of database system design and use.

Outline Of Syllabus

Relational Modelling.
XML representation of data.
NoSQL.
ORMs.

Learning Outcomes

Intended Knowledge Outcomes

- 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.

Intended Skill Outcomes

- 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).

Teaching Methods

Teaching Activities
Category Activity Number Length Student Hours Comment
Guided Independent StudyAssessment preparation and completion221:0022:00practical coursework: Database implementation activity (9 hours), Database design activity and implementation activity (9 hours).
Scheduled Learning And Teaching ActivitiesLecture102:0020:00lectures will either be live or recorded in advance.
Scheduled Learning And Teaching ActivitiesPractical201:0020:00Practicals (PIP or online)
Scheduled Learning And Teaching ActivitiesDrop-in/surgery101:0010:00Optional drop-in/clinic (PiP or Online)
Guided Independent StudyIndependent study118:0018:00Background reading
Guided Independent StudyIndependent study101:0010:00Lecture follow-up
Total100:00
Teaching Rationale And Relationship

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.

Reading Lists

Assessment Methods

The format of resits will be determined by the Board of Examiners

Other Assessment
Description Semester When Set Percentage Comment
Practical/lab report1M501 Database implementation activity (9 hours)
Design/Creative proj1M501 Database design activity and implementation activity (9 hours)
Assessment Rationale And Relationship

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.

Timetable

Past Exam Papers

General Notes

N/A

Welcome to Newcastle University Module Catalogue

This is where you will be able to find all key information about modules on your programme of study. It will help you make an informed decision on the options available to you within your programme.

You may have some queries about the modules available to you. Your school office will be able to signpost you to someone who will support you with any queries.

Disclaimer

The information contained within the Module Catalogue relates to the 2024 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 2025/26 entry will be published here in early-April 2025. Queries about information in the Module Catalogue should in the first instance be addressed to your School Office.