• 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)

    Once you have finished writing the letter and recipients list all you have to do is insert a field e.g. "firstname" and if you press preview results you can see the name you typed in the list. You can change the person by clicking an arrow on the toolbar.

  2. ICT PROJECT

    McrAutoOpen Sub mcrautoclose() ' ' mcrautoclose Macro ' Macro recorded 23/01/2007 by 21bor2413j ' ' Removes toolbars and sheet tabs Range("H7").Select With ActiveWindow .DisplayGridlines = False .DisplayHeadings = False .DisplayOutline = False .DisplayZeros = False .DisplayWorkbookTabs = False End With With Application .DisplayFormulaBar = False .DisplayStatusBar = False End With Application.CommandBars("Standard").Visible = False

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

    teacher and had it lost and others who have sent their work directly to the teacher's e-mail address this is more efficient because that way you can be sure that it won't get lost. Evaluate School Needs I am able to use e-mail to meet my school needs very well.

  2. 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.

  1. 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.

  2. 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.

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

    DVDs: (DVD_ID, DVD_TITLE, DIRECTOR, CATEGORY_DESCRIPTION, RATING, PRODUCER) LOANS: (LOAN_ID, MEMBER_ID, DVD_ID, QUANTITY, PRICE, DATE_OUT, DATE_IN, DATE, SURCHARGE, DAYS_LATE, TOTAL) CATEGORY: (CATEGORY_DESCRIPTION) 2NF/3NF MEMBERS: (MEMBER_ID , TITLE, F_NAME, M_NAME, L_NAME, ADDRESS, COUNTY, POST_CODE CONTACT_#, DATE_JOINING, EXPIRED_DATE) DVDs: (DVD_ID, DVD_TITLE, DIRECTOR , CATEGORY_DESCRIPTION, RATING, PRODUCER) LOANS: (LOAN_ID, MEMBER_ID, DVD_ID, QUANTITY, PRICE, DATE_OUT, DATE_IN, SURCHARGE, DAYS_LATE, TOTAL)

  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