Notes
Notes - notes.io |
use College1;
create table Department(DepartmentID int primary key,
DepartmentName varchar(50));
create table Infrastucture(InfrastructureID int primary key,
InfrastructureName varchar(50),InfrastructureCapacity int);
create table Course(CourseID int primary key,CourseName varchar(50), DepartmentID int);
create table Teachers(TeacherID int primary key,TeacherName varchar(50),DepartmentID int);
create table Students(StudentID int primary key,StudentName varchar(50),DepartmentID int);
create table Theory(TheoryID int primary key,TheoryName varchar(50),CourseID int);
create table Labs(LabID int primary key,LabName varchar(50),CourseID int);
Insert into Department values(1,'Civil')
Insert into Department values(2,'ECE')
Insert into Department values(3,'EEE')
Insert into Department values(4,'CSE')
Insert into Department values(5,'IT')
Insert into Infrastucture values(1,'Gandhi Buliding',5550)
Insert into Infrastucture values(2,'Nehru Buliding',6850)
Insert into Infrastucture values(3,'CV Raman Buliding',9550)
Insert into Infrastucture values(4,'Anuradha Buliding',4550)
Insert into Infrastucture values(5,'Baburao Buliding',900)
Insert into Course values(1,'Concrete Engineering',1)
Insert into Course values(2,'Basic Electrical Engineering',3)
Insert into Course values(3,'Communication Systems',2)
Insert into Course values(4,'Computer Networks',4)
Insert into Course values(5,'Soft Computing',5)
Insert into Teachers values(1,'Mohit Kumar',1)
Insert into Teachers values(2,'Rohit Kumar',2)
Insert into Teachers values(3,'Abhinav Aryan',3)
Insert into Teachers values(4,'Abhishek Das',4)
Insert into Teachers values(5,'Aquib Ahmed',5)
Insert into Students values(1,'Lebron james',1)
Insert into Students values(2,'Stephen Curry',2)
Insert into Students values(3,'LaMelo Ball',3)
Insert into Students values(4,'James Harden',4)
Insert into Students values(5,'Kevin Durant',5)
Insert into Theory values(1,'Venn Diagram',5)
Insert into Theory values(2,'Brick Anatomy',1)
Insert into Theory values(3,'IPv4',4)
Insert into Theory values(4,'Mobile communication',3)
Insert into Theory values(5,'Circuit Laws',2)
Insert into Labs values(1,'Concrete Lab',1)
Insert into Labs values(2,'BEE Lab',2)
Insert into Labs values(3,'Analog Communication Lab',3)
Insert into Labs values(4,'Networking Lab',4)
Insert into Labs values(5,'DME Lab',5)
|
|
Notes.io is a web-based application for taking notes. You can take your notes and share with others people. If you like taking long notes, notes.io is designed for you. To date, over 8,000,000,000 notes created and continuing...
With notes.io;
- * You can take a note from anywhere and any device with internet connection.
- * You can share the notes in social platforms (YouTube, Facebook, Twitter, instagram etc.).
- * You can quickly share your contents without website, blog and e-mail.
- * You don't need to create any Account to share a note. As you wish you can use quick, easy and best shortened notes with sms, websites, e-mail, or messaging services (WhatsApp, iMessage, Telegram, Signal).
- * Notes.io has fabulous infrastructure design for a short link and allows you to share the note as an easy and understandable link.
Fast: Notes.io is built for speed and performance. You can take a notes quickly and browse your archive.
Easy: Notes.io doesn’t require installation. Just write and share note!
Short: Notes.io’s url just 8 character. You’ll get shorten link of your note when you want to share. (Ex: notes.io/q )
Free: Notes.io works for 12 years and has been free since the day it was started.
You immediately create your first note and start sharing with the ones you wish. If you want to contact us, you can use the following communication channels;
Email: [email protected]
Twitter: http://twitter.com/notesio
Instagram: http://instagram.com/notes.io
Facebook: http://facebook.com/notesio
Regards;
Notes.io Team
