Postgraduate Course: Data Management (CMSE11646)
Course Outline
| School | Business School |
College | College of Arts, Humanities and Social Sciences |
| Credit level (Normal year taken) | SCQF Level 11 (Postgraduate) |
| Course type | Online Distance Learning |
Availability | Not available to visiting students |
| SCQF Credits | 10 |
ECTS Credits | 5 |
| Summary | Data Management delves into fundamental and advanced principles and applications of databases within the context of real-world database structures. |
| Course description |
This course offers an exploration into managing and manipulating data through Database Management Systems (DBMS), with a strong emphasis on Structured Query Language (SQL). It provides a comprehensive understanding of how data is stored, retrieved, and managed, focusing on relational databases, data integrity, query optimisation, and the practical applications of SQL in real-world scenarios.
Outline Content
The course will cover a subset of the following topics: an introduction to Database Management Systems, applications of database technology, key definitions and architecture, database users and languages, database modelling, and integrity constraints. It also emphasises on the relational and entity-relationship models, highlighting their significance in database design and implementation.
Student Learning Experience
Tutorial/seminar hours represent the minimum total live hours - online - a student can expect to receive on this course. These hours may be delivered in tutorial/seminar, workshop or other interactive whole class or small group format. These live hours may be supplemented by pre-recorded lecture material for students to engage with asynchronously. Live sessions will be delivered only once.
|
Entry Requirements (not applicable to Visiting Students)
| Pre-requisites |
|
Co-requisites | |
| Prohibited Combinations | |
Other requirements | None |
Course Delivery Information
|
| Academic year 2024/25, Not available to visiting students (SS1)
|
Quota: None |
| Course Start |
Block 2 (Sem 1) |
Timetable |
Timetable |
| Learning and Teaching activities (Further Info) |
Total Hours:
100
(
Lecture Hours 10,
Programme Level Learning and Teaching Hours 2,
Directed Learning and Independent Learning Hours
88 )
|
| Assessment (Further Info) |
Written Exam
0 %,
Coursework
100 %,
Practical Exam
0 %
|
| Additional Information (Assessment) |
100% Project report (Individual) - Assesses all course Learning Outcomes |
| Feedback |
Formative: Feedback will be provided throughout the course.
Summative: Feedback will be provided on assessments within agreed deadlines. |
| No Exam Information |
Learning Outcomes
On completion of this course, the student will be able to:
- Understand the fundamentals of databases, including the relational model and SQL syntax, to construct and manipulate database structures effectively.
- Apply their knowledge to design, create, and manage databases and develop proficiency in writing complex SQL queries.
- Analyse and solve real-world data management problems by implementing advanced SQL features.
- Critically evaluate and optimise database queries for efficiency and performance.
- Communicate database features and designs effectively to a critical business audience.
|
Reading List
Core Text
Connolly T M, Begg C E. Database systems: a practical approach to design, implementation, and management. Pearson Education, 2015. |
Additional Information
| Graduate Attributes and Skills |
Communication, ICT, and Numeracy Skills
After completing this course, students should be able to:
Convey meaning and message through a wide range of communication tools, including digital technology and social media; to understand how to use these tools to communicate in ways that sustain positive and responsible relationships.
Critically evaluate and present digital and other sources, research methods, data and information; discern their limitations, accuracy, validity, reliability and suitability; and apply responsibly in a wide variety of organisational contexts.
Knowledge and Understanding
After completing this course, students should be able to:
Demonstrate a thorough knowledge and understanding of contemporary organisational disciplines; comprehend the role of business within the contemporary world; and critically evaluate and synthesise primary and secondary research and sources of evidence in order to make, and present, well informed and transparent organisation-related decisions, which have a positive global impact.
Identify, define and analyse theoretical and applied business and management problems, and develop approaches, informed by an understanding of appropriate quantitative and/or qualitative techniques, to explore and solve them responsibly.
|
| Keywords | Database Management Systems,Structured Query Language (SQL),Database Design,Data Integrity |
Contacts
| Course organiser | Dr Xiyuan Ma
Tel: (0131 6)50 8074
Email: Xiyuan.Ma@ed.ac.uk |
Course secretary | Mx Fran Knocke
Tel:
Email: Fran.Knocke@ed.ac.uk |
|
|
University Homepage