school

CREATE DATABASE school;

USE school;

CREATE TABLE adminPanel
(
adminId INT NOT NULL PRIMARY KEY,
adminPass VARCHAR(255) NOT NULL,
adminName VARCHAR(255) NOT NULL,
adminMob VARCHAR(255)
);

CREATE TABLE teacherPanel
(
teacherId INT NOT NULL PRIMARY KEY,
teacherPass VARCHAR(255) NOT NULL,
teacherName VARCHAR(255) NOT NULL,
teacherMob VARCHAR(255)
);

CREATE TABLE subjectPanel
(
subjectId INT NOT NULL PRIMARY KEY,
subjectName VARCHAR(255) NOT NULL,
teacherId INT NOT NULL FOREIGN KEY REFERENCES teacherPanel(teacherId)
);

CREATE TABLE classPanel
(
classId INT NOT NULL,
subjectId int NOT NULL FOREIGN KEY REFERENCES subjectPanel(subjectId)
);

CREATE TABLE studentPanel
(
studentId INT NOT NULL PRIMARY KEY,
studentPass VARCHAR(255) NOT NULL,
studentName VARCHAR(255) NOT NULL,
studentMob VARCHAR(255),
classId INT NOT NULL
);

CREATE TABLE marksPanel
(
studentId INT NOT NULL FOREIGN KEY REFERENCES studentPanel(studentId),
subjectId INT NOT NULL FOREIGN KEY REFERENCES subjectPanel(subjectId),
marks INT NOT NULL
);