create table OAM_Master_Data_Students(Student_id int unsigned not null, Student_name varchar(50), Address varchar(50), Father_name varchar(70), Email_id varchar(60) , primary key(Student_id,Student_name));   create table OAM_Master_Data_Teacher(Teacher_id int unsigned not null, Teacher_name varchar(60), Address varchar(70), Email varchar(70), Batch_Assigned varchar(50), primary key(Teacher_id,Teacher_name));   create table OAM_Courses(Course_id int unsigned not null primary key, Course_name varchar(60), Teacher_allocated varchar(50));  create table OAM_Student_Reg(Course_Reg_Id int unsigned not null primary key,Course_name varchar(60), Teacher_name varchar(60),Student_name varchar(50), foreign key (Course_name) references OAM_Courses(Course_name), foreign key (Student_name) references OAM_Master_Data_Students(Student_name), foreign key (Teacher_name) references OAM_Master_Data_Teacher(Teacher_name));   create table OAM_Attendance_Marking_form( Student_id int unsigned not null, Course_name varchar(60) ,Date varchar(50) not null primary key, (foreign key (Course_name) references OAM_Courses(Course_name), foreign key (Student_id ) references OAM_Master_Data_Students(Student_id ));