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