DESIGN. 17

Computer Science A2 Project

Title of Project Softmaster 1C: Franchaising

Student of the 12^th grade: Nurarys Zhumay

Local Teachers: Serik Tokayevich

International Teacher: Faizal Bhula

Contents

Definition.......................................................................................................................... 4

1.1 Organisation Information......................................................................................... 4

1.2 Client Information................................................................................................... 4

1.3 Background to/identification of the Problem........................................................... 4

1.4 Description of the current system............................................................................. 4

1.5 Data source(s) and destination(s)............................................................................. 5

1.6 Data volumes............................................................................................................ 5

2.0 Investigation & Analysis................................................................................................. 6

2.1 Interview client......................................................................................................... 6

2.2 Identification of user needs..................................................................................... 7

2.3 Data Flow Diagrams of the current system.............................................................. 8

2.4 Entity Relationship Diagrams of current system...................................................... 9

2.5 Objectives of the new system................................................................................... 9

2.6 Analysis of Website Creation Software, Programming languages and Database.. 10

2.7 Potential Solutions.................................................................................................. 13

2.8 Requirements Specification Chosen Solution........................................................ 14

2.9 Chosen Solution Software/Hardware Requirements.............................................. 15

DESIGN.......................................................................................................................... 17

3.1 Objectives & Feedback.......................................................................................... 17

3.2 Site Hierarchy/Map................................................................................................ 18

3.3 Page Functions....................................................................................................... 18

3.4 Interface/Wireframe............................................................................................... 23

3.5 DFD (for new system)............................................................................................ 24

3.6 ERD (and explanation)........................................................................................... 24

3.7 SQL Statements...................................................................................................... 25

3.8 Data Dictionary...................................................................................................... 27

3.9 UNF & 3NF Database Tables (with example data)............................................... 28

3.10 Intended Benefits................................................................................................. 29

3.11 Limits of the scope of the Solution...................................................................... 29

3.12 An estimate of the size of the files....................................................................... 30

3.13 Client Feedback.................................................................................................... 31

4.0 Development & Programming...................................................................................... 33

4.1 List of files............................................................................................................. 33

4.2 Database Structure.................................................................................................. 35

4.3 SQL Queries code including input and output data............................................... 37

4.4 List of variables, arrays and fields......................................................................... 37

4.5 Programming (5.1 & 5.2)....................................................................................... 40

4.6 Client Feedback.................................................................................................... 111

Дата добавления: 2015-08-18