Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DATABASE school;
- USE school;
- CREATE TABLE adminPanel
- (
- adminId INT NOT NULL ,
- adminPass VARCHAR(255) NOT NULL,
- adminName VARCHAR(255) NOT NULL,
- adminMob VARCHAR(255)
- );
- CREATE TABLE teacherPanel
- (
- teacherId INT NOT NULL,
- teacherPass VARCHAR(255) NOT NULL,
- teacherName VARCHAR(255) NOT NULL,
- teacherMob VARCHAR(255)
- );
- CREATE TABLE subjectPanel
- (
- subjectId INT NOT NULL ,
- subjectName VARCHAR(255) NOT NULL,
- teacherId INT NOT NULL
- );
- CREATE TABLE classPanel
- (
- classId INT NOT NULL,
- subjectId int NOT NULL
- );
- CREATE TABLE studentPanel
- (
- studentId INT NOT NULL ,
- studentPass VARCHAR(255) NOT NULL,
- studentName VARCHAR(255) NOT NULL,
- studentMob VARCHAR(255),
- classId INT NOT NULL
- );
- CREATE TABLE marksPanel
- (
- studentId INT NOT NULL ,
- subjectId INT NOT NULL ,
- marks INT NOT NULL
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement