production
Skip to Content

JC2504: PRINCIPLES AND PRACTICE OF DATABASE SYSTEMS (2022-2023)

Last modified: 31 Jul 2023 11:19


Course Overview

Databases are an important part of traditional information systems (offline /online) as well as modern data science pipelines. This course will be of interest to anyone who wishes to learn to design and query databases using major database technologies. The course aims to teach the material using case studies from real-world applications, both in lectures and lab classes.

In addition, the course covers topics including management of different kinds of data such as spatial data and data warehousing. The course provides more hands-on training that develops skills useful in practice.

Course Details

Study Type Undergraduate Level 2
Session Second Sub Session Credit Points 20 credits (10 ECTS credits)
Campus Offshore Sustained Study No
Co-ordinators
  • Ms Sheryl MacKay

What courses & programmes must have been taken before this course?

  • Any Undergraduate Programme (Studied)

What other courses must be taken with this course?

None.

What courses cannot be taken with this course?

None.

Are there a limited number of places available?

No

Course Description

This course consists of two halves. The first half is an introduction to data management: it aims at providing students with both an in-width and an in-depth understanding of disciplined approaches to data management. This will mainly help students learn foundational concepts such as data models, query languages and database design, and learn to apply them to solve practical problems.

The second half depends on the first. It is designed for students with an interest in the application of Data Management in a broad range of professions and areas including IT, Geosciences, Natural Sciences, Engineering, Life Sciences and Medicine, Education, Management, Accounting, Finance, and Social Sciences. The course offers skills training in, and knowledge of, database design and querying, data warehousing and spatial databases.


Contact Teaching Time

Information on contact teaching time is available from the course guide.

Teaching Breakdown

More Information about Week Numbers


Details, including assessments, may be subject to change until 31 August 2023 for 1st half-session courses and 22 December 2023 for 2nd half-session courses.

Summative Assessments

Exam

Assessment Type Summative Weighting 70
Assessment Weeks Feedback Weeks

Look up Week Numbers

Feedback

Feedback provided in person

Learning Outcomes
Knowledge LevelThinking SkillOutcome
ProceduralAnalyseAble to analyse and describe some aspect of the real world in terms of a conceptual model
ProceduralApplyAble to perform basic data administration tasks
ProceduralApplyKnowledge and skill in management of different kinds of data such as spatial data
ProceduralApplyAble to design and use queries in a query language
ProceduralApplyKnowledge and skill in data warehousing
ProceduralApplyAbility to apply knowledge of the basic organisation and functionality of a variety of types of database system
ProceduralApplyThe outcome of the course is, by its nature, widely applicable. In its broadest terms, students will learn to apply a rigorous approach to design methodology

Computer Programming Exercise

Assessment Type Summative Weighting 30
Assessment Weeks Feedback Weeks

Look up Week Numbers

Feedback

Feedback provided in writing

Learning Outcomes
Knowledge LevelThinking SkillOutcome
ProceduralAnalyseAble to analyse and describe some aspect of the real world in terms of a conceptual model
ProceduralApplyThe outcome of the course is, by its nature, widely applicable. In its broadest terms, students will learn to apply a rigorous approach to design methodology
ProceduralApplyKnowledge and skill in management of different kinds of data such as spatial data
ProceduralApplyAble to perform basic data administration tasks
ProceduralApplyKnowledge and skill in data warehousing
ProceduralApplyAble to design and use queries in a query language
ProceduralApplyAbility to apply knowledge of the basic organisation and functionality of a variety of types of database system

Formative Assessment

There are no assessments for this course.

Resit Assessments

Same as above with continuous assessment mark carried forward

Assessment Type Summative Weighting
Assessment Weeks Feedback Weeks

Look up Week Numbers

Feedback
Learning Outcomes
Knowledge LevelThinking SkillOutcome
Sorry, we don't have this information available just now. Please check the course guide on MyAberdeen or with the Course Coordinator

Course Learning Outcomes

Knowledge LevelThinking SkillOutcome
ProceduralApplyKnowledge and skill in data warehousing
ProceduralApplyAble to perform basic data administration tasks
ProceduralAnalyseAble to analyse and describe some aspect of the real world in terms of a conceptual model
ProceduralApplyAbility to apply knowledge of the basic organisation and functionality of a variety of types of database system
ProceduralApplyKnowledge and skill in management of different kinds of data such as spatial data
ProceduralApplyAble to design and use queries in a query language
ProceduralApplyThe outcome of the course is, by its nature, widely applicable. In its broadest terms, students will learn to apply a rigorous approach to design methodology

Compatibility Mode

We have detected that you are have compatibility mode enabled or are using an old version of Internet Explorer. You either need to switch off compatibility mode for this site or upgrade your browser.