Print Unscramble Words Game: Relational Database (technology - k12

1. How do relational databases store data ?

database related Relational tables data multiple store on

2. What are tables in a spreadsheet?

tables columns In and rows horizontal are spreadsheet vertical applications

3. What terms are used for database tables?

records have fields tables and Database

4. Why are rows called records in a database?

all because information the together records Rows a row are on belongs called

5. Why are columns called fields in a database?

are each because field Columns same fields the called has kind of information.

6. What is the purpose of the primary key field?

unique each is of identifier the record give purpose The field to a primary

7. Why would you use an employee ID# as a primary key rather than the employee name?

same may unique Even Employee is ID name each, the two have employees though.

8. What is a foreign key?

field looks another that of primary in the database in relational similar A table field table the a to key

9. How does a relational database create relationships?

field primary number number to By correspond a a the key in having field foreign the key in

10. What is an example of a one-to-many relationship in the relational database pictured?

many have each person to belong phone one phone only number, each can person can numbers Even though.