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