Lab 1.1 Exercises
1.1.1 Identify and Group Data
Give three examples of types of data.
What groupings of data do you use in your daily life?
Give an example of a database system you use outside of the workplace and explain how it helps you.
1.1.2 Define SQL
What is SQL and why is it useful?
Try to match each of the SQL commands on the left with a verb from the list on the right.
Why do you think it is important to control access to data in a database?
1.1.3 Define the Structures of a RDBMS: Tables, Columns, Rows, and Keys
How is data organized in a relational database?
Do you think it's possible to have a table with no rows at all?
Figure 1.5 displays a listing of an employee and a department table. Identify the columns you consider to be primary keys and foreign keys for the tables.
Figure 1.5 EMPLOYEE and DEPARTMENT tables.