Structures and linksAdvantages of electronic databases

Information systems like databases are used to store and present information, making it easier to visually interpret and understand, faster to search, update and check for errors.

Part ofComputing ScienceInformation system design and development

Advantages of electronic databases

One of the major advantages of storing information in electronic databases is that it is really easy to add new information, sort the information into whichever order you like, and search through millions of records to find one specific match.

A search tries to find matches for whatever you search for. The number of matches depends on what data is stored and what you are searching for. For example, searching for "Forename: John" could return many results, whereas searching for “ID Badge Number: 345245” will most likely return one result. Searching for "Forename: XchgyHtnf264647" will most likely return zero results.

A sort orders the data on a field which you choose.

Ascending order starts with the smallest first and works its way up to the largest. This works even with dates - 04/04/1940 is counted as smaller than 29/01/2015. If you get stuck use the year and work backwards.

Descending order starts with the largest first and works its way down to the smallest.

Question

ForenameSurnameDate
ElizabethArthur12/03/2015
UmairSheikh01/03/2015
IanYates15/03/2015
ForenameElizabeth
SurnameArthur
Date12/03/2015
ForenameUmair
SurnameSheikh
Date01/03/2015
ForenameIan
SurnameYates
Date15/03/2015

This list is in __________ order of __________.

Question

ForenameScoreDate
Alex23023/12/2015
Umair23322/12/2015
Elizabeth25523/12/2015
ForenameAlex
Score230
Date23/12/2015
ForenameUmair
Score233
Date22/12/2015
ForenameElizabeth
Score255
Date23/12/2015

This list is in __________ order of __________.

Question

ForenameSurnameAge
DerekScott23
CalebBlack23
AasimIqbal55
ForenameDerek
SurnameScott
Age23
ForenameCaleb
SurnameBlack
Age23
ForenameAasim
SurnameIqbal
Age55

This list is in __________ order of __________.