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

A small newsagent named 'Shah News' has decided to diversify, and begun to rent digital media to the public. It began as a small experiment, to see if it would work out in his current local area.

Extracts from this document...

Introduction

Analysis Identification of Problem A small newsagent named 'Shah News' has decided to diversify, and begun to rent digital media to the public. It began as a small experiment, to see if it would work out in his current local area. To his advantage, it has become very popular because of two main reasons; because his newsagent is situated on a main road with most property being residential, and the fact that he has a highly respected reputation with the local area (mainly because of his competitive pricing of groceries, confectionary and cosmetics). He has already built a sizeable customer database, and currently he is just using a larger alternative to a notebook to store information on members and his media. He is already expending his media collection, as his member base gets larger too. He has discovered that it is possible to store information in database format on a computer, from seeing such set-up's in similar rental stores e.g. Video Box and Red Rose (incidentally, there is a Video Box branch 15 minutes walk down his main road, and a Red Rose branch another 10 minutes walk further on). He has a computer system at home, however seeing the low prices of such computers adequate for the job, he is confident to buy a new computer system purely for his computerised database. ...read more.

Middle

As an integral task, that particular media ID is deleted from the database of media available for rent. When the rental period is over and the media is returned, the ID is unassigned from the member's account, and also is put back onto the list of available media for rent. The system has to be able to accomplish tasks such as: > The ability to add new members to the user database. > The ability to view/edit/delete member details with ease. All members will have a unique ID, although it'll be impractical to have members remember their ID. Therefore, maybe a membership card system should be implemented. This can truly authenticate a member from a non-member as an added advantage to the company. > The ability to add new media to the database, and assign to it a unique ID. > The ability to create rentals by assigning media ID's to member accounts. Also, the attached ability to mark that media ID as 'rented out'. > The ability to delete rentals from a member account. Also, the attached ability to mark the media ID as 'available for rent'. > The ability to view available/rented media in summarised form, and also to delete media that is not available for rental anymore. ...read more.

Conclusion

Also, these backups will most likely be compatible in other database applications (making consideration for upgrading the database application in the future). Disadvantages * The system can take more memory (hard disk space, as well as RAM), as the database application has high demands for these memories. * The application might not be as precise to the specification as it could have been with the programming approach. * Although the branches will have a PC and peripherals, database applications are demanding on RAM and hard drive space, therefore it is possible that the PC's will require upgrading if the specification isn't up to the job. Thus meaning, more cost for the company. * The company will have to buy a version of a database program for every PC. This could be expensive, because as well as paying for the bespoke database, they have to pay for the program that runs it. Justification of Chosen Solution It seems clear that the manual system is out of the question. Too many disadvantages eliminate this possibility. A fully digital system has many more advantages and possibilities. The second issue, is of how the system will be made; either through a database approach or a programming language approach. It appears that the Delphi approach and the database approach seem to be on the same level as each other, in terms of advantages and disadvantages. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science 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 AS and A Level Computer Science essays

  1. Video Rental System

    Long Int 1-99999999 Y PK, FK CUSTOMER ITEM_ID Item ID Number Long Int 1-99999999 Y PK RENTAL_DATE Item Rented date Date/Time dd/mm/yyyy hr:min:sec am/pm RENTAL_DUE_DATE Item rented Due date Date/Time dd/mm/yyyy hr:min:sec am/pm CUSTOMER_RENTAL_HISTORY CUS_ID Customer ID Number Long Int 1-99999999 Y PK,FK1 CUSTOMER ITEM_ID Item ID Number Long Int

  2. Infernowear is a new company run by a self-employed creative designer aiming to producing ...

    If not they are manually entered and payment is then taken via a credit or debit card. Then the completed order updates the stock level and the order is added to the order line. The order line is then printed along with the shipping labels and this is where the computer system ends.

  1. AS ICT Corsework - Mr Brookes K-Fit Ltd

    As you can see the website loads up perfectly in Google chrome and Mozilla Firefox without any problems what so ever. No Changes Necessary Appendices Appendix 1 - Interview (Interview with Mr Brookes) Ben Allington - Good morning Mr Brookes, I have come to speak to you today so that you could tell me about your situation with K-Fit Ltd.

  2. ICT Sample Work Welcome Centre Requirements

    If the event type is a full day, then double the price. Calculate and display the Total Equipment Costs by multiplying the Unit Equipment Cost by the Quantity required. o The Total Cost of all Equipment required forth booking. o Beverage Costs Per Delegate o Total Beverage Costs o Food

  1. ICT Sample Work India Red

    event because a receipt will not do the job as there are lot of things involved in this and receipt does not display all the details. The invoices are hand written again and this is time consuming. This also costs money because they have to pay another person to fill

  2. Purposes and Features of a Relational Database

    Linking the tables up in such a way that if the data needs to be changed, and is duplicated throughout the databases , when it is changed these changes are also applied It means that the database will conform to similar standards with that of other normalised databases, but also

  1. Evaluation of a computerised system

    record' button is clicked, then a new record is generated for that data that has been input. * Show the new staff table when a new staff member is added into the database The same applies to this as applies to customers.

  2. Basic Database Building

    FacilityUses Facility ID Facility ID Attributes: Not Enforced RelationshipType: One-To-Many MemberDetailsFacilities MemberDetails Facilities Member id Facility ID Attributes: Unique, Not Enforced RelationshipType: One-To-One Ricki Lambert 16 May 2008 Table: Facilities Page: 3 Table Indexes Name Number of Fields Member ID 1 Clustered: False DistinctCount: 1 Foreign: False IgnoreNulls: False Name:

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