Ordonner les Mots Relational DatabaseVersion en ligne Key vocabulary for relational database par Monica Nash 1 How do relational databases store data ? database store multiple tables Relational data on related 2 What are tables in a spreadsheet? horizontal In and tables columns vertical rows applications are spreadsheet 3 What terms are used for database tables? tables Database have fields and records 4 Why are rows called records in a database? together are called all information records belongs the because on row Rows a 5 Why are columns called fields in a database? same Columns kind because called fields are the of has information field each . . 6 What is the purpose of the primary key field? each a The unique primary record identifier field the purpose to of is give 7 Why would you use an employee ID# as a primary key rather than the employee name? unique two employees Employee ID have Even is the , same name though each may . , . 8 What is a foreign key? similar to the that field relational table in primary key the in field of table a A looks another database 9 How does a relational database create relationships? the a foreign By in a correspond key field primary the number number to key in field having 10 What is an example of a one-to-many relationship in the relational database pictured? to number Even have only each belong one though phone can , person each person phone can many numbers . , .
Créer jeu