Introduction to information systems must all be
bound together in a single volume in the sequence:
1. database assignment
2. spreadsheet assignment.
The form accompanying the project work (contained in the booklet) must
be completely filled in and signed, and one copy should be used as the first
page of
each assignment. Among other things, the form asks for details
of the hardware and software used in the preparation of the assignment.
Simple straightforward answers are all that is required here; for example,
Hardware: Samsung NC10 note book and HP LaserJet 2600n; Software:
Microsoft Word 2007.
2.3 Database assignment Reading activity Read Section 13.2, Chapter 13 of Curtis and Cobham (2008), Chapter 6 of Laudon and
Laudon (2013).
The aim of this assignment is to demonstrate an understanding of the
basics of analysis and design for databases as well as to provide evidence
of the use of the main features of a database package. In carrying out this
assignment, you should refer to the class modelling section of this guide
(Chapter 8) as well as the relevant bibliography. You will be expected to
demonstrate the following through the analysis, design and construction
of a small database application:
• selection of a suitable problem to be solved by a database application
• production of a class diagram using UML notation– this is a logical
database design that reflects the aspects of the world that you store
data about
• production of a set of normalised relations – a physical database design
• design of a data input screen or screens
• design of a query screen
• design of a report for use on screen and/or for printing on paper.
Two example assignments are given below.
These are intended to illustrate the type of problem that you are expected to
