Question

Write SQL query to create a table “Registration” with the following structure:

Table: Registration

| Field name | Datatype | Size | Constraint |
| Reg_Id | Integer | 2 | Primary Key |
| Name | Varchar | 20 | |
| Course | Varchar | 10 | |
| Join_Dt | Date | | |

Answer 1

Create table Registration

(

Reg_Id Integer(2) Primary Key,

Name varchar(20),

Course varchar(10),

Join_Dt date

);