Question: Create table with the following specifications: Student Field Name Data Type Comments fName Maximum 20 character Key lName Maximum 20 character Gender One character Must
Create table with the following specifications:
Student
| Field Name | Data Type | Comments |
| fName | Maximum 20 character | Key |
| lName | Maximum 20 character | |
| Gender | One character | Must be F or M |
| GPA | DECIMAL(3,2) | CHECK constraint to ensure GPA greater than zero |
- Write SQL statement that insert student record in table with following values ahamd Ali ,Male and his GPA =3.5
- Add new column to the table student its name serialNumber .
- Remove CHECK constraint on GPA
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
