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