Skip to main content

Module

CSC8017 : Database Systems

  • Offered for Year: 2022/23
  • Module Leader(s): Dr Dan Nesbitt
  • Lecturer: Dr John Colquhoun
  • Owning School: Computing
  • Teaching Location: Newcastle City Campus
Semesters
Semester 1 Credit Value: 10
ECTS Credits: 5.0

Aims

To introduce the fundamentals of database system design and use.

Outline Of Syllabus

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

Teaching Methods

Teaching Activities
Category Activity Number Length Student Hours Comment
Guided Independent StudyAssessment preparation and completion101:0010:00Lecture follow-up
Scheduled Learning And Teaching ActivitiesLecture102:0020:00Depending on the situation at the time, lectures will either be live or recorded in advance.
Scheduled Learning And Teaching ActivitiesPractical201:0020:00Practicals (PIP or online)
Guided Independent StudyProject work221:0022:00practical coursework
Scheduled Learning And Teaching ActivitiesDrop-in/surgery101:0010:00Optional drop-in/clinic (PiP or Online)
Guided Independent StudyIndependent study118:0018:00Background reading
Total100:00
Teaching Rationale And Relationship

Lectures will be recorded in advance(or conducted live if permitted) 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.

Assessment Methods

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

Other Assessment
Description Semester When Set Percentage Comment
Practical/lab report1M1001 Database implementation activity (9 hours)
Formative Assessments
Description Semester When Set Comment
Design/Creative proj1M1 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.

Reading Lists

Timetable