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