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