Primary key b) CHECK, price less or equal to $ 10000 c) description UNIQUE
Add three constraints
a) Primary key
b) CHECK, price less or equal to $ 10000
c) description UNIQUE
a- First, let's understand what is the primary key and how it works?
The primary key unique identify each record and one table has only one primary key. It can not accept any kind of duplicate and null records.
b-
The second question requires where clause to match the specific condition price less than equal to 10000.
SELECT price FROM person WHERE price <= 10000;
c-
The UNIQUE constraint guarantees that every value in a column is certainly one of a kind.
Both the UNIQUE and PRIMARY KEY constraints offer a guarantee for a strong point for a column or set of columns.
A PRIMARY KEY constraint automatically has a UNIQUE constraint and a Unique key is a constraint this is used to uniquely discover a tuple in a table.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images
