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


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.


(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.


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. 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.

  1. Home Office LTD company. Database

    formatted so only dates can be in those cells and K is formatted for currency, as it is the amount paid. This screenshot shows the sheet working with the auto filter, the links that click on to an email message already with clients email address and the macro button that directs the user back to the main menu.

  2. Designing a booking system for an Estate Agent.

    with which negotiator and the address of properties that they will be viewing on that day. 1.4 A business case (reasons) for change. The problem is that the company's visit booking system is paper based. There are many problems with this as this doesn't prevent double booking.

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

    He has a Microsoft Office 2003 professional suite that includes Microsoft Word, Access, Excel, Publisher and PowerPoint. He is very keen to have a solution implemented, which makes use of the applications within Microsoft Office. His initial ideas were centred on the use of Excel and Word, with which he

  2. Video World Database as ICT project.

    There will also be a button to re-enter the Main Menu. Menu Design The menu structure will be based upon the following plan Menu Design Explanation Button Effect Effect on Original form Main Menu Editing Opens "Editing" Menu Remains Open Reports Opens "Reports" Menu Remains Open Rentals Opens "Rentals" Menu

  1. ICT Security Report

    The site being bombarded with people logging on to the site can initiate a system crash, because the company's server is unable to deal with the amount of people logging on at the same time. This could lead to a company or organisation losing all the data that would have been saved on the organisation's server.

  2. A relative of mine works for a corporate firm on CRM (Customer Relationship Management) ...

    Jill Dyche (2002) agrees that treating customers like cattle is the antithesis of CRM and the main goal should be to "recognize and treat each customer as an individual" (p.7). This means that if one customer is dissatisfied, he will give a negative feedback to other customers.

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