Computer Science
Add a constraint (NN-Grade) in table Empl that declares column Grade not null.
DDL & DML
7 Likes
Answer
ALTER TABLE Empl
ADD CONSTRAINT NN_Grade
(Grade NOT NULL) ;
Answered By
6 Likes
Related Questions
Modify table Empl, add another column called Grade of VARCHAR type, size 1 into it.
In the added column Grade, assign grades as follows :
if sal is in range 700 — 1500, Grade is 1 ;
if sal is in range 1500 — 2200, Grade is 2 ;
if sal is in range 2200 — 3000, Grade is 3 ;
if sal is in range 3000 — Grade is 4 ;Insert a record of your choice in table Empl. Make sure not to enter Grade.
Modify the definition of column Grade. Increase its size to 2.