Quiz Application# 1 (Databse Design)

create table admin_athu
(
ad_id int primary key identity  ,
ad_user nvarchar(20) not null,
ad_password nvarchar(20) not null

)

create table student_record
(
std_id int primary key identity  ,
std_name nvarchar(20) not null,
std_batchcode nvarchar(20) not null,
std_password nvarchar(20) not null,
std_ad_id int foreign key references admin_athu(ad_id )
)


create table exams
(
ex_id int primary key identity  ,
exam_name nvarchar(20) not null
)

create table questions
(
q_id int primary key identity,
q_title   nvarchar(max) not null,
q_opa nvarchar(200) not null,
q_opb nvarchar(200) not null,
q_opc nvarchar(200) not null,
q_opd nvarchar(200) not null,
q_opcorrect nvarchar(200) not null,
q_addeddate nvarchar(20) not null,
q_fk_ad int foreign key references admin_athu(ad_id ),
q_fk_ex int foreign key references exams(ex_id)
)