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