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