Modify the definition of column Grade. Increase its size to 2.
3 Likes
ALTER TABLE Empl MODIFY (Grade VARCHAR(2)) ;
Answered By
2 Likes
Add a constraint (NN-Grade) in table Empl that declares column Grade not null.
Insert a record of your choice in table Empl. Make sure not to enter Grade.
Drop the table Empl.
Create the table Department table based on the following table instance chart.