Key Stage 3 ICT INTRODUCTION TO DATABASES Lets

Key Stage 3 ICT INTRODUCTION TO DATABASES ‘Let’s make a Database!’ 1

In the Database Unit you will: n Learn that databases have many different uses. n Learn about the different parts of a database. n Collect information for a database. n Create a database. n Enter data into a database. n Use databases to sort and group information, create charts, write reports, and calculate statistics. n Search databases to find useful information. n Evaluate the databases you use. 2

Pupil No. Surname First Name Gender Age Date of Birth Favourite Sport 001 Jones Paul M 11 2/5/94 Rugby 002 Mitchell Joni F 11 6/2/94 Football 003 Clapton Eric M 10 7/9/95 Swimming Database 3

Pupil No. Surname First Name Gender Age Date of Birth Favourite Sport 001 Jones Paul M 11 2/5/94 Rugby 002 Mitchell Joni F 11 6/2/94 Football 003 Clapton Eric M 10 7/9/95 Swimming Data Item 4

Pupil No. Surname First Name Gender Age Date of Birth Favourite Sport 001 Jones Paul M 11 2/5/94 Rugby 002 Mitchell Joni F 11 6/2/94 Football 003 Clapton Eric M 10 7/9/95 Swimming Field 5

Pupil No. Surname First Name Gender Age Date of Birth Favourite Sport 001 Jones Paul M 11 2/5/94 Rugby 002 Mitchell Joni F 11 6/2/94 Football 003 Clapton Eric M 10 7/9/95 Swimming Key Field 6

Pupil No. Surname First Name Gender Age Date of Birth Favourite Sport 001 Jones Paul M 11 2/5/94 Rugby 002 Mitchell Joni F 11 6/2/94 Football 003 Clapton Eric M 10 7/9/95 Swimming Record 7

Text Limited Text Number Date Pupil No. Surname First Name Gender Age Date of Birth Favourite Sport 001 Jones Paul M 11 2/5/94 Rugby 002 Mitchell Joni F 11 6/2/94 Football 003 Clapton Eric M 10 7/9/95 Swimming Some Data Types 8

Unlimited Data The data you put in a field could be anything. In the favourite sport field you could put: Rugby, Football, Ice Skating, Running, Horse Riding, Swimming, Netball, Rounders, Cricket, or anything else. 9

Limited Data You choose the data you put in a field. In the favourite sport field you could put: Rugby Netball Swimming Other Why choose Rugby, Netball, & Swimming? Why have Other? 10

Data Types Alphanumeric (Text) Number Auto Number Currency Date Time Yes/No (Logical or Boolean) Image Hyperlink 11