Databases 0.0 / 5 ? ComputingDatabasesYears 7-9 (KS3)Edexcel Created by: GraceCampbell3Created on: 19-02-24 14:13 Lots of access to info Info Rich 1 of 25 Not very much access to info Info Poor 2 of 25 Where you store physical databases Filling Cabinet 3 of 25 Where we create online databases Access 4 of 25 The whole set of data File 5 of 25 The set of info on one single subject Record 6 of 25 Each seperate heading of info inside a record Field 7 of 25 Unprocessed, raw information Data 8 of 25 Fields that store characters or words Text 9 of 25 Fields that store integers or real numbers Numbers 10 of 25 Fields that store dates Date 11 of 25 Fields that stores the time of day Time 12 of 25 A field that is either true or false Boolean 13 of 25 A table which has one table and each row of the table is unique Flat File 14 of 25 Databases with more than one table Relational databases 15 of 25 Used to prevent duplication of data within a row of a table Linked Tables 16 of 25 Only searching one field Simple search 17 of 25 Searching on multiple fields Complex Search 18 of 25 Used to uniquely identify a single record Primary Key 19 of 25 Used to link tables together and create a relationship Foreign Key 20 of 25 Done to ensure all data is allowed & sensible Validation 21 of 25 When you change how many characters you can put in a field to save space Field Length 22 of 25 Used to store the actual data that is in the database Table 23 of 25 To make tables nicer to look at and easier to understand Form 24 of 25 Used to allow people to ask questions of data in a database Queries 25 of 25
Comments
Report