A Stock Control System For A Record Shop

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

Project Objectives :
T he main objective of this project is to produce a stock control system for Vision Records; a dance music based record s tore situated in Telford, Shropshire. Cur rently, only a manual paper based s ys tem is in place, with a heavy burden placed on the memory of the manager when it comes to aspects such as  order ing of s tock and knowledge of s tock levels . T his project aims to solve this
problem through the following set of objectives :
· An as ses sment of the cur rent sys tem and bus ines s proces ses
· An as ses sment of the pos s ible project methodologies and tools for implementation of the s ys tem
· Generation of both minimal and non-minimal requirements for the s ys tem
· T o create a new fully tes ted s ys tem based on the requirements gathered which is widely accepted by the user What was achieved?
All of the above objectives were completed and a s ucces s ful sys tem was both implemented and ins talled in Vis ion Records . All minimum requirements were satis fied and s ubs tantially surpas sed. T he s ys tem provides a solution to the problem of manual s tock control at the company. I t takes deliver ies , makes sales , handles cus tomer reques ts , and manages supplier s and employees , as
well as producing a wide range of effective reports and a search facility. T es ting and evaluation have shown the system to be a success and fully accepted by the user .

I . T able of Content s
Chapter 1: I nt roduct ion 1
S ection 1.1 Company Profile 1
S ection 1.2 T he Cur rent S ys tem 1
S ection 1.2.1 S ys tem User s 1
S ection 1.2.2 I nputs , Proces ses , Outputs 2
S ection 1.3 Motives for New S ys tem 3
S ection 1.4 Previous attempts to solve problem 4
Chapter 2: P roject Management 6
S ection 2.1 Methodology 6
S ection 2.1.1 S ys tems Development Life Cycle 6
S ection 2.1.2 Rapid Application Development 6
S ection 2.2 Project S chedule 7
Chapter 3: Analysis 8
S ection 3.1 Requirements Analys is 8
S ection 3.1.1 S pecifics 8
S ection 3.2 User Requirements 8
S ection 3.3 Analys is of Development T ools 9
S ection 3.3.1 Operating S ys tem 10
S ection 3.3.2 T he Databas e Model 10
S ection 3.3.3 T he RDBMS 11
S ection 3.3.4 Networ king Architecture 12
S ection 3.3.5 Application Layer Services 13
S ection 3.4 Evaluating the Project 15
S ection 3.4.1 User Satis faction 15
S ection 3.4.2 S ys tem Requirements 15
S ection 3.4.3 Effectivenes s and Learnability 15
Chapter 4: Des ign 16
S ection 4.1 Entity Relationship Modelling 16
S ection 4.2 I ntegr ity Cons traints 18
S ection 4.3 Normalisation 18
S ection 4.4 I nter face Des ign 19
S ection 4.4.1 Des ign Cons iderations 20
S ection 4.4.2 Navigation Map 20
S ection 4.5 I nternet Connections 22
Chapter 5: Implementat ion 23
S ection 5.1 T able Implementation 23
S ection 5.2 Form Implementation 24
S ection 5.2.1 Common Proper ties 24
S ection 5.2.2 Menu Forms 25
S ection 5.2.3 S tock Management Forms 25
S ection 5.2.4 Adminis tration Forms 27
S ection 5.2.5 S ales Repor t Forms 29
S ection 5.3 Quer y Implementation 31
S ection 5.4 Repor t Implementation 33
S ection 5.5 Macr o Implementation 33
S ection 5.6 S tar t-up Options 34
S ection 5.7 S ecur ity I s sues 35
S ection 5.8 I nternet Connections 35
S ection 5.9 Phas e 2: Revised Requirements 36
S ection 5.9.1 T able Implementations 37
S ection 5.9.2 Relationships 37
S ection 5.9.3 Form Implementation 37
S ection 5.9.4 Quer y Implementation 38
S ection 5.9.5 Repor t Implementation 38
Chapter 6: T est ing 39
S ection 6.1 Unit T es ting 39
S ection 6.2 Validation T es ting 39
S ection 6.3 I ntegration T es ting 40
S ection 6.4 User Acceptance T es ting 40
S ection 6.5 S ummer y of Results 40
Chapter 7: Deployment 41
S ection 7.1 S oftwar e I ns tallation 41
S ection 7.2 I ns tallation T es ting 41
Chapter 8: Evaluat ion 42
S ection 8.1 Requirements Satis faction 42
S ection 8.2 User Satis faction 45
S ection 8.3 Effectivenes s and Learnability 45
S ection 8.4 Advantages over cur rent sys tem 46
S ection 8.5 Futur e Improvements to the s ys tem 46
S ection 8.6 Evaluation S ummery 47
B ibliography: 48
Appendix A: P er sonal R ef lect ion 50
Appendix B : Gant t Char t s 52
Appendix C: At t r ibut e P r oper t ies & Relat ionships 54
Appendix D: F or m Screenshot s 57
Appendix E : F inal Navigat ion Hierar chy 64
Appendix F : S ample R epor t s 65
Appendix G: AS P Connect ion S cr eenshot s 70
Appendix H: T es t Plans & Result s 71
Appendix I : L et t er f rom Vis ion R ecords 76
Appendix J: U ser Guide