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