1. เรียนรู้
    2. /
  2. Courses
    3. /
  3. Introduction to Relational Databases in SQL
Connected

Exercises

Disallow NULL values with SET NOT NULL

The professors table is almost ready now. However, it still allows for NULLs to be entered. Although some information might be missing about some professors, there's certainly columns that always need to be specified.

คำแนะนำ 1 / 2

undefined XP
  • 1

    Add a not-null constraint for the firstname column.

  • 2

    Add a not-null constraint for the lastname column.