• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Analyse - Database

Extracts from this document...

Introduction

Analyse- Chosen Hardware: Below is a table of the hardware, which will be used when implementing the system. Both input and hardware devises have been considered. Input Devices Reason for Choice Keyboard By using this hardware I will be able to key in the relevant information concerning the member detail, method of payment and book details. This is a better option compared to the touch screen keypads as sometimes when you want to key in a certain letter it displays the wrong one, with a keyboard there will be less mistakes and the customer will be happier as it is less time consuming. Mouse By using a mouse it will be easier to navigate around the system. Furthermore the users can use the mouse effortlessly. The mouse compared to using the sensor mouse is better as you don't have to apply a certain amount of pressure for it operates. Output Devices Reason for Choice VDU; Monitor The VDU (visual display unit) has an important part, as this input device will be used the most. The VDU will display the relevant information to the user. Inkjet Printer An inkjet printer may be used to print off certain reports and queries in which the employees or Mr Browne want to analyse. Ink-jet printers offer black and white or colour printing with reduced levels of quality and speed. Colour ink jet printers are cheaper to buy than colour laser printers. Inappropriate Hardware: The table below illustrates the hardware that is not going to be used, as it is not needed. ...read more.

Middle

> User Requirements > Collect images of books from the internet to make the forms user friendly > Information about the queries Mr Browne wants to make Below is a diagram displaying the information that I will collect and where it will be displayed on the system. Data Manipulation: Tables Fields MEMBER Member ID, Member First Name, Member Surname, Address Line 1, Address Line 2, Address Line 3, Post Code, Telephone Number, DOB, Gender/Sex PAYMENT Payment ID, Payment Method, Date of Payment, Member ID, Book ID BOOK Book ID, Book Name, Book Price, Book Publisher, Book ISBN Number, Book Author, Publishing Year, Book Rating * Making a report: * The data will be entered into the tables. * Record will be made. * The tables will have a relationship. * Member ID Query will be made. * Make Query in design view. * Insert fields Member ID and Member Name. * Save * Run * The queries will then be put into a simple report. * The reports will be printed out. The tables will allow me to get appropriate information to make reports and forms, which will benefit the users. Computer Input and Verification Checks: As a majority of information will be entered into the system, it is crucial the information that is entered will be checked and verified to minimise mistakes. The information that will be entered will be in the tables and the details after the system is implemented. ...read more.

Conclusion

The inkjet printer is a better option compared to the laser printer, as it is cheaper to maintain, moreover the print cartridges are also cheaper. Mr Browne will be content with spending the little extra cost because it will be cheap and helpful. Furthermore, the touch screen VDU is not appropriate as there are many disadvantages with this device that are costly and inappropriate, therefore a normal VDU will be required as it is less expensive and Mr Browne has it already. Data Flow Diagram: Validation for Password Mr Browne wants to open up the database system. The system will ask for a password. Validation for data entry for Member table Verification for Password Verification to double check information Flowchart to update Surnames: Flow Diagram of the entered data: Below is a flow diagram of how the reports will be made. Backup Security: The system will need to be stored onto a CD-ROM, if the file is too big, this should be stored at a different location to the bookshop in case there is a fire, for example at Mr Browne's home. Furthermore, every time a new member joins the bookshop or details are being changed, the database should be saved to the hard drive. Therefore every week, a user must update the CD-ROM. This will keep the system up to date and organised. There should be a password on the computer therefore any unauthorised persons cannot access the system. Mr Browne and his employees should change the password every 6 weeks therefore this will minimise the risk of hackers. Coursework: Microsoft Access ...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 Software 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 Software essays

  1. What is a computer registry?

    Multi-String Value REG_MULTI_SZ A multiple string. Values that contain lists or multiple values in a form that people can read are generally this type. Entries are separated by spaces, commas, or other marks. String Value REG_SZ A fixed-length text string.

  2. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    the column was mostly green, or if the class needed more help and support e.g. the column was mostly reds and ambers. In order to add another condition/colour/range, you follow the steps above, but instead of clicking "Ok" once you have completed your first condition, you click "add" which brings up another condition which you fill in and re-format.

  1. bookings database

    Easy to input data-the arrival date is automatically generated (today's date). If you want to change this, all the user has to do is to delete it. The textboxes are empty so it is easily apparent that this is where the user enters data.

  2. Analyse appropriate hardware and software needed.

    * Not suitable for backing up data from other programs such as: Microsoft Excel, Word etc.

  1. Analyse appropriate hardware and software needed.

    Output The way that my PowerPoint will be presented is my clicking on buttons. This will be better then doing it automatically as then I can control when I want the slide to change. To show my PowerPoint presentation I will be using an interactive whiteboard so that it is big enough for everyone to see.

  2. Analyse appropriate hardware and software needed.

    Text Forms filled ad handed to the employees Inputted into the system by employees No validation Data Manipulation In the system Customer, Car and Sales tables are required.

  1. ICT BTEC UNIT 2 - REPORT

    this will ensure that you get as much as you can out of the packages you use. Another thing to remember is making sure that when your creating a video to be burnt on to disc you must remember what format it has to be and how much memory your

  2. Publisher. My fathers friends name is Mr. Hussaini, as his restaurant has just opened ...

    for the logo then I am going to edit the picture in paint application and use Microsoft word so as to add the required title for the logo, this title will also be edited using word art so as to make it look attractive.

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