• 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. An analytical report to discuss the HEG Infoway project, its implementation and the reasons ...

    It was good project to do, and the fact that they tried to do that in the latest technology made it even more interesting. But the whole idea of it was wrong. As BIL decided to do that just to give favour to its group company.

  1. Designing a booking system for an Estate Agent.

    A double booking is likely to occur as the diary doesn't have a clear layout and a timetable. The diary does contain tables but this only sorts to date where they write information of the appointment. Writing information would be time consuming compared to if they were to use a computer system.

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

    It is called `Making Your Name` (MYN). The company organises advertising campaigns for client. The process: 1. The company contacts MYN and request a proposal for an advertising campaign, giving an indication of their budget, a duration, the area the company wants to cover and a summary of their previous experience of advertising.

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

    Do you store information about your customers? If so, how and what is it stored in? Yes we do. When a member form is filled we obtain information on the customer's name, age, contact details and address. 7. Do the customers have unique customer identification numbers?

  2. ICT Security Report

    Then he logged on numerous times over a period of weeks and transferred approximately $3.7 million through wire transfers to various accounts his group controlled in the United States, Finland, the Netherlands, Germany, and Israel. Levin and his accomplices can be again as malicious hackers but this time as those

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