• 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. ICT coursework: Designing and implementing a book rental system

    The Habib's books staffs have not got a lot of experience for computers so I think Access 2002 would be easier. Mr Dawson has up to � 999 to spend, which shows that he can afford it. One advantage is that Access 2002 should not take long to set up.

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

  1. Home Office LTD company. Database

    Furthermore the macro which transfers information from this sheet to the customer database, also the drop down table for card payments are all used in this sheet. Discount table The purpose of this sheet is so the vlookup function on the order form works, without the table the discount would need to be calculated manually.

  2. Designing a booking system for an Estate Agent.

    The diary that is used to keep the information could also be lost or misplaced which would cause hassle to the company as they wouldn't know which clients and properties are booked. The diary also doesn't contain a specific time table which as stated would not prevent double bookings.

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

    Interview Questions and answers 1. How many personnel are currently in your employ? We have three members of staff. Two work on a full time basis and one works part-time. 2. What details do you hold about your employees? As all employees are family members not much information is kept

  2. Uses of ICT in Varndean

    They use Sage Instant Accounts software, which is used for purchase and sales ledger, bank reconciliation, which lets the company know how much money they have in their bank account. It also does a pay roll, which pays the employees their wages.

  1. Video World Database as ICT project.

    Price (3 Nights) Combo box- �2.00, �2.50 or �3.00 Currency Staff Attribute name Comments Data type and length Validation StaffID AutoNumber Unique Primary Key Surname Text(50) Firstname Text(50) Address Text (50) Town Text (50) DOB Date Phone Number Text(10) Customer Attribute name Comments Data type and length Validation CustomerID Automatically

  2. ICT Security Report

    When a human error led the posting of the personal data of about 3,300 individuals charged with minor drug and alcohol offences to the city of Indianapolis's Website. The spreadsheet containing the names, Social Security numbers, and addresses of the individuals was accessible via the Website for at least 11 days.

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