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

Creating a new system for 'The mix n match dating agency'.

Extracts from this document...

Introduction

Identify Background Detail and Identifying the User * 'The mix n match dating agency' has been running for twenty years now. Mike Kinley started it back in 1982 with an aim to bring people together. The agency has been passed down in the family, and now with manager, Peter Kinley is one of the biggest dating agencies in London. The main focus of the company is confidentiality and their people matching skills. Statement of the Problem * The current problem is the office is not very big, and it is in a total mess, papers and files lying around everywhere, when people want to look up on their members the information is very hard to obtain. Their Manager, Peter Kinley is finding very difficult to organise the dates for his customers because all the information of the customers are held in a few filing cabinets which are not organised and there is no way of finding the different members other than looking through every single file. There have been a few problems, where their members have been matched up with the same sex due to names like 'Jamie', which could be both male and female. The problem has arisen, because they do not have a suitable data system, everyone has their own way of doing things and their company is at state. ...read more.

Middle

(Address's from the filing cabinet) 2) Male members - forms sent out and data inputted using a keyboard. (Address's from the filing cabinet) 3) Details of previous dates - from the filing cabinet, data inputted using a keyboard. 4) Details of dates to come - from the filing cabinet, data inputted using a keyboard. 5) Must also check for any other useful data in the filing cabinet, data inputted using a keyboard. There will be some processes carried out on the data, validation and verification checks on the field design, and on the queries in the database. Flow Diagram's * A flow diagram and data flow are attached showing the process of making the database and the flow of data through the database. Data Manipulation * The tables required in the system will be Men, Women and Dates. The individual fields in each table will be as follows: Men (Surname, FirstName, DOB, Age, Address, Interests, Hates, PerfectMate) Women (Surname, FirstName, DOB, Age, Address, Interests, Hates, PerfectMate) Dates (Woman, Man, When, Where, Successful) * The computer makes queries about the similar interests, similar address's, similar ages, similar hates and matching perfect mates, this way the date should be a success. Three reports need to be produced. To produce the report for the woman, a query will be run to combine data from the three tables. ...read more.

Conclusion

2) The field for address should be changed into a few different fields instead of just one field, such as Address 1 (and maybe 2), town, and postcode. This will make it easier for the staff and customers to fill in forms, tables and search the database. 3) There should be more than one phone number in the table, as the customers may be out and need to get hold of them so a mobile umber field should be used. 4) There should not be a perfect mate field in the women/men's table, as most of our customers don't know that is why they have joined a dating agency. 5) There should not be a successful box on the date's table, as the reports are printed off for the customers so there is no need for it on the screen. 6) The DOB of the customers is not needed, an age field is enough on the tables, and we are trying to have as little fields as possible you see, so it doesn't take up memory space. 7) The menu, report and form designs are all very good, straight forward and correct, so they do not need to be changed, 8) Maybe a bit of colour on the paper when you design the forms that are sent out to the customers for them to fill in their details. 1 ...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. Analysis of market, environmental forces, competitors, marketing mix and consumer implementation.

    Hardware manufacturers design and build the actual machines these games will be executed on, but which will not sell without good games to promote them. This scheme of sharing the work can be likened to the music industry, where musicians create the songs (as some sort of software), while the electronics companies build the equipment (or hardware)

  2. Designing a booking system for an Estate Agent.

    Also another problem with having a paper based booking system is that it is vulnerable to damage e.g. spilled coffee. Several diaries would also be needed to be kept because each diary would run out of space. This will take up space and it will be difficult to look up

  1. ICT coursework: Designing and implementing a book rental system

    Well if I use a database package I think it will be better because databases allow you to in store a lot of information and it can do it very quickly. I have got an opinion of Stratford library and they have agreed what I think.

  2. Database Design

    This is what comes up when I click Next It gives me the option of choosing between giving the button a picture or a name. Once I have selected it, I click Next and it takes me to the next window asking me to give the button a name I named it 'Find Record' then clicked on Finish.

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

    Archive table below will record details of past transactions, such as who bought what and how much they paid. Archive ImageID INT - ID - ImageID This is the ImageID of the image stored in ImageData UserID INT - ID - UserID (of type group)

  2. Planning a payroll system for a martial arts school.

    * The calculations will be done immediately (gross pay, net pay, deduction of taxes...) 5. Investigation * Who is the client? Owner of the business, Winston Newton. * How many users are there? 4 * Who are the users? 2 data input clerks, 1 Admin staff and 2 deputy manager.

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

    Add/Edit customers details in Company's Record 1: A new record was added and saved correctly to the tables as expected. Record 2: When erroneous data is entered (Postcode was missing 3 characters) the system validation rule showed the following message Record 3 When erroneous data is entered (a mobile number, four digits short)

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

    It is also not immediately obvious when a date is overdue because there is so much writing on the forms and so you cannot always single out an overdue DVD. Stock levels As JenJams receives new DVDs on a regular basis it is difficult to know the number of DVDs within the shop without counting each one by one.

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