• 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
  11. 11
    11
  12. 12
    12

Design an application which will give "Ken's Newsagent" a more efficient and reliable way to run his newspaper deliveries.

Extracts from this document...

Introduction

1. Identification of task and general specification "Ken's Newsagent" is located on the edge of a housing estate. It caters for the local needs by providing newspapers, magazines, stationary, plants and confectionary. It has a large clientele, some come into the shop for their newspapers, and others have them delivered. Up to now "Ken's Newsagent" has relied upon a hand written log book contain all the relevant information about newspaper deliveries. The size of the deliveries and the fact that Ken now employs a manager to help with the deliveries means that he now requires a more efficient way of recording this information. The deliveries are split into 5 rounds. Each round covers a particular part of the housing estate. Each house is recorded with the customers name and the newspaper(s) required including the days for each delivery. Some customers only have newspapers delivered on one or two days, some also require an evening newspaper. Customers also tell "Ken's Newsagent" when they will be on holiday so that the deliveries can stop. "Ken's Newsagent" works on a monthly invoice system, sent out with the deliveries on the 20th of each month. ...read more.

Middle

There was only 3 fail overall, I was expecting more than that. The fails are not major failures so I don't really need to go back and edit the database. Ill leave it and just say in the user guide that type in exactly. 7. Program Evaluation If I was to do this again I would build a user interface with home made buttons and background pictures. I could have made the tables better in the way that the work. For an example I could have made the address for the customer a drop down box and just have the roads that Ken will deliver to in the drop down box. And just improve on nearly every thing that I have done. For this is not a very good data base for this is the first time I have made one. But I think if I could make an update version of this data base, I would. 8. User Guide. Customer details table. 1. Type in the Title of the customer; only use these Mr, Mis, Mrs, Ms. 2. Type in the First Name of the customer; only use leters in low/high case. ...read more.

Conclusion

Click to start search Delivery Form 1. Display Delivery Number from table 2. Display Customer number from table 3. Display Paper number from table 4. display delivery date from table Paper Form 1. Display Paper name from table 2. Display Paper Number from table 3. Display Paper Relies date; D=Daily, W=Weekly, M=Monthly, Y=Yearly 4. Display paper Costs Query 1. Type in customer number 2. Type in the Title of the customer; only use these Mr, Mis, Mrs, Ms. 3. Type in the First Name of the customer; only use leters in low/high case. 4. Type in the Last Name of the customer; only use leters in low/high case. 5. Type in the Address/Hosue Name of the customer; in clude house number with the road name. 6. Type in the Road Name of the customer; only if you have put in the house name in the Address Line 1. 7. Type in the delivery date 8. Type in the paper name customer has delivered 9. Cost of delivery Invoice Go in to report and every think in the Query is made in to a invoice for you and you just have to press print in file, print. If you have any problems call me on 07952130031 and ill come and help you. Craig Linford 03/05/2007 I ...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 Management & Manipulation of Information 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 Management & Manipulation of Information essays

  1. Database Design

    The supplier's telephone number Country Text The country which the supplier is based in Customer Details Employee Details Order Details Product Details Supplier Information Shipper Information Customer ID Employee ID Customer ID Product ID Supplier ID Shipper ID Customer Name Employee name Order ID Product name Supplier name Shipper name

  2. The purpose of this document is to provide a design for an electronic payment ...

    A sequence diagram also consists of objects (rectangles) and messages (arrows). There are two types of sequence diagram these are 'Instance' and 'Generic'. Instance sequence diagrams omit all other possible instances for clarity, focusing on a specific use case, whereas Generic sequence diagrams show a higher level overview of the system including all use cases.

  1. I have been asked by a General Sports shop using a manual system to ...

    How to do a complex sort- Once in the database highlight a number of fields then click the sort 'descending' or 'ascending' button.

  2. Designing a booking system for an Estate Agent.

    Their main requirement is for me to develop a booking system that will replace their paper based booking system. This booking system should include the dates and times of visit and with which negotiator. My job is to meet these requirements for the client and suggest any more improvements that

  1. I was hired by Mr Davies to create a website for a newly built ...

    Duration How many Cost for Area covered Billboard advertising 1 week 1 �400 Local Leaflets delivered to houses (500) 1 week 1 �175 Very local Viral campaign in the local town 2 months 1 �450 Local Short radio slot 10 seconds 20 �600 County wide Short TV slot 5seconds 5

  2. Background and investigation for designing a database for a DVD rental shop.

    How long would you like the system to hold records before they are deleted? I would like the system to notify me of customer that have been inactive for 6 months and then give me the choice of deleting them.

  1. ICT Security Report

    Trojans are malicious software. These programs devised by professional hackers to detect activity on PC allowing the hacker to assume the user's identity. This is done because they carry codes that are not acknowledged for the purposed stated. Hackers are then able to run programs on the user's computer without them knowing.

  2. Datbase Project newsagent shop

    I am going to use the Computer and its systems because it is faster, easier to use and more accurate. Besides by using the storage system of the computer, that is, floppy, hard and removable disks and tapes, storage is safer, file are not easily lost or damage and it

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