Question

Write SQL query to construct a table student with fields Reg No, Stud Name, Sex, Course, grade, etc. As per the following conditions 

1. Reg No should not be empty and using this column any rows in that table can be identified. Reg. No. 

2. Student name should have some value. 

3. Default value of sex be Female. 

4. Grade should be any of the values: A+, A, B+, B, C+, C, D+, D, E

Answer 1

Create table Student(RollNo decimal(3) not null primary key,