Information Management (R)
1
Foundation Degree in Professional Administration
BB2401 Assignment/Report: INFORMATION MANAGEMENT
It should be submitted by 13:00 on Wednesday May 2nd 2012
No late projects will be accepted unless accompanied by an
appropriately signed extension form
Aims of the assignment:
To develop an awareness of the importance of IT in the new business
environment.
To understand the development of operational systems for real-life business and
organisations.
To learn how to analyse IT problems and how to design and implement IT
solutions.
Title of the assignment:
Report on an IT problem: (3000 words)
Tasks:
Choose an IT related problem that your company or organization has and which will
include the need for the building of a small database:
1) Define the problem
2) Describe the various dimensions and parameters of the problem.
3) Create a feasibility analysis (economic, technical, organizational, operational
problems and dimensions).
4) List the requirements and explain the reasons for this requirements specification.
5) Derive the requirements specifications if necessary through the use a
questionnaire and or use of interviews.
6) Analyse the problem through a Context Diagram.
7) Use a simple Dataflow diagram to describe the solution(s).
8) Define the various entities and use an Entity Relationship Diagram to describe
the relationships between the various entities (not necessary but beneficial).
9) Create a recommended model / solution to the problem.
This will consist of a small Access Database with a minimum of two related
tables. You should show and explain the table structures and relationships.
10) List the various security and maintenance problems and discuss their potential
solutions when implementing the solutions.
The report should be in a professional business style; word processed, properly bound
and should have no more than 3000 words.
11) An electronic copy of the report and the relevant files and appendices should
be submitted on Blackboard in addition to the above hardcopy. You must also
submit a copy of the Access database file electronically.
12) A pass mark of 40% must be obtained to pass the module.
2
Assignment Marking Scheme for Information Management
Foundation Degree for Business & Professional Administration
(Incl Law stream)
Clarity of Structure, Style and Report Presentation (cover page,
titles names dates etc, contents generated by word, different
headers and or footers in even and odd pages, references,
appendices number separately, etc): 10
Systems Analysis
Organisational Background (Executive Summary)
Problem Definition including
description/weaknesses/failings of current system.
Project initiation
Cost Benefit Analysis
Requirements definition and analysis
Statement of Requirements
30
Systems Design
Information Flow Diagram
Data Flow Diagram showing key processes
Entity Relationship diagram
Data Dictionary with explanations and key fields
30
Database
Creation of a small database with at least one relationship
Additional marks awarded for Queries, Forms and Reports
according to relevance and complexity
(Two tables is sufficient, with an absolute maximum of five
tables. Maximum two forms, two queries and two reports)
20
Conclusions Related to Organisational Context and System
usefulness. Recommendations as Appropriate, Executive
Summary
10
Total 100