IT in Business:
Databases Equivalent to SCQF Level 7

A study of fundamental principles for database design and management.

Overview

Why take this course?

Today’s society is often described as the 'Information Society’ - where information is expected to be timely and accurate, and presented professionally. Individuals in the workplace now have access to, and are responsible for, the management and secure storage of large amounts of information.

This Unit is designed to provide candidates with the knowledge and skills for further study or employment in an administrative or IT environment. It introduces the database as a tool to help store, process and produce information in such a way as to be relevant to a manager and thus assist with management decision-making. Initially, you will focus on the analysis of a business problem, then the design and use of a database to collate data and turn it into information. On completion of the Unit you will be able to:

  • Design a relational database structure from source documents
  • Modify and store data using a relational database
  • Query and present information to aid decision-making

Credit points and level: 1 HN credit at SCQF level 7: (8 SCQF credit points at SCQF level 7)

What you will experience

Initially this Unit will focus on the analysis of a business problem, then the design and use of a database to collate data and turn it in to information. There are three outcomes:

In Outcome 1 you will learn how to analyse a business problem, identify the data you need to process and how best to order that data. Then you will be introduced to the relevant terminology as well as the basic concepts of database design. You will create a database structure using a relational database.

In Outcome 2 you will also learn how to input data, using tables. You will also design forms and demonstrate how to use these forms for both managing data and searching for specific records. Finally having created a database you will be introduced to the importance of storing information securely.

In Outcome 3 you will use the database facilities to help you solve a range of business problems. You will also use the database facilities to help you present the results in a format that is clear to the reader. You will also look at the range of statistical functions available within the report object. Having produced the appropriate information you will then be able to recommend a course of action to a business problem.

In order to complete this Unit successfully, you will be required to achieve a satisfactory level of performance in all assessed work. There are three assessments for this course that are carried out under open book controlled conditions. Your Tutor will mark your certified assessments. Any re-submissions, known as remediation, will also be directed and remarked by your tutor. Your work will then be cross-marked by an in college subject expert, a process called moderation. It is only then that a result can be sent to the Awarding Body for certification. A pass is not final until all cross-checking procedures have been successfully completed. Your pass will be notified to the SQA for certification.

Student writing

Key facts

Mode of study
Distance Learning
Method of study

This course requires you to manage your workload independently, and will involve attendance at a campus or centre - often for assessment purposes only.

Entry requirements

Previous experience in using a computer and database software would be beneficial. It is essential that you have experience in using a computer, the Windows interface and Windows terminology. 

What you will need

You will require use of/access to the Microsoft Outlook package.

What you need to know

Additional costs

This course involves an additional SQA fee. Please see our Courses Explained page for further information on costs.

Anything else?

Please note that fee waivers may apply.

Next steps

Education

At North East Scotland College

On successful completion of this course, you can progress to the following course at North East Scotland College: 

Employment

For more information about job opportunities, salaries and employment rates in this industry, visit the Career Coach website.

Availability

This course requires some attendance at College, often for assessment purposes only. Please enquire about expectations for your specific course when booking.

Attendance is usually at the Aberdeen City Campus or Fraserburgh Campus.

Pre-entry guidance is required prior to booking a place on this course. Please contact Brenda Bryce, Distance Learning Co-ordinator by email or on 01346 506014 in the first instance for more information. When submitting your distance learning application form, please ensure you attach the additional information sheet listing qualifications and previous knowledge with your application. You may be required to attend College for assessment. Please check if this is a requirement for your course.

Duration Fees Code
40 Hours over 6 Months £120.00
YBUDB
-O171A
Paper applications only

Paper applications

You must submit a paper application form and additional information form for this course and return them to us completed and signed.

Completed forms should be returned to the following freepost address:

The Student Information & Admissions Manager
North East Scotland College
FREEPOST RTJJ-TXBA-AEZS
Aberdeen City Campus
Gallowgate
Aberdeen
Scotland
UK AB25 1BN

Should you have any problems with your application, please contact the Student Advice Centre:

Telephone: 01224 612330
Email: enquiry@nescol.ac.uk

If you take up a place on a College course, at the start of the course you will be asked to sign an enrolment form. In signing the form and/or taking up a place on a College course, you will enter into a contract with the College and be bound by the North East Scotland College Standard Terms and Conditions of Study. Copies of the Terms and Conditions are available for inspection on notice boards and at various locations throughout the College, at the College Reception, on the College website: www.nescol.ac.uk, or can be obtained on request from the Student Funding and Admissions Manager, North East Scotland College, Aberdeen City Campus, Gallowgate, Aberdeen AB25 1BN. Please note that courses are offered subject to (a) there being sufficient numbers of enrolments and (b) the availability of resources. The College reserves its right (i) not to run courses where the number of students is considered insufficient or where resources are unavailable and (ii) in certain circumstances, to refuse admission to an individual applicant.