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

    The finished reports would look very unprofessional and would be of very low quality. Injuries that happen when using a computer e.g. RSI would not happen if you were to create the reports by hand. All the completed reports would need a reasonably large space to be stored e.g.

  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

    is a type of data storage used in computers. It takes the form of integrated circuits that allow the stored data to be accessed in any order at random and without the physical movement of the storage medium or a physical reading head. It is a temporary storage device that completes the tasks.

  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

    Setting up the input controls onto the quotes worksheet. This is the major worksheet of the system, and takes information from the groups and multipliers sheets and works out the quotation. I entered the labels for the customer's title, forename, surname, address, postcode and telephone, In C2 to C8.

  2. Computer study project outline - library and book club database.

    USBs: I am using two USBs in this project. They are both Kingston USBs, 4GB each. I use them to save my project and report as back up.

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