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