database intro

Authors Avatar

Iram Ahmad                                                                                          Database Coursework

                                                                                                                               Yr 11g

ICT COURSEWORK

This coursework will include the following detail and steps that were used by me to implement this database. This will consist of five sections:

  • Identify: This will include the problem, which is a brief overview of why the company’s data should be looked up automatically, the users, the alternative solutions and the quantitative objectives.

  • Analyse: I will be explaining the hardware and software, the back up system and security of the database. I will also be showing the flow diagram of how the database I made.

  • Design: this will include the initial design, final design the user comments and the test plan, which is used to test the reliability of the coursework.

  • Implement: this will include the evidence of error correction, of testing and of the problem solutions which forms part of the design.

  • Evaluation: this will include the evaluations of the objectives, the user comments and the further improvements which can be made to enhance the database.  

Identify

Introduction:

Saqib video store is a medium size rental shop, which is located in Wimbledon, it’s been open since the year 1999 and has been a successful investment ever since. The opening of the video store was a huge success and attracted many people. The shop rents out numerous films of every genre at different price range etc. It consists of at least 5000 loaned videos, 50 members of staff at different job status and about 100 customers that have signed up to this video store.

Problem:

Mr Saqib Ahmad has many problems with his current system. The main problem is that it is manual, this increases the chance of human errors; too many records are made manually for each member. a loss of information occurs occasionally which creates time loss and more effort needed by the administrator. Also, the information that has been inputted by the user can be incorrect at times which results for the file to be edited consistently. Records take a long time to search and making copies of it consumes a lot of time and having back ups is vital. Mr Ahmad has asked me to come up with a solution that can improve his system.

Join now!

Alternative Solution One:

The first solution I thought of was to improve Mr. Ahmads manual system. I could input his data in a filing cabinet in alphabetical order. I could also color co-ordinate different sections, like the addresses of members, the books that have been loaned, the date they’ve been loaned and the date it’s due back. This is a cheap but time consuming method.

Alternative Solution Two:

the second solution that is possible to solve this problem is to use word processing as  a software to record your data. A computer system will be needed to ...

This is a preview of the whole essay