Databases Construction & Use

Short Course - 15 credits at SCQF 11

Databases Construction & Use; 15 credits at SCQF 11
This module will give you the ability to explain the key concepts of database design and manipulation, using the relational model.

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.
This course has one study option
Mode of Attendance
Mode of Study
Start Date
Course Length
Mode of Attendance
  • Online Distance Learning
Mode of Study
  • Part Time
Start Date
January
Course Length
15 weeks
  • 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
  • SQL
  • Reports
  • Access Basic
  • Database Administration

On completion of this module, you will be able to:

  1. Design a normalised database in relational form.
  2. Demonstrate database table creation and analyse effective database querying in SQL.
  3. Implement, test and evaluate a relational database application using a DBMS.
  4. Explain the main features of a DBMS and analyse the principles used in DBMS design.

You will learn through a mix of online lectures, interactive work and self-guided study. Attendance at the University is therefore not required. 

Assessment

All learning outcomes will be assessed by an exercise requiring the design and creation of a database.

Academic Support

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.

Disability & Dyslexia Centre

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

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

Course fees: £980

Additional Costs

The following course-related costs are not included in the course fees:

Other Fees and Charges

Disclaimer

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:

STUDENT FINANCE

Have a question about a Professional Development course? Get in touch with the team and we'll do our best to help.

Accreditation

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

Apply

Have a question about a Professional Development course? Get in touch with the team and we'll do our best to help.


Register direct to the university using our online application form. 

Applications close 1 week prior to the start of the module.