• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  28. 28
    28
  29. 29
    29
  30. 30
    30
  31. 31
    31
  32. 32
    32
  33. 33
    33
  34. 34
    34
  35. 35
    35
  36. 36
    36
  37. 37
    37
  38. 38
    38
  39. 39
    39
  40. 40
    40
  41. 41
    41
  42. 42
    42
  43. 43
    43
  44. 44
    44
  45. 45
    45
  46. 46
    46
  47. 47
    47
  48. 48
    48
  49. 49
    49
  50. 50
    50
  51. 51
    51
  52. 52
    52
  53. 53
    53
  54. 54
    54
  55. 55
    55
  56. 56
    56
  57. 57
    57
  58. 58
    58
  59. 59
    59
  60. 60
    60
  61. 61
    61
  62. 62
    62
  63. 63
    63
  64. 64
    64
  65. 65
    65
  66. 66
    66
  67. 67
    67
  68. 68
    68
  69. 69
    69
  70. 70
    70
  71. 71
    71
  72. 72
    72
  73. 73
    73
  74. 74
    74
  75. 75
    75
  76. 76
    76
  77. 77
    77
  78. 78
    78
  79. 79
    79
  80. 80
    80
  81. 81
    81
  82. 82
    82
  83. 83
    83
  84. 84
    84
  85. 85
    85
  86. 86
    86
  87. 87
    87
  88. 88
    88
  89. 89
    89
  90. 90
    90
  91. 91
    91
  92. 92
    92
  93. 93
    93
  94. 94
    94

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

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.

The above preview is unformatted text

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

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related University Degree Software Engineering essays

  1. software program specification and code for a DVD store

    Cost of item VAT Const double Rate of VAT= 11.75 Option Char User choice of menu option Pseudo code welcome_screen Display text messages "Welcome to DVDSTOVIEW" "= = = = = = = = = = = = = = =" a blank line display_options Display text messages "We offer the following services" "D.

  2. Programming Concepts. Andora Video is a small shop selling videos. The owner, Raul, wishes ...

    If I do run out of time, then I shall implement single input dialog boxes in my program (see designs below). In the final version I intend on concluding the program with a output message box (see design below). VERSION 1 The first version shall not have a Graphic User Interface (GUI)

  1. Systems Development and Implementation

    The costs of modularity include * More effort and investment may be needed for a well modularized design * There is an overhead introduced with layering * There might be excessive capability due to standardization 4.1. Appropriation of value Layering is a specific architecture in which modules share a vertical relationship: Each layer is dependent on the layers below.

  2. MS Office solutions. Fantasy mobiles require: ...

    Output documents can also be automated through the use of reports. It is the ease of use that attracts many organisations to employ Microsoft Access in organising its various components. Microsoft Access however is considered too insecure for some organisations especially commercial, such as banks; more industry-strength database software (e.g.

  1. 3SFE504 - Object Oriented Programming - Linear and Independent Hash Table code

    { } LinHTable::~LinHTable() { } // calculating the hash value for the string word int HashVal(string str) { int n=0; char alp[]={'a','b','c','d','e','f','g','h','i','j','k','l','m' ,'n','o','p','q','r','s','t','u','v','w','x','y','z'}; for(int i=0; i<=str.length(); i++) { for(int ch=0; ch <=25 ; ch++) // calculate string ch between A-Z { if(str[i]==alp[ch])

  2. Rich Internet Applications

    Because of the advantages of RIA's industries are very keen to get hold and incorporate their company into the technology. 2.2 Current Stance in the technology RIAs are still in the early stages of development and user adoption. There are a number of restrictions and requirements that remain still when

  1. Critique: An Approach to Software Product Testing (CarlosMunoz) Submitted by: - Abhishek Das (2003002) ...

    The article suggests that structural approach to decide on testing may be accurate but the user is not always aware of the structure. Thus if he wants to know the degree of correctness of the program it will not be possible for him to interpret the structure.

  2. Evaluating Websites Usability - comparing 5 websites.

    When the ?E Magazine? link is pressed up come their ?WINTER EDITION 2003? newsletter. Findability: 1. URL is not very explanatory as with the word sixties in it makes the user think of something relating to that decade. 2.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work