Sale!
Placeholder

An Information Systems Framework for Leeds University Press Office

10,000 3,000

108 Pages | chapter 1-5 | PDF and Microsoft Format

Topic Description

An Information Systems Framework for Leeds University Press Office

Summary
This project details the construction of an information systems framework for Leeds University Press Office, from gathering requirements right through to evaluating the finished product. The information system created is a framework consisting of a database, a public interface and a maintenance interface. The database contains details on various aspects of the history of Leeds University and is administered via the maintenance interface. The public interface is a web-site that allows users to search for information contained in the database using various search criteria.

Table of Contents
1 INTRODUCTION……………………………………………………………………………………………………….1
1.1 THE PROBLEM ………………………………………………………………………………………………………….1
1.2 THE CURRENT SYSTEM………………………………………………………………………………………………1
1.3 PROPOSED SYSTEM……………………………………………………………………………………………………2
2 BACKGROUND RESEARCH…………………………………………………………………………………….3
2.1 CAMBRIDGE UNIVERSITY…………………………………………………………………………………………..3
2.2 OXFORD UNIVERSITY………………………………………………………………………………………………..3
2.3 LONDON SCHOOL OF ECONOMICS (LSE) ……………………………………………………………………..3
2.4 IMPERIAL COLLEGE LONDON (ICL) …………………………………………………………………………….4
2.5 UNIVERSITY COLLEGE LONDON (UCL) ……………………………………………………………………….4
2.6 HARVARD UNIVERSITY, USA …………………………………………………………………………………….4
2.7 PRINCETON UNIVERSITY, USA …………………………………………………………………………………..4
2.8 CONCLUSIONS DRAWN FROM BACKGROUND RESEARCH…………………………………………………4
3 DEVELOPMENT METHODOLOGIES………………………………………………………………………6
3.1 STRUCTURING THE PROBLEM……………………………………………………………………………………..6
3.2 DATABASE DEVELOPMENTMETHODOLOGIES ………………………………………………………………7
3.2.1 Connolloy and Beggs Nine Step Approach…………………………………………………………..7
3.2.2 Elmasri and Nevathes Six Step Approach ……………………………………………………………7
3.2.3 Database Development Methodology Choice ………………………………………………………8
3.3 SOFTWARE DEVELOPMENTMETHODOLOGIES ………………………………………………………………8
3.3.1 Structured Systems Analysis and Design Method (SSADM) …………………………………..8
3.3.2 Rapid Application Development (RAD)……………………………………………………………….9
3.3.3 Software Development Life Cycle……………………………………………………………………….9
3.3.4 Software Development Methodology Choice………………………………………………………10
4 ANALYSIS ……………………………………………………………………………………………………………….11
4.1 REQUIREMENTS ………………………………………………………………………………………………………11
4.1.1 Identifying the users of the system…………………………………………………………………….11
4.1.2 Requirements Collection………………………………………………………………………………….11
4.1.3 Requirements Analysis…………………………………………………………………………………….13
4.1.4 Functional Requirements…………………………………………………………………………………13
4.1.5 Non-Functional Requirements………………………………………………………………………….13
4.2 BUSINESS RULES …………………………………………………………………………………………………….14
An Information Systems Framework for Leeds University Press Office
__________________________________________________________________________________________________
v
4.3 CONCLUSION ………………………………………………………………………………………………………….14
5 DESIGN ……………………………………………………………………………………………………………………15
5.1 DATABASE DESIGN………………………………………………………………………………………………….15
5.1.1 Entities ………………………………………………………………………………………………………….15
5.1.2 Attributes……………………………………………………………………………………………………….15
5.1.3 Relationships………………………………………………………………………………………………….16
5.1.4 Entity-Relation (ER) Model ……………………………………………………………………………..16
5.1.5 Database Schema……………………………………………………………………………………………17
5.1.6 Normalisation ………………………………………………………………………………………………..17
5.1.7 Integrity Constraints……………………………………………………………………………………….19
5.1.8 Input Validation ……………………………………………………………………………………………..19
5.2 MAINTENANCE INTERFACE……………………………………………………………………………………….19
5.3 PUBLIC INTERFACE ………………………………………………………………………………………………….20
5.4 CONCLUSION ………………………………………………………………………………………………………….21
6 COMPARISON OF SOFTWARE DEVELOPMENT TOOLS ……………………………………22
6.1 DATABASEMANAGEMENT SYSTEMS (DBMS)…………………………………………………………….22
6.1.1 Microsoft Access …………………………………………………………………………………………….22
6.1.2 Microsoft SQL Server ……………………………………………………………………………………..22
6.1.3 Oracle Server…………………………………………………………………………………………………23
6.1.4 Choice of DBMS …………………………………………………………………………………………….23
6.2 HTML EDITORS ……………………………………………………………………………………………………..23
6.2.1 VIM ………………………………………………………………………………………………………………23
6.2.2 Macromedia Dreamweaver ……………………………………………………………………………..24
6.2.3 Microsoft Visual Studio.NET……………………………………………………………………………24
6.2.4 Choice of HTML Editor …………………………………………………………………………………..24
6.3 SERVER SIDE SCRIPTING TECHNOLOGIES …………………………………………………………………..24
6.3.1 Active Server Pages (ASP)……………………………………………………………………………….25
6.3.2 Common Gateway Interface (CGI)……………………………………………………………………25
6.3.3 Hypertext Pre-Processor (PHP)……………………………………………………………………….25
6.3.4 Choice of Server Side Scripting Technology ………………………………………………………25
6.4 CONCLUSION ………………………………………………………………………………………………………….26
7 IMPLEMENTATION ……………………………………………………………………………………………….27
7.1 DATABASE IMPLEMENTATION…………………………………………………………………………………..27
7.1.1 Tables……………………………………………………………………………………………………………27
An Information Systems Framework for Leeds University Press Office
__________________________________________________________________________________________________
vi
7.1.2 Relationships………………………………………………………………………………………………….27
7.2 MAINTENANCE INTERFACE……………………………………………………………………………………….29
7.2.1 Add Forms……………………………………………………………………………………………………..29
7.2.2 Delete Forms………………………………………………………………………………………………….30
7.2.3 Edit Forms …………………………………………………………………………………………………….30
7.2.4 Macros ………………………………………………………………………………………………………….31
7.3 PUBLIC INTERFACE ………………………………………………………………………………………………….31
7.3.1 Main Page……………………………………………………………………………………………………..32
7.3.2 Sub-Pages ……………………………………………………………………………………………………..33
7.3.3 Results Pages …………………………………………………………………………………………………33
7.4 CONCLUSION ………………………………………………………………………………………………………….34
8 TESTING………………………………………………………………………………………………………………….35
8.1 DATABASE ……………………………………………………………………………………………………………..35
8.1.1 Testing Integrity Constraints ……………………………………………………………………………35
8.2 MAINTENANCE INTERFACE……………………………………………………………………………………….35
8.2.1 Macro Testing………………………………………………………………………………………………..36
8.2.2 Functionality Testing………………………………………………………………………………………36
8.3 PUBLIC INTERFACE ………………………………………………………………………………………………….37
8.3.1 Navigation Testing………………………………………………………………………………………….37
8.3.2 Functionality Testing………………………………………………………………………………………37
8.4 CONCLUSION ………………………………………………………………………………………………………….38
9 EVALUATION………………………………………………………………………………………………………….39
9.1 MAINTENANCE INTERFACE……………………………………………………………………………………….39
9.1.1 Participative Evaluation………………………………………………………………………………….39
9.1.2 Heuristic Evaluation……………………………………………………………………………………….40
9.2 PUBLIC INTERFACE ………………………………………………………………………………………………….41
9.2.1 Participative Evaluation………………………………………………………………………………….41
9.2.2 Heuristic Evaluation……………………………………………………………………………………….41
9.2.3 HTML Coding ………………………………………………………………………………………………..42
9.3 REQUIREMENTS ………………………………………………………………………………………………………43
9.3.1 Minimum Requirements …………………………………………………………………………………..43
9.3.2 Functional Requirements…………………………………………………………………………………44
9.3.3 Non-Functional Requirements………………………………………………………………………….45
9.4 CONCLUSION ………………………………………………………………………………………………………….

GET COMPLETE PROJECT