[The University of Leicester]

Department of Mathematics & Computer Science



Next: MC193 Information Systems Up: Year 1 Previous: MC183 Dynamical Systems

MC192 Information Processing

MC192 Information Processing

Credits: 10 Convenor: Dr. N. D. N. Measor Semester: 2
Prerequisites: desirable: MC199 or MC198 or equivalent
Assessment: Continuous assessment: 100% Examination: 0%
Lectures: 12 Problem Classes: none
Tutorials: none Private Study: 33
Labs: 24 Seminars: none
Project: none Other: none
Surgeries: 6 Total: 75

Explanation of Pre-requisites

Some familiarity with basics of information technology as, for example in MC199 or MC198, would be helpful.

Course Description

A common use of computers is the storage, retrieval, and organisation of all kinds of information. A program which performs these tasks is known as a database, and this module teaches both the use of databases, and how they can be built.

Aims

The module will provide students with the opportunity to learn the basics of design and implementation of small databases. It will give experience in the use of a computer as a tool for managing and processing information. Students will become familiar with the software package Microsoft Access.

Objectives

Transferable Skills

Syllabus

Relational databases. What are data, data entities and attributes, relationships, keys. Relational modelling, Entity Relationship (ER) modelling, database design.

Query-By-Example: Microsoft Access. Creating a database and tables, data updating, querying the database, simple forms and report generation.

Reading list

Essential:

T. Connolly, C. Begg and A. Strachan, Database Systems, Addison-Wesley 1998.

A detailed reference text on Microsoft Access will be recommended during the module,

Recommended:

C. Betini, S. Ceri and S. Navathe, Conceptual Database Design, an Entity-Relationship Approach, Benjamin-Cummings 1992.

Details of Assessment

The module is examined entirely by continual assessment via several weekly exercises and the end of semester project.

Next: MC193 Information Systems Up: Year 1 Previous: MC183 Dynamical Systems

[University Home] [MCS Home] [University Index A-Z] [University Search] [University Help]

Author: S. J. Ambler, tel: +44 (0)116 252 3884
Last updated: 2001-09-20
MCS Web Maintainer
This document has been approved by the Head of Department.
© University of Leicester.