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