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)
);
CareerID char Primary key,
CareerType Varchar(100),
CareerTitle char
);
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)
);
CourseID char Primary key,
CourseName varchar(255),
Email nvarchar(255)
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more
Recent Comments