Home > Articles > Data > SQL

SQL and Data

  • Print
  • + Share This
This chapter is from the book

Lab 1.1 Exercises

1.1.1 Identify and Group Data

  1. Give three examples of types of data.

  2. What groupings of data do you use in your daily life?

  3. Give an example of a database system you use outside of the workplace and explain how it helps you.

1.1.2 Define SQL

  1. What is SQL and why is it useful?

  2. Try to match each of the SQL commands on the left with a verb from the list on the right.

    1. CREATE

    a.manipulate

    2. UPDATE

    b.define

    3. GRANT

    c.control


  3. 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

  1. How is data organized in a relational database?

  2. Do you think it's possible to have a table with no rows at all?

  3. 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 05Figure 1.5 EMPLOYEE and DEPARTMENT tables.

  • + Share This
  • 🔖 Save To Your Account