Relationships manually changing each of their course

Relationships help you reduce data storage. For example if
you had a table called student you wouldn’t put a field called course in as
this would require you to enter what course a student is on every time you
enter a new student. However if you had a table called course and linked it to
the student table you would only need to type in the courses once then on the
student table under the course field if you linked them correctly it would put
the course in for you you’d just need to select the course. This doesn’t only
reduce the data you are storing it reduces the time it’d take for your database
to load up and it prevents typos from occurring that could cancel a student out
of a search. It allows faster access as there’s less information the database
needs to load up and instead of looking down each student seeing if they are on
the course they can just go to the course table get the course you require and
check what student is linked to it. It’s also much more efficient to update. Using
my example, say you were told to chance the name of a course from Btec ICT to
Btec Computing. If you didn’t make a new table you’d need to go down every
student manually changing each of their course names. But if you made a new
table for course if you change the name in the table then it will automatically
change the name in all of the student’s records. Using relationships also make
it easier to search for specific information. If you wanted to find a student
called John Doe doing ICT but you had more than one John Doe in the database you
could do a query that searches the student table for John Doe but can also
search the course table for ICT and you’d be left with John Doe that takes ICT.
Relationships can also be useful if you wanted to get information in a certain
order. If you wanted every student but in order of their results, you’d make a
query for the student and result and you can specify that you’d like the results
table in ascending or descending order. This would sort the results in to the
order of your choice showing the student with the highest/lowest mark first. Relationships
are also helpful for making reports on the database. If the head teacher wanted
to see a report of every student and their current marks, you can create a
report and select both the student table and the results table. You can decide
what the report will show if its just the name and mark or the student ID as well.
How you make a report differs from what software you are using if its Microsoft
Access then there will be a create report button. 


I'm Dana!

Would you like to get a custom essay? How about receiving a customized one?

Check it out