Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started