Overview

This module aims to help you appreciate the importance of using a database within a real-life situation. On the course you will construct a database and then use it to identify and solve problems within a simulated business context.

The module develops transferable skills for both business and computing students which will help you when you progress onto level 4 of your degree.

Key topics: 1. Key concepts and skills in the use of tabular data and databases 2. An introduction to the underlying technologies 3. Construction and interpretation of tabular data on paper 4. Accessing data held in a small database 5. Concept of key data types 6. Extending tables in an existing database 7. Development of a system appropriate to the small, simulated business 8. Use of the database to respond to queries, solve problems and support the information flow within the simulated business to aid its business operations and, in particular, its reporting functions

Assessment Strategy

Threshold (40-49% / D- to D+): Student has made sufficient progress in the study of this module to achieve the lowest level of pass allowing for progression onto an undergraduate degree.

Satisfactory (50 – 59% / C- to C+): Student demonstrates reasonably comprehensive coverage of learning outcomes, indicating generally accurate understanding, based on lecture material and some core readings. Some gaps in knowledge and/or understanding evident.

Good (60-69% / B- to B+): Student has displayed a sound basic knowledge and understanding of much of the material studied in this module and achieved a high enough grade to indicate a clear ability to cope with the demands of an undergraduate level degree.

Excellent (70% + / A- to A*): Student has engaged consistently well with all aspects of the module and strong achievement in assessments indicates the ability to perform effectively at undergraduate degree level.

Learning Outcomes

• Demonstrate the ability to work individually and in groups to construct and use a database in a simulated business situation

• Extend tables of data in an existing database to cater for additional needs and requirements

• Respond to a range of queries and provide additional information required within the simulated business

• Solve problems using a database

• Use and interpret tabular data presented both on paper and in an existing database