Question

Create the following table: Table: Student

ColumnName Data Type Size Constraints

Adno Numeric 3 Primary key
Name Varchar 20 NOT NULL
Class Numeric 2
Section Char 1
Fees Numeric 10,2

Answer 1

use the follow query in SQL view

create table student(Adno numeric(3)(set primary key),Name varchar (20)(NOT NULL),Class Numeric (2),Section Char(1),Fees Numeric (10)(2)),