• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16

A dating agency situated at: 105 Bond street London WC1 - Creating an IT system.

Extracts from this document...


Identify Problem-The Scenario: A dating agency situated at: 105 Bond street London WC1. The Love Connection dating agency functions to bring two individuals with common interests, values and aspirations together to form a relationship. A client phones or writes or emails or faxes to obtain a questionnaire form, this form is sent to the client. The form is completed by the client and sent back to the agency. Once the form is received, the information is taken from the form and placed in various card files, which are arranged in sections of: Personal details, features, occupation, hobbies and interests. Currently the company are experiencing the following problems: 1. The company is very short staffed and it takes them a long time to match clients up. 2. The love Connection Administrators go through all the different files one by one this process is very long and painstaking. 3. The clients mistakenly sometimes get the wrong match because the facts get mixed up, I.e.: wrong hobbies, wrong features and interests. 4. The clients mistakenly get matched up with the same gender. 5. Staffs are over worked and are forced to do overtime, this in effect imposes extra costs on the Company. ...read more.


To put it on there profiles on the computer directly. CD Writer HP CD writer 9150i4x8x32 EIDE Internal I will use the CD writer as a backup in case I loose or misplace my original CD. Flatbed scanner Umax astra 2100u colour scanner I will use the scanner to scan pictures of the clients. The following has been identified as the software: SOFTWARE Why Am I Going To Use It? Microsoft Access I am going to use Access instead of excel because its easier for me because it already has everything set up for you. It has a wizard so that you can follow it step-by-step Microsoft word I am going to use Microsoft word to write my questionnaire and the rest of my project. Data Collection The following methods would be used to collect information from the Love Connection Dating Agency: 1. Interview: It would be appropriate to interview the receptionists and administrators to find out how information flows within the system, Hence series of interviews were conducted on a face to face basis with the staffs. The following below is a sample of questions asked: * How does a client apply to your agency? ...read more.


NUMBER 11 NUMBERS HAIR-COLOUR TEXT 6 BLACK, RED, BLONDE & BROWN EYE-COLOUR TEXT 6 BROWN GREEN BLUE GREY GENDER TEXT 6 MALE/FEMALE RACE TEXT 17 WHITE, BLACK OR ASIAN BUILD TEXT 7 SMALL, MEDIUM, LARGE HEIGHT NUMBER 5 NUMBER STAR-SIGN TEXT 20 THE STAR SIGNS OCCUPATION TEXT 25 OCCUPATION HOBBIES TEXT 15 DANCE/SING WEIGHT NUMBER 05 NUMBER ENQUIRY TABLE: FIELD FIELD TYPE FIELD SIZE DESCRIPTION MEMBERSHIP NUMBER AUTO 10 AUTO NUMBER LOOKING FOR.. TEXT 20 NAME AGE TO.. NUMBER 2 NUMBER ENQUIRY DATE TIME /DATE 8 _ _ /_ _ /_ _ AGE FROM NUMBER 2 NUMBER MATCH TABLE: FIELD FIELD TYPE FIELD SIZE DESCRIPTION MEMBERSHIP NO AUTO 10 AUTO NUMBER MATCH DATE TIME/DATE 8 _ _/_ _/_ _ MEMBER MATCHED TO TEXT 20 NAME OUTCOME TEXT 20 GOOD/BAD Test Plans Tests should be run To insure that: The clients are not mistakenly matched up with the wrong people. Test to meet client request: Step Action description Action Test result Expected result Pass/fail 1. Enter clients enquiry Clients enquiry entered and saved 2. Run query based on clients enquiry/request. Report is produced with match details 3. Cross-Check details of report, against clients request Report matches Accurately, to clients request. Information Systems GCSE Coursework Database Project Jennifer Orlukaraka Candidate number: 8097 Centre number: 10838 Project-Database ...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. 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

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

    * Do you train your employees? They receive mandatory training. * When do you backup? Don't usually have a backup strategy, would be a helpful feature. * When do you update the payslip? On a weekly basis. * What format would you like it to be given in?

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

    Currently task such as selected what dvds to send back isn't a reliable process as i use my own knowledge to choose dvds. I would like the system to automatically pick out the 25 least popular dvds in stock. I would also like to be able to print and display information on members, dvds and rentals.

  2. ICT Security Report

    They could also only use special delivery so that they are sure it goes to the correct address and the person specially signs that it whom it is to. EXTERNAL THREATS A business can also face many potential external threats that may try to retrieve or pilfer customer data.

  1. Everything about Digital Divide

    Also there is a Digital Divide Network, which was launched in 1999 and is since then trying to reduce this gap.

  2. Database Design

    I started adding in buttons linked to these forms. I did this by going to the design view of my main menu, then creating a command button on it. When I did this, a window popped up like this I went to Form Operations from the categories section and from there I went to Open Form.

  1. Home Office LTD company. Database

    Other functions which are on this sheet is that it includes an auto filter which allows the headings to be sorted into a custom way and also the user can pick one client from it and only there details appear.

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

    By the time the company was ready to train the application to all internal and external users, approximately 50 percent of the users said they already knew little about the initiative, and they are not willing to participate in the initiative, and declined the training for initiative.

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