Databases Construction & Use
Short Course - 15 credits at SCQF 11
This course will develop your skill in the practical implementation of database applications in a relational database management system (RDBMS). It will enable you to explore the main features of a DBMS and different models of database architecture (hierarchical, network, relational, object−oriented)
- Evaluate critically the different forms of DBMS architecture.
- Creating and Linking database tables
- Network and hierarchical data models
- The object-oriented data model
- RDBMS and conceptual modelling
- Retrieving data using queries
- Conceptual Modelling
- Changing data using queries
- E-R model to relational model
- Form Creation
- Normal forms
- Access Basic
- Database Administration
On completion of this module, you will be able to:
- Design a normalised database in relational form.
- Demonstrate database table creation and analyse effective database querying in SQL.
- Implement, test and evaluate a relational database application using a DBMS.
- Explain the main features of a DBMS and analyse the principles used in DBMS design.
The University regularly reviews its courses. Course content and structure may change over time. See our course and module disclaimer for more information.
You will learn through a mix of online lectures, interactive work and self-guided study. Attendance at the University is therefore not required.
All learning outcomes will be assessed by an exercise requiring the design and creation of a database.
The Disability & Dyslexia Centre advises and supports students who disclose a sensory or mobility impairment, chronic medical condition, mental health issue, dyslexia and other specific learning differences. Applicants are encouraged to arrange a pre-entry visit to discuss any concerns and to view the facilities.
Study Skills Support
The Study Support Team provides training and support to all students in:
- Academic writing
- Study skills (note taking, exam techniques, time management, presentation)
- Maths and statistics
- English language
- Information technology support
This course is ideal for students who possess an undergraduate honours degree in any discipline or who have relevant work experience.
All international students, for whom English is not their first language, will need either IELTS 6.5 or its equivalent in TOEFL.
For new intakes course fees are reviewed and published annually for each mode of delivery. Tuition fees are fixed for the duration of a course at the rate confirmed in the offer letter. For further information see:
This module is part of the MSc Information Management course, which is accredited by CILIP.
Taking this course, you will have access to some of the world's best facilities.
We've invested more than £100 million in the development of our campus, new facilities and new resources.University Wide Facilities