Question

write SQL statement to create the following table student: Admission_No. char (6) Student_Name. Varchar(40). Grade_Applied_for. char(2). Admission_date. Date (b) Giving suitable reason mention which of the above fields should be the primary key in table student.​

Answer 1

#MySql query

create table student

(

admission_no integer(6) [primary key] ,

student_name varchar(40),

grade_applied_for char(2),

admission_date date

);