Sale!
Placeholder

Analysis and design of an information system for the BSAC

10,000 3,000

Topic Description

 ALL listed project topics on our website are complete material from chapter 1-5 which are well supervised and approved by lecturers who are intellectual in their various fields of discipline, documented to assist you with complete, quality and well organized researched materials. which should be use as reference or Guild line...  See frequently asked questions and answeres



Summary
The primary aim of this project is to analyse and design an information system that could be
integrated into the Thrapston regional British Sub Aqua Club (BSAC). With the intension of
converting the current paper based system into a database system. The project involved the design and
implementation of a prototype to model to the user how the system would operate.
The current system was modelled with the use of UML diagrams and consultations with the Club
leader. From this requirements for the proposed system were extrapolated.
The system comprised of two major components, a database that was implemented using SQL Server
and a web interface that connected to the data source using Active Server Pages. The main task of this
interface was to update the records contained within the database via input forms.
The project has accomplished its main goal of analysing the current system and designing a proposed
system. Along with this additional features have been implemented to enhance the interface.

Contents
Chapter Page
Summary………………………………………………………………… i.
Acknowledgements……………………………………………………… ii.
Contents…………………………………………………………………. iii.
1 Introduction……………………………………………………….……..
1.1 Introduction to the BSAC………………………………………………… 1
1.2 Introduction to the problem………………………………………………. 1
1.3 Personal Aims……………………………………………………………. 1
1.4 Objectives…………………………….…………………………………… 2
1.5 Minimum requirements…………………………………………….……… 2
1.6 Additional Requirements………………………………………………… 2
2 Project management and Methodologies………………………………. 3
2.1 Introduction………………………………………………………………. 3
2.2 Milestones………………………………………………………………… 3
2.3 Revisions to schedule……………………………………………………… 4
2.4 Concurrent activities….……………………………………………….…. 4
2.5 System design methodologies…………………………………………….. 5
2.5.1 Introduction………………………………………………………………. 5
2.5.2 Why are methodologies used?…………………………………………… 5
2.6 Types of methodologies………………………………………………….. 5
2.6.1 SDLC…………………………………………………………………….. 6
2.7 Structured methodologies.……………………………………………….. 6
2.7.1 SSADM…………………………………………………………………… 6
2.8 Conclusion……………………………………………………………….. 7
3 Background ……………………………….…………………………….. 8
3.1 Introduction………………………………………………………..……… 8
3.2 Databases and database management systems (DBMS)…………….…… 8
3.2.1 Microsoft Access……………………………………………………….… 9
3.2.2 Oracle………………………………………..…………………………… 9
Analysis and design of an information system for the BSAC
IV
3.2.3 SQL Server………………………………………………………………. 9
3.2.4 Conclusion……………………………………………………………….. 9
3.3 Server side scripting……………………………………………………… 10
3.3.1 CGI script………………………………………………………………… 10
3.3.2 Active server pages (ASP)……………………………………………….. 10
3.3.3 Java server pages…………………………………………………………. 11
3.3.4 Comparison of ASP, CGI and JSP ………………………………………. 11
3.3.5 Conclusion……………………………………………………………….. 11
3.4 Client side scripting……………………………………………………… 11
3.4.1 Java script………………………………………………………………… 11
3.4.2 VB script…………………………………………………………………. 12
3.5 Web development tools…………………………………………………… 12
3.5.1 HTML……………………………………………………………………. 12
3.5.2 DHTML………………………………………………………………….. 12
3.5.3 FrontPage………………………………………………………………… 12
3.5.4 DreamWeaver……………………………………………………………. 13
3.5.5 Conclusion……………………………………………………………….. 13
3.6 RAD……………………………………………………………………… 13
3.6.1 Virtual InterDev………………………………………………………….. 14
3.6.2 Conclusion……………………………………………………………….. 14
3.7 UML……………………………………………………………………… 14
4 Analysis 15
4.1 Introduction………………………………………………………………. 15
4.2 Analysis Technique………………………………………………………. 15
4.3 Additional analysis techniques…………………………………………… 15
4.3.1 Consultations……………………………………………………………. 15
4.3.2 Initial meeting with leader……………………………………………….. 15
4.3.3 Summary…………………………………………………………………. 16
4.3.4 Initial meeting with instructor……………………………………………. 16
4.3.5 Documentation…………………………………………………………… 17
4.3.6 Experience/observation…………………………………………………… 17
4.3.7 Investigating other sources……………………………………………….. 18
4.3.8 Functional requirements………………………………………………….. 19
4.3.9 Non-functional requirements…………………………………………….. 20
Analysis and design of an information system for the BSAC
V
5 Design 21
5.1 Conceptual design and ER modelling……………………………………. 21
5.2 Entities and attributes…………………………………………………….. 21
5.3 Relationships……………………………………………………………… 22
5.4 The logical design………………………………………………………… 22
5.5 Primary keys……………………………………………………………… 22
5.6 Foreign keys……………………………………………………………… 23
5.7 Composite keys…………………………………………………………… 23
5.8 Update anomalies…………………………………………………………. 23
5.8.1 Update/insert anomalies………………………………………………….. 23
5.8.2 Delete anomalies…………………………………………………………. 23
5.9 Normalisation…………………………………………………………….. 23
5.9.2 1NF……………………………………………………………………….. 24
5.9.3 2NF……………………………………………………………………….. 25
5.9.4 3NF……………………………………………………………………….. 26
5.9.5 ER Diagram………………………………………………………………. 27
5.9.6 Integrity constraints………………………………………………………. 27
5.9.7 Interface design…………………………………………………………… 28
5.9.8 Interface guidelines………………………………………………………. 28
5.9.10 Frames……………………………………………………………………. 29
5.9.11 Navigation………………………………………………………………… 30
5.9.12 Architecture………………………………………………………………. 30
6 Implementation 32
6.1 Implementing the database…………………………………………….… 32
6.1.1 Relationships……………………………………………………………… 33
6.1.2 Data Integrity…………………………………………………………….. 33
6.1.3 Connectivity……………………………………………………………… 34
6.2 Updating the database…………………………………………………… 35
6.2.1 Adding new records……………………………………………………… 35
6.2.2 Deleting a record…………………………………………………………. 37
6.3 Indexing………………………………………………………………….. 38
6.3.1 FREETEXTTABLE and CONTAINSTABLE…………………………… 38
6.3.2 Searching for an excursion……………………………………………….. 38
6.4 Message board……………………………………………………………. 39
Analysis and design of an information system for the BSAC
VI
7 Testing 41
7.1 Prototype…………………………………………………………………. 41
7.2 Testing……………………………………………………………………. 41
7.3 White box testing………………………………………………………… 41
7.3.1 Testing the database……………………………………………………… 41
7.4 Inserting a new record……………………………………………………. 42
7.5 Deleting a record…………………………………………………………. 42
7.6 Testing the search………………………………………………………… 43
7.7 Testing the message board……………………………………………….. 44
7.8 Browser testing…………………………………………………………… 44
7.8 User testing (acceptance testing) 44
8 Evaluation……………………………………………………………….. 47
8.1 Introduction………………………………………………………………. 47
8.2 Were minimum requirements achieved………………………………….. 47
8.3 Were the project objectives achieved…………………………………….. 49
8.4 Evaluation against non-functional requirements…………………………. 49
8.5 Comparison of existing systems…………………………………………. 50
8.6 Achieving personal aims…………………………………………………. 51
8.7 Further enhancements……………………………………………………. 51
8.8 Summary…………………………………………………………………. 52
Bibliography 53
Appendix…………………………………………………………………
A Reflection on project experience…………………………………………. 55
B Gantt chart………………………………………………………………… 56
C UML Diagrams….……………………………………………………….. 57
D Screenshots of other BSAC sites………………………………………… 60
E E-mail from BSAC……………………………………………………….. 63
F Data definition……………………………………………………………. 64
G Screen shots of system…………………………………………………… 66
H Code from implementation

GET COMPLETE MATERIAL

INQUIRES:

OUR SERVICES: