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