Answered step by step
Verified Expert Solution
Link Copied!

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

  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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

PostgreSQL Up And Running A Practical Guide To The Advanced Open Source Database

Authors: Regina Obe, Leo Hsu

3rd Edition

1491963417, 978-1491963418

More Books

Students also viewed these Databases questions

Question

b. Will new members be welcomed?

Answered: 1 week ago