• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 3285

Design a relation database for a company that is currently using a manual or a non-IT system.

Extracts from this document...


Introduction to coursework My name is Pritesh Pranay; the task I have been set for my 5th form coursework is to design a relation database for a company that is currently using a manual or a non-it system. I have chosen the Sunshine Health guesthouse, which is situated in Basildon, Essex. It was introduced last year. They have established their name in no time at all. They do face competition from holiday Inn and other senior guesthouses or hotels in the local area; it has 50 rooms in total (some single and double). It is considered to be a luxurious guesthouse in its area. However what makes it popular is that it is only 5km away from pizza hut, cinemas and other family recreations. Most of its customers come from surroundings area like Stanford-le-hope, Brentwood, Orsett, Billericay, and Grays etc. Majority of them come on behalf of their company for business meetings and conferences on weekdays, there fore all payments are done by their company credit card. On weekends there are more tourists and holiday seekers. I have identified the sunshine health guesthouse as a potential client for my database project. This is because as this hotel was opened last year, it is probably not too familiar with using a computerized system to operate its business. Therefore I will create a relational database to solve all their problems in managing their business. How ever I will be using different methods of research to identify their problem in further detail. Of course once I have understood their problem in great detail it would be easier for me solve it to a grater extent. Analysis Company Background Sunshine health Guesthouse is a guesthouse, which has 50 rooms. There are single and double rooms including en-suites. The rooms are of quite luxurious size designed to maximise user comfort. It is always booked however because it is located close to family recreations. ...read more.


misleading Advantages of Internet research are * Ease of accessibility since it can be used anywhere anytime * Very quick to find information * Reasonably cheap to use As you can see it is well-balanced option but the company I am basing my project upon doesn't own a website yet as it is completely relied upon a manual system of data storage. However there may be other background information about my company on the Internet, which could be useful to look up Another way I could collect data is by personal observations i.e. looking at the company's database but because it is a completely manual system that is out of option. After considering all the possible options of data collection I plan to use the interview because I feel it would be very easy to collect the information that way for me, the interview would be made friendly enough so there is no pressure on the user to respond in any certain way. This is a very quick and direct method of collecting information; all the information can be gained on the spot. However stating that I also plan to use another method of data collection i.e. questionnaire as well. This will help to gain the maximum information about the company, which could be really useful when deciding the user requirements. How am I going to administer the interview? Well I plan to call up the managing director of the company asking for an appointment. After I have booked the appointment I will prepare a list of questions I need to ask them in order to gain the information. However I do believe that the interview will be bound by time restrictions so all efforts would be made to make sure that I don't cross the time allocated. As I have said before the interview would carried out in a formal manner. A healthy atmosphere would be created to conduct the interview. ...read more.


* Select the type of Main Document you wish to create. * Click Get Data to select your Data Source. There are four methods you can use for your Data Source: * Open Data Source * Header Options * Select Edit Main Document. (Add all text that you want to appear with every record; and insert the appropriate merge fields using the Insert Merge Field button on the Mail Merge Toolbar) * You can preview your data prior to performing the merge by clicking the ViewMergedData button on the mail merge toolbar. * Prior to performing the merge, hold <Shift> and then select File/Save All. This will save the Mail Merge Main Document; and if the Data Source is a Word document, it will save that too. * Perform the merge. Merge choices are (the options are Merge to New Document, Merge to printer, merge to email and merge to new document) Above are the steps that I would follow when creating a mail merge for the company. It is a very useful procedure for the company because it makes things easier, more time-effective to carry out the procedure of creating form letters. Questionaire As I said before the questionaire is carried out purely on the basis of finding out the type of design they want in their forms and reports, the fields etc, Rest of the info was found out by the interview. Would you like a company logo to be used on every report and form? Yes/ No (circle your preference) Would you prefer only company colors to be used? Yes/No (Circle your preference) if yes please state what they are Describe the colour scheme you would like in your forms, reports etc Explain the number of tables and the types of fields you would prefer. Would you like your form design to stay constant throughout? All the information above would be used when creating the relation database for the company. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

  1. Marked by a teacher

    Planning- design a memo, letter and webpage for Capital FM.

    4 star(s)

    You can not change the font or the size and it does not have a spelling and grammar check. Text is very important in a leaflet as it tells you all the important points that the leaflet is advertising. We could use the desktop publishing program to create a good letter template.

  2. Difference between computerized and manual systems.

    a filing cabinet. Advertising the agency The way the company can be advertised by hand is by making leaflets. The leaflets can be created using pencil crayons to draw attractive images and logo. A ruler is needed to make sure that lines are drawn straight so that the completed work looks neat.

  1. Hardware &amp;amp; Software Requirements for Database

    The costs involved are in varies of prices depending on the size of the memory. If the hospital computers contain a RAM of 256 MB then they would need to buy a extra 256 MB for my database but if they have more then that then they could run my database very effectively.

  2. The Advantages of Using ICT Over Manual Meethods. Using Paint and Access.

    Another advantage is that it saves more money in the long way. Another disadvantage is that computer runs on electricity and if there is a power cut and you forget to save it then all your work will be lost.


    Select any of the records in the form To check if Vlooups are working accurately The report should change according to details 44. Select the grade boundary sheet and change the A to 80% To test the conditional formatting on the report sheet work correctly The conditional formatting feature should turn the A grade to green 45.

  2. I will design a new video database for the video shop that will also ...

    * Limited sorting: All data entered is displayed at once. If a user wants to see the mileage figures for a volunteer, he or she has to sort through every other bit of information to find that one piece, or pull the selected info into another sheet.

  1. Database Design Guideline

    Form doctors form: Patient ID, ward and illness Query Design - this is what the 2nd query will look like in my Microsoft access database document: Field: Doctor ID Forename Surname Patients ID Ward Tables: doctors doctors doctors patient patient Sort: Show: ?

  2. Database design.

    Various methods of data modelling exist, each using a host of conventions and tools. The most popular approach is called the entity-relationship (ER) approach, developed by Peter Chen in the late 1970s. Although a number of authors and tool designers have modified and expanded ER concepts, most still have a strong Chen flavor.

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