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