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

    By doing so, a window popped up like this From here I could choose any command for the button I want. For example if I wanted to find a record, I would click on the Record Navigation category, then from the actions section I would click on Find Record.

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

    to be paid The Shopping_Basket table below will record the images selected for purchasing. Shopping_Basket UserID INT - ID - UserID (of type group) The user that the image has been submitted too ImageID INT - ID - ImageID This is the ImageID of the image stored in ImageData The

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

    How to do a complex search- Once in the database click on search, then type in a number of things you want to search for. How to do a simple sort- Once in the database click on a field then click the sort 'descending' or 'ascending' button.

  2. An analytical report to discuss the HEG Infoway project, its implementation and the reasons ...

    Three key dimensions that influence the level of project risks are Project size, project structure, and Experience with technology. 4) Management of the implementation process: the development of a new system must be carefully managed and orchestrated.

  1. Designing a booking system for an Estate Agent.

    Regardless of the job title everyone has the duty of carrying out bookings for clients and taking the clients for property viewings. All of the employees within the company are technical users. All of them will be technical users of the proposed system as I asked in the interview the jobs that the employees are responsible of.

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

    and deducting any taxes applicable (18% if under 18, 25% if 18 and over and 20% if over 60, national insurance contribution which is 7% of the gross pay). At the moment the current payroll system is done by hand.

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