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