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

  1. Write SQL statement that insert student record in table with following values ahamd Ali ,Male and his GPA =3.5

  1. Add new column to the table student its name serialNumber .

  1. Remove CHECK constraint on GPA

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!