Question: Complete the table below by matching each definition with the appropriate SQL constraint. Group of answer choices Ensures that each value inserted in a column
Complete the table below by matching each definition with the appropriate SQL constraint.
Group of answer choices
Ensures that each value inserted in a column or columns is UNIQUE and NOT NULL
PRIMARY KEY
Ensures that data in the column of a table matches the values in another column of the same, or another, table
FOREIGN KEY
Specifies a value given to an attribute when a tuple is inserted without specifying the value for the particular attribute
DEFAULT
Ensures that each row tuple must have a unique value for a particular column attribute
UNIQUE
Ensures that the value in a column meets a specific condition
CHECK
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
