Next: MC193 Information Systems
Up: Year 1
Previous: MC180 Project Skills
MC192 Information Processing
| Credits: 10 |
Convenor: Dr. N. D. N. Measor |
Semester: 2 |
| Prerequisites: |
|
desirable: MC199 or MC198 or equivalent |
| Assessment: |
Continuous assessment: 100% |
none: none% |
| Lectures: |
12 |
Classes: |
none |
| Tutorials: |
2 |
Private Study: |
43 |
| Labs: |
18 |
Seminars: |
none |
| Project: |
none |
Other: |
none |
| 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
- To understand the basics data organisation, storage,
and retrieval, and relational modelling.
- To be able to design, create and query a simple database in Microsoft
Access.
Transferable Skills
- The ability to design and implement a small database
in Microsoft Access.
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: MC180 Project Skills
S. J. Ambler
11/20/1999