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

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.

Middle

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.

Conclusion

* 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)

    it will take a long time changing the name every time you print a letter. Chosen Method A word processing package would appear appropriate. It contains many tools that would assist in realising many of the end-user's wishes: Mail Merge, Templates, and Fill-in fields with promote boxes, macro fill-in fields and an auto date.

  2. Difference between computerized and manual systems.

    It looks very neat and eye catching. It can take a lot of time if you are not familiar with using a mouse to draw in the computer. It can be created very quickly if a design that had already been created or was already saved on the computer was to be chosen.

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

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

    that my data base does not require more use of space as the hospitals have to use this space for other information. ==> A Random access memory (usually known by its acronym, RAM) is a type of data storage used in computers.

  1. System requirements analysis

    The advantages of using an LCD are that the image that is shown on the screen is perfectly sharp and clear and the brightness is very good as well especially for bright images. Also the screens are perfectly flat and use less electricity so the cost of the electricity is kept at a minimum.

  2. The Design Brief - The company is a car hire company called Citicar.

    I tried to make a short user guide to teach users in a simple and easy to understand way how to use the database. Some comments made by the users who tested the system were that they weren't experienced enough with Access so took them a while to get used to it.

  1. ICT car insurance quotation System Coursework

    I set up a formula in cell H14 that would multiply the figure calculated in cell H12 by the no-claims percentage in cell F23. Finally I set up a formula in cell H16 that would subtract the calculated figure in H14 from the calculated figure in cell H12.

  2. Performance Charts - The aim of this task is to produce a simple chart ...

    Therefore, they must, for addition, take one of two forms: =SUM(x+y+z) (Where x, y and z are all cells) OR =SUM(x:y) (Where x:y is a range of cells) NOTE: In this case, no multiplication needs to done, so this does not need to be explained.

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