• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 1768

In the design I will be trying to take the end user's specification and produced a workable database solution on paper. I have to make sure that a relatively competent 3rd party should be able to implement my ideas from only the paperwork.

Extracts from this document...

Introduction

Design In the design I will be trying to take the end user's specification and produced a workable database solution on paper. I have to make sure that a relatively competent 3rd party should be able to implement my ideas from only the paperwork. 1. 1.1 Comparison of alternative solutions Applications 1.2 Justification for chosen solution I have chosen Access as one of my software applications to implement the database because it includes many very user-friendly tools, which I will be able to use to complete my tasks. Access has also many advantages to it, as shown below: - * Support for very large databases * Automatic optimization of searching (when possible) * Has a simple view of the database that conforms to mush of the data used in business * Standard Query language (sql) * Allows us to collect data in relatively simple tables, keeping organizational tasks simple * We can match data from on table to corresponding data in another table by using a linking mechanism called a relational join * Match primary key in one table to a foreign key in a second table Advantages of Solutions * One advantage of these solutions is that with the Standard query language there is able to be a higher reliability on the different types of search queries that the user implicates. ...read more.

Middle

Year to show in which the album was produced Like "????" Please only enter 4 digits Genre Text (20) To show what type of music each band falls into Only select from the list of genres Cost Price per unit Currency Number to show how much the CDs are Picture OLE object Picture to show the album cover Quantity of product in stock Number (2) Number to show how many products are in stock Like "??" P lease enter 2 valid digits for the appropriate number of items in stock TblOrders Field Name Data Type and length Description Validation rule and Text Order ID Number A unique number to show the order number no validation rules for this table Order Date Date/Time Date to show when the item had been ordered Value Currency Number to show the cost of the product Confirmed Yes/No Yes/No box to show whether order has been sent Input Forms - backgrounds The use of forms is very important as it allows many user-friendly solutions within the actual system when the customer or employee is using it. Forms are useful in a database as it can create a data-entry form to enter data into a table. Also it can enable the user to create a custom dialog box to accept user input and then carry out an action. ...read more.

Conclusion

Functional testing is going to be where each menu item will be tested in turn to make sure that none of the functions have been missed out. The next type of testing that I will be carrying out is going to be systems testing. This is when the system is finished; all of the range of tests will be carried again to ensure that no other errors have been entered. Recovery testing will also be used in the database. The computer will be restarted while the database is open to ensure the data is not lost or corrupted incase there is a power failure. The last type of testing that will be carried throughout the system is acceptance testing. The user will be asked to test the capabilities of the system to make sure that all of the required functions are present and working as expected. Test Plan Test No. Test Data Expected Result 1 Incorrect Password "ABC" Password Rejected 2 Test Main menu - Customers Form Customers Form opens 3 Input new customer Customer ID should automatically be shown and customer should be added. 4 Test Main menu - CD details frm CD frm should open 5 Edit Cd frm - test to see if able to save changes Change should be shown and made correctly to the form 6 7 8 9 10 11 12 13 14 15 16 27 18 19 20 21 22 23 24 25 26 27 28 Design 1 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

  1. Marked by a teacher

    Planning- design a memo, letter and webpage for Capital FM.

    4 star(s)

    * The homepage must have the same house style as the other documents * This will be a lot quicker and simpler as you just use the one document to open all the other related documents. Alternative Possible Solutions A non ICT solution for the letter is that you could

  2. ICT PROJECT

    Sheets("Marks No").Select Sheets("Front End Menu").Select Range("A1").Select End Sub Pivot B The pivot table pivots the data held in the archive to provide the average mark of each student. When the user selects to go to either of the reports the pivot is refreshed.

  1. I will design a new video database for the video shop that will also ...

    As all the data will be stored on one system rather than a manual book system there will be minimal loss of data if any. Any of the staff could use the system, as it will be easy to use and have simple controls.

  2. Database Design Guideline

    Then I would have to click on this icon which is located on the toolbars, after that a table will show saying doctors table on one line and the line below says the patients table.

  1. Database design.

    They keep records on file paper since the burglary. They find this system untidy and want the shop to become paperless. Only the two employees use the system. There is always lose of records but fortunately they are records from months gone by. They don't keep records and have not got a filling system.

  2. Database Analysis and Database Design Project - DVD library for moving images.

    FROM RATING TABLE PRODUCER COMPANY TEXT (25) COPIES NUMBER OF COPIES NUMBER LOANS TABLE ENTITY NAME ATTRIBUTE NAME ATTRIBUTE DESCRIPTION FIELD SIZE DEFAULT MODE CONSTRAINS LOANS LOAN_ID UNIQUE LOAN IDENTIFIER AUTONUMBER (LONG INTEGER) PRIMARY KEY (P.K) MEMBER_ID UNIQUE MEMBER IDENTIFIER NUMBER (LONG INTEGER) FOREING KEY (F.K) FROM MEMBER TABLE DVD_ID UNIQUE DVD IDENTIFIER NUMBER (LONG INTEGER)

  1. Database & design.

    The software will notice when you type another letter in that field and will remind you what you ought to be typing. 3.4 Spelling check ( All spellings should be corrected automatically, which will allow my friend to find all video and members' information more easily.

  2. Design specification for an IT system for Harry's Dog Kennel business.

    less than 11 digits typed in , an error message should pop up asking the user to change the data in the cell as it is invalid 4 Data Validation used appropriately There should be spell check on certain cells such as where the extra services are stated but no

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