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