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