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

    This key is sometimes abbreviated as "HKCR." Starting with Windows 2000, this information is stored under both the HKEY_LOCAL_MACHINE and HKEY_CURRENT_USER keys. The HKEY_LOCAL_MACHINE\Software\Classes key contains default settings that can apply to all users on the local computer. The HKEY_CURRENT_USER\Software\Classes key contains settings that override the default settings and apply only to the interactive user.

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

    I then clicked on one of the cells I wanted in the formula, inserted an addition sign and clicked on the cell I wanted to add to it, and pressed enter; this then added the two cells together, and displayed the result in the high-lighted cell.

  1. bookings database

    An improvement I would make here would be to increase the font of the Guestnumber so the user can easily see the Guestnumber. Other than this, there are no improvements I would make to improve the effectiveness of the database.

  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.

    This will be an advantage so that everyone can see it. I would not use to many colours or to many pictures as this will distract the pupils, only the main information must be able to get across to the pupils.

  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

    When using these programs there are certain things that you must remember for example each of them will require a lot of patients. This could be seen as a disadvantage or a bad thing however some times taking a lot of time can result in a great finished product and

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

    There I am going to create a new sheet by taking brouchers then menu as my option and here I will automatically have 2 sheets with 3 sides each. 2. To surf the net and collect Pictures and see samples of logos, I will directly go on the net and

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