Extracts from this document...

Introduction

CONTENT TABLE ANALYSIS 3 1.1 INTRODUCTION AND BACKGROUND INFORMATION 3 1.2 THE CURRENT SYSTEM & PROBLEMS WITH THE SYSTEM 3 1.3 QUESTIONNAIRE 10 1.4 OBJECTIVES OF THE NEW SYSTEM 10 1.5 DATAFLOW DIAGRAM OF CURRENT SYSTEM 11 1.6 INPUT REQUIREMENTS 12 1.7 STORAGE 12 1.8 PROCESS REQUIREMENTS 12 1.9 OUTPUT REQUIREMENTS 13 1.10 DATA DYNAMICS 13 1.11 SUB-TASKS 13 1.12 PERFORMANCE INDICATOR 13 1.13 HARDWARE & SOFTWARE REQUIREMENTS 14 1.14 SYSTEM OVERVIEW 15 1.15 USER'S SKILL LEVEL 15 1.16 PLAN OF PROJECT COMPLETION 15 1.17 CRITICAL PATH DIAGRAM 16 2 DESIGN 18 2.1 POSSIBLE SOLUTIONS 18 2.2 FINAL CHOICE OF SOFTWARE 18 2.3 DATA FLOW DIAGRAM OF PROPOSED SYSTEM 19 2.4 NORMALISATION 20 2.5 TABLE DESIGN 22 2.6 QUERY DESIGN 24 2.7 FORM DESIGN 26 2.8 REPORT DESIGN 27 2.9 MACRO DESIGN 27 2.10 SECURITY & BACK UP 27 2.11 GANTT CHART 28 2.12 TEST STRATEGY 28 2.13 TEST PLAN 29 3 IMPLEMENTATION 33 3.1 COMMENTARY ON IMPLEMENTATION AND IMPROVEMENTS 33 3.2 IMPLEMENTATION PLAN 34 4 TESTING 71 4.1 IMPROVED TEST PLAN 71 4.2 COMMENTARY ON TESTING 76 5 EVALUATION 90 5.1 LIMITATIONS 90 5.2 FUTURE ENHANCEMENTS 90 6 USER MANUAL 91 Analysis 1.1 Introduction and background information As part of my A2 ICT project I will be creating a database system for Mr Azizur Rahman, Mr Bilal Sheikh and Mr Iman Ahmed who are part of their own computer-upgrading business, called N.E.T (New Emerging Technology) computer upgrades. Mr Azizur Rahman will be my main source of contact; he will be supplying me with the relative information and documents. Using the information a prototype project and design will be revealed to Mr Rahman and using his feedback the final system will be developed. N.E.T computer upgrading business is relatively new, started about a year ago; it's a semi professional business with the workers being part-time students in university and college. In a recent interview with Mr Rahman equal partner and worker for N.E.T, he explained that they provide assistance to at least 4 customers a month. ...read more.

Middle

He also explained that for the delete button a warning window should appear so that customer detail is not accidentally deleted. Furthermore he explained that the reports weren't that informative or that professional, he explained that he wanted to use some of the reports as invoices, thus it should contain the customers address and total price etc. These improvements are pointed out in the implementation plan by the following symbol: Refer to that improvement by going to that particular Task. 3.2 Implementation plan To show step by step how Mr Rahmans system was made, I will divide each section into Tasks, for example Task 1, Task 2 etc. This would order the way in which I made the system and also make it more understandable. 1. Create a table to store Customer details. 2. Create a table to store Component details. 3. Create a table to store Current computer specification. 4. Create a table to store Components Needed. 5. Set up a relationship between the tables. 6. Set up a query to display only the Drives from the component list. 7. Set up a query to display only the Graphics Cards from the component list. 8. Set up a query to display only the Processors from the component list. 9. Set up a query to display only the RAM's from the component list. 10. Set up a query to display only the Hard Disks from the component list. 11. Set up a query to display only the Monitors from the component list. 12. Set up a query to display only the Motherboards from the component list. 13. Set up a query to display only Other Components from the component list. 14. Set up a query to work out the Total Cost of Components Chosen by the customer. 15. Set up a query which asks for Computer Code and displays all the components he/she has chosen. ...read more.

Conclusion

menu of all forms present in the database o Open Reports - Leads to the menu of all reports present in the database o Problem solutions - Leads to the menu with possible problem solutions o Exit system - Leads to the form confirming if you wish to Exit the system The Form menu contains the following macros: o Enter or Search Customer Details - Leads to the customer details form o Enter or Search Current Computer Specification - Leads to the current computer spec form o Enter Customer Requirements for Upgrade - Leads to the customer requirements form. o Add or Delete Component - Leads to the add or delete form o Back to Main Menu - Leads back to the Main menu Enter or Search Customer Details Click on this button when you wish to enter or search for a customer. When selected the following form will appear. > How to enter a new customer * First choose a Customer ID for the new customer then enter it where it asks. * Now enter the customer detail into the rows in relation to the headings of the rows. Note: Some of the rows allows only specific data to be entered, either a certain length or type, this is done so to minimise errors. The Report menu contains the following macros: o Component List Report - Leads to the Component List Report o All Components Ordered by Customers - Leads to the All Components Ordered by Customers report. o Back to Main Menu - Leads back to the Main menu The Problem Solutions menu contains the following macros: o Find Customer ID - Leads to the find customer ID form o Back to Main Menu - Leads back to the Main menu The Exit System menu contains the following macros: o Yes - Closes down the application automatically o No - Closes down the Exit system form and returns to the Main Menu. ?? ?? ?? ?? Database Project Analysis 1 Shelim Chowdhury ...read more.

This student written piece of work is one of many that can be found in our University Degree Software Engineering section.