- Get link
- X
- Other Apps
create database school_data; use school_data; create table admins (first_name varchar(20) Not Null, middle_initial varchar(1) Not null, last_name varchar(20) NOt NULL, DOB varchar(10) NOt NULL, phone varchar(10) Primary key, alt_phone varchar(10), email varchar(150) NOt NULL, designation varchar(60) NOt NULL, subjects_taken varchar(150), classes_taken varchar(20)); create table class_teachers (first_name varchar(20) Not Null, middle_initial varchar(1) Not null, last_name varchar(20) NOt NULL, DOB varchar(10) NOt NULL, phone varchar(10) Primary key, alt_phone varchar(10), email varchar(150) NOt NULL, subjects_taken varchar(150), class_teacher_of varchar(2) Not Null, classes_taken varchar(20)); create table student_stats (ADMISSION_NO varchar(15) PRImary key, ROLL_NO int NOt NULL, GRADE varchar(10) NOt NULL, SECTION varchar(1) NOt NULL, DOB varchar(10) NOt NULL, FIRST_NAME varchar(30) NOt NULL, FATHERS_NAME varchar(30), MOTHERS_NAME varchar(30), LAST_NAME varchar(30) NO