• 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
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  • Level: GCSE
  • Subject: ICT
  • Word count: 2561

Normalisation.Normalisation is a process used to come up with the best possible design for a related database.

Extracts from this document...

Introduction

Alex Miller A-VCE ICT Coursework Microsoft Access 97 The Problem The adult education class needs a new database as running the courses with books proves a problem. There is a selection of books with each set of data in. This data can become damaged and the staff can forget to update each book. Also as there are a few books, staff has to update each one with the new data, this can become tenuous and annoying. Another point is that there are many different subjects, rooms and tutors that need to be linked together. This can be a problem as some classes can be in different rooms each day of the week. With a book this can be a problem, as the design may not have a feature for this. The new database will put all the data into separate tables and link them all together. This will enable all the tables to function together allowing the user to change the data in one and it will be changed in them all. The user will also be able to run queries asking the database questions. This will enable the user to gather information without having to search through all the data. This can save a lot of time and improve accuracy as human error may be nearly deleted. The database is going to have to incorporate the student's personnel data, the class times and the tutors. The database will be assessable to all the teachers and admin staff so, with little training everyone will be able to finds out important information. ...read more.

Middle

The system I will be using The system at school My system at home Pentium 2 350MHz AMD Athlon 600MHz 64 MB 128 MB 6.4 Gig Memory 27 Gig Memory 14" SVGA Monitor 17" SVGA Monitor Microsoft office 97 Microsoft office 97 + Microsoft word 2000 Microsoft Windows 98 Microsoft Windows 98 8MB HND Graphics Card TNT 2 Graphics card Constraints and limitations As I will be doing work at home and at 6th form I may experience a few constraints. For example at home I have Microsoft word 2000 whereas at 6th form they have the 97 edition. This can prove to be a problem, as I cannot take work to and from 6th form to complete at home. This means that I will have to complete all word documents either at home or at 6th form. This is only a minor problem which I can overcome by selecting work to take home as I have access 97 the same as the 6th form. If I know I have to do a word document and I may have to take it home I will do it at 6th form rather than other work which I can take home. I will have to manage my time. My second slight limitation is that other classes in the school often book the computer rooms at 6th form. This can mean that I am not able to work on a computer at certain times. ...read more.

Conclusion

You will then need to click on the 'New Student button' this will link you to a form which will allow you to put in information so a new member is added. The from has a macro linked to it so you will always get a blank form when you click this button. If you want to browse other details then click on the 2 buttons, 'Previous record' or 'Next record'. The page you get will look like this; Once you have inputted all the information you want just click on 'Save record' and the information will be saved. Then click on close form and you will go back to the students menu, if you do not want to be here either then click on 'Back to the main screen' which is on every selection screen. This links you back to the main menu so you can choose what you want to do next. 2) To change details of students or tutors: Again changing students or tutors details are done is the same way. Below are a list of instructions for changing tutors details but again, if you want students then you will have to follow the same instructions but just with 'Students'. Click on the 'Tutors' button on the main page, this will link you to a tutors menu just like the 'students' one. Here you can add a new tutor or change a existing tutors details. To change details just click on the 'Change Tutor Details' button as shown below. ...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)

    The other staff may not be able to read it so that why we are creating a real memo on the computer. If a staff member is ill on one of the day's she is meant to be working then it is very hard to find another staff member that will come in on such short notice.

  2. Different types of technology How I use ICT at home and at school

    channels * Satellite is vulnerable to weather and other interruptions outside * Analogue television gets fuzzy when it is interrupted but still gives off a certain picture or audio whereas digital television is completely cut off and any interruption * A lot of the same disadvantages having a television brings Conclusion Overall, Sky Digital provides a great service.

  1. GCSE ICT Coursework Booklet

    Petersburg, which was soon followed by a wave of other strikes which brought the city to a standstill. Unrest spreading News of the St. Petersburg massacre was quick to spread to other parts of Russia. Reports suggest that nearly 3,000 manor houses belonging to rich noblemen have been burned down.

  2. Database design.

    The employer always said that if he got a computer in again he wouldn't know much about the software or hardware to buy. Aims My aims are * To provide an easy to work database for the users. * To design an organised database.

  1. Access Database

    To have a customized When I open up database A switch board did Switch board customized switch board not open up should open up Evaluation of objectives * Must have more than one table (entity) to create relationships I kept more than one table, in order to input more data.

  2. a level ict project

    a long time before their ability can provide maximum returns by system, plus there will be increased costs of training staff up to this standard. Moreover, even though a majority of tasks are automated, the system is still susceptible to human errors during the input stage of the system when information is keyed in.

  1. Database design for a farmers herd book.

    Each of the rows in a table is called a record and the items in the columns are called fields. In these relational databases there will be an assortment of tables - one for each entity type; i.e. there could be a table for patients, suppliers and one for products.

  2. Being a 6th former

    - They had not! Instead the Subjects which were fun/easy and all together a good laugh @ GCSE were now boring/tedious/and hard. I know I had made the wrong decision. I still know it to this day. Nevertheless, what could I do? About five people could not hack the workload dropped out, and choose a get away before the first half term.

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