• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  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...


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.


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.


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)

    This is very useful as you only need to click an arrow to change the information instead of changing the text by deleting the old one and typing a new one in. If you want to open a document and edit it but keep the original the same, you just

  2. task2-report-template 3

    lists of information on the screen: * Model * Brand * Processor Type * Memory Size * Memory Type * Hard Drive Capacity * New or old * Number of laptops in the stock * Colour * Speed of search The users need to be able to find out what

  1. Smarts Leisure Park Database Booking System

    It then came up with this screen: I need to move over every one of the fields: I have called it "qeyCustomer": I then wanted to modify the design of the query, and so it came up with this screen.

  2. System requirements analysis

    They will just need to click onto the button and a quick description of what the page contains is also included. This makes the software more easy to use. New receptionists and doctors can easily learn how to function the software which will save time.

  1. Database Design Guideline

    This means that in my database I can only enter the colour red, blue, orange or green for the ward input so while filling my forms I will have to apply and stick with these rules as my database will not allow me to entry any other information apart from using does rules.

  2. mail merge

    a mouse to get to a file or a program I need to type up information also I will use a scanner to input data such as complaints or other information. For the storage I am going to use is a Maxtor 60GB Hard Drive and has got a Basic audio and video system.

  1. This report I will be writing, will be on the way I do activities ...

    the mobile phone starts to connect to it and will send a request to the other phone for my call to be accepted or rejected depending on the person. Also when I am going to and from school, doing homework, going out or any other reason, I am able to listen to music while I do the activity.

  2. Computer Studies Past paper definitions

    type, format, range, length, presence, control total, check digit [2] (d) polling testing a station/terminal/device in a multi-access system in a sequential order/in turn to establish whether it is holding data for transmission/collection to allow time sharing e.g. checking source of interrupt [2] (e)

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