Can u please create stored procedures and triggers
Create table AdministrationTable (
AdminID char Primary Key,
FirstName Varchar(100) Not Null,
LastName Varchar(50),
Email varchar(255),
Password varchar(200),
Mobile int,
DepartmentID char,
);
Create table DepartmentTable (
DepartmentID char Primary key,
DepartmentName varchar(100),
HOD varchar(1500)
);
ALTER TABLE AdministrationTable
ADD FOREIGN KEY (DepartmentID) REFERENCES DepartmentTable(DepartmentID);
Create table CareerBlogTable (
BlogID Char Primary key,
BlogDate date,
BlogTitle char,
Category varchar(100),
DepartmentID Char,
FOREIGN KEY (DepartmentID) REFERENCES DepartmentTable(DepartmentID)
);
Create Table AppointmentTable (
AppointmentID Char PRIMARY KEY,
AppointmentDate date,
AppointmentTitle char,
AppoitmentTime time
);
Create Table InstructorTable (
InstructorID Char Primary key,
FirstName Varchar(100),
LastName varchar(100),
DOB date,
Address varchar(150),
Password varchar(200),
Email varchar(150),
MobileNo int,
Gender char,
AppointmentID char,
DepartmentID char,
FOREIGN KEY (AppointmentID) REFERENCES AppointmentTable(AppointmentID),
FOREIGN KEY (DepartmentID) REFERENCES DepartmentTable(DepartmentID)
);
Create Table CareerTable (
CareerID char Primary key,
CareerType Varchar(100),
CareerTitle char
);
Create Table UserTable (
UserID char Primary key,
FirstName varchar(100),
LastName varchar (100),
Password varchar(150),
Gender char,
Email Varchar(150),
MobileNo int,
Hobbies nvarchar(255),
FirstChoiceCareer varchar(200),
SecondChoiceCareer varchar(200),
AppointmentID char,
InstructorID char,
FOREIGN KEY (AppointmentID) REFERENCES AppointmentTable(AppointmentID),
FOREIGN KEY (InstructorID) REFERENCES DepartmentTable(DepartmentID)
);
Create Table CourseTable (
CourseID char Primary key,
CourseName varchar(255),
Email nvarchar(255)
);