Learning Objectives

  • Create a relational table using the CREATE TABLE SQL command
  • Select appropriate data types for attributes in relations
  • Manipulate data using the following SQL commands:
    • INSERT
    • UPDATE
    • DELETE

How to Complete this Lesson

  1. Read the following sections in Fundamentals of Database Management Systems Chapter 7: Logical Database Design (15 minutes)
    • Building the Data Structure with SQL
    • Manipulating the Data with SQL
  2. Attend the class meeting
  3. Choose one of the resources for learning SQL and complete the relevant portions for creating tables and inserting, updating, and deleting tuples to review the concepts covered in class
« Graded Review I Relational Algebra I »