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

    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. Hardware &amp;amp; Software Requirements for Database

    The costs price for a 256 MB of RAM is about �15 onwards which is not so expensive, as it will benefit the hospital in many other ways then just for my database. ==> A video card, (also referred to as a graphics accelerator card, display adapter, graphics card, and

  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 student list box To check that list box is working correctly When each student is selected from the list box, student roll number should appear in cell F13 32. Try to delete list box To test sheet protection User should not be able to delete list box 33.

  2. IT system for local video store.

    the fields and entities required, and could meet the needs and objectives of the end user, however a major drawback would be the cost of this new system, for not only would the video shop have to purchase the necessary software, but would also have to pay maintenance costs.

  1. Creating an I.T. System for the Al Shabah Publishing Group

    facility so as to protect the data in the event of hardware failure * 20 GB hard Drive * 64 MB RAM * Pentium 3 processor * Standard Graphics Card * Some PCs have CD-ROM with DVD * 3.5 floppy disk drive * Network Printer i.e.

  2. Features of a sports club database. The system has at least 1 table and ...

    A Section that contains information about the fixture. The field has a pop up calendar to help the user selecting the right date 7. Hyperlinks to the other pages 8. (Has already been included) 9. Space for the coaches to include any additional information The main use of this layout is to inform the players about the oncoming fixture.

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