-
Notifications
You must be signed in to change notification settings - Fork 0
/
data.sql
22 lines (17 loc) · 7.63 KB
/
data.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Insert Into Department(Id, name) Values (1, 'CS');
Insert Into Department(Id, name) Values (2, 'EE');
Insert Into Department(Id, name) Values (3, 'ME');
Insert Into Faculty(Id, Name, dept_id, Email) Values (1, 'Mr. A', 1, 'a@iitrpr.ac.in');
Insert Into Faculty(Id, Name, dept_id, Email) Values (2, 'Mr. B', 1, 'b@iitrpr.ac.in');
Insert Into Faculty(Id, Name, dept_id, Email) Values (3, 'Mr. C', 2, 'c@iitrpr.ac.in');
Insert Into Faculty(Id, Name, dept_id, Email) Values (4, 'Mr. D', 2, 'd@iitrpr.ac.in');
Insert Into Faculty(Id, Name, dept_id, Email) Values (5, 'Mr. E', 3, 'e@iitrpr.ac.in');
Insert Into Faculty(Id, Name, dept_id, Email) Values (6, 'Mr. F', 3, 'f@iitrpr.ac.in');
Insert Into Users(Id, Name, username, password) Values (1, 'Mr. A', 'a', '12qwaszx');
Insert Into Users(Id, Name, username, password) Values (2, 'Mr. B', 'b', '12qwaszx');
Insert Into Users(Id, Name, username, password) Values (3, 'Mr. C', 'c', '12qwaszx');
Insert Into Users(Id, Name, username, password) Values (4, 'Mr. D', 'd', '12qwaszx');
Insert Into Users(Id, Name, username, password) Values (5, 'Mr. E', 'e', '12qwaszx');
Insert Into Users(Id, Name, username, password) Values (6, 'Mr. F', 'f', '12qwaszx');
{"username" : "a", "name" : "Mr. A", "email" : "a@iitrpr.ac.in", "password" : "12qwaszx", "Publication" : [{"Date" : "1998", "Paper" : "Learning to Learn", "Conf" : "ICML 2017 Conference, Mac Hill"}, {"Date" : "1998", "Paper" : "Meta Optimizer Auto Loss", "Conf" : "ICML 2018 Conference, Mac Hill"}], "Education" : [{ "Study" : "IIT Ropar B.Tech CSE", "Year" : "1998" },{ "Phd" : "Waterloo Univrsity", "Year" : "2003"}],"Award" : [{"Title" : "Best IEEE Conference Paper", "Date" : "Sept 2017"}, {"Title" : "Best Doctorialship Award", "Date" : "May 2014"}],"Grants" : [ ], "Teaching" : [{"Course" : "Machine Learning", Date: "2018 Fall"}, {"Course" : "Database Systems", "Date" : "2019 Spring"}]}, {"username" : "b", "password" : "12qwaszx", "Publication" : [{"Date" : "1998", "Paper" : "Learning to Learn"}], "Education" : [{ "Study" : "IIT Ropar B.Tech CSE", "Year" : "1998" },{ "Phd" : "Waterloo Univrsity", "Year" : "2003"}],"Award" : [ ],"Grants" : [ ], "Teaching" : [ ]}, {"username" : "c", "password" : "12qwaszx", "Publication" : [{"Date" : "1998", "Paper" : "Learning to Learn"}], "Education" : [{ "Study" : "IIT Ropar B.Tech CSE", "Year" : "1998" },{ "Phd" : "Waterloo Univrsity", "Year" : "2003"}],"Award" : [ ],"Grants" : [ ], "Teaching" : [ ]}, {"username" : "d", "password" : "12qwaszx", "Publication" : [{"Date" : "1998", "Paper" : "Learning to Learn"}], "Education" : [{ "Study" : "IIT Ropar B.Tech CSE", "Year" : "1998" },{ "Phd" : "Waterloo Univrsity", "Year" : "2003"}],"Award" : [ ],"Grants" : [ ], "Teaching" : [ ]}, {"username" : "e", "password" : "12qwaszx", "Publication" : [{"Date" : "1998", "Paper" : "Learning to Learn"}], "Education" : [{ "Study" : "IIT Ropar B.Tech CSE", "Year" : "1998" },{ "Phd" : "Waterloo Univrsity", "Year" : "2003"}],"Award" : [ ],"Grants" : [ ], "Teaching" : [ ]}, {"username" : "f", "password" : "12qwaszx", "Publication" : [{"Date" : "1998", "Paper" : "Learning to Learn"}], "Education" : [{ "Study" : "IIT Ropar B.Tech CSE", "Year" : "1998" },{ "Phd" : "Waterloo Univrsity", "Year" : "2003"}],"Award" : [ ],"Grants" : [ ], "Teaching" : [ ]}
{"username" : "A", "name" : "2016csb1055", "email" : "2016csb1055@iitrpr.ac.in", "password" : "prerna","Overview": "Interested in MAchine Learning", "Publication" : [{"Date" : "1998", "Paper" : "Learning to Learn", "Conf" : "ICML 2017 Conference, Mac Hill"}, {"Date" : "1998", "Paper" : "Meta Optimizer Auto Loss", "Conf" : "ICML 2018 Conference, Mac Hill"}], "Education" : [{ "Study" : "IIT Ropar B.Tech CSE", "Year" : "1998" },{ "Study" : "Phd Waterloo Univrsity", "Year" : "2003"}],"Award" : [{"Title" : "Best IEEE Conference Paper", "Date" : "Sept 2017"}, {"Title" : "Best Doctorialship Award", "Date" : "May 2014"}],"Grants" : [ ], "Teaching" : [{"Course" : "Machine Learning", Date: "2018 Fall"}, {"Course" : "Database Systems", "Date" : "2019 Spring"}]}, {"username" : "B", "name" : "2016csb1056", "email" : "2016csb1056@iitrpr.ac.in", "password" : "prerna","Overview": "Interested in MAchine Learning", "Publication" : [{"Date" : "2003", "Paper" : "Outlier Detection In Sensor Networks", "Conf" : "AdNet 2003 Conference, Mac Hill"}, {"Date" : "2004", "Paper" : "Wireless Body Area Networks", "Conf" : "IEEE 2004 Conference, Mac Hill"}], "Education" : [{ "Study" : "IIT Delhi B.Tech CSE", "Year" : "1998" },{ "Study" : "Waterloo Univrsity", "Year" : "2003"}],"Award" : [{"Title" : "Best IEEE Conference Paper", "Date" : "Sept 2017"}, {"Title" : "Best Doctorialship Award", "Date" : "May 2004"}],"Grants" : [ ], "Teaching" : [{"Course" : "Computer Networks", Date: "2018 Fall"}, {"Course" : "Ad-Hoc Networks", "Date" : "2019 Spring"}]}, {"username" : "c", "name" : "Mr. C", "email" : "c@iitrpr.ac.in", "password" : "12qwaszx","Overview": "Interested in Adhoc Networks", "Publication" : [{"Date" : "1998", "Paper" : "Learning to Learn", "Conf" : "ICML 2017 Conference, Mac Hill"}, {"Date" : "1998", "Paper" : "Meta Optimizer Auto Loss", "Conf" : "ICML 2018 Conference, Mac Hill"}], "Education" : [{ "Study" : "IIT Ropar B.Tech CSE", "Year" : "1998" },{ "Study" : "Waterloo Univrsity", "Year" : "2003"}],"Award" : [{"Title" : "Best IEEE Conference Paper", "Date" : "Sept 2017"}, {"Title" : "Best Doctorialship Award", "Date" : "May 2014"}],"Grants" : [ ], "Teaching" : [{"Course" : "Machine Learning", Date: "2018 Fall"}, {"Course" : "Database Systems", "Date" : "2019 Spring"}]}, {"username" : "d", "name" : "Mr. D", "email" : "d@iitrpr.ac.in", "password" : "12qwaszx","Overview": "Interested in MAchine Learning", "Publication" : [{"Date" : "1998", "Paper" : "Learning to Learn", "Conf" : "ICML 2017 Conference, Mac Hill"}, {"Date" : "1998", "Paper" : "Meta Optimizer Auto Loss", "Conf" : "ICML 2018 Conference, Mac Hill"}], "Education" : [{ "Study" : "IIT Ropar B.Tech CSE", "Year" : "1998" },{ "Study" : "Waterloo Univrsity", "Year" : "2003"}],"Award" : [{"Title" : "Best IEEE Conference Paper", "Date" : "Sept 2017"}, {"Title" : "Best Doctorialship Award", "Date" : "May 2014"}],"Grants" : [ ], "Teaching" : [{"Course" : "Machine Learning", Date: "2018 Fall"}, {"Course" : "Database Systems", "Date" : "2019 Spring"}]}, {"username" : "e", "name" : "Mr. E", "email" : "e@iitrpr.ac.in", "password" : "12qwaszx","Overview": "Interested in MAchine Learning", "Publication" : [{"Date" : "1998", "Paper" : "Learning to Learn", "Conf" : "ICML 2017 Conference, Mac Hill"}, {"Date" : "1998", "Paper" : "Meta Optimizer Auto Loss", "Conf" : "ICML 2018 Conference, Mac Hill"}], "Education" : [{ "Study" : "IIT Ropar B.Tech CSE", "Year" : "1998" },{ "Study" : "Waterloo Univrsity", "Year" : "2003"}],"Award" : [{"Title" : "Best IEEE Conference Paper", "Date" : "Sept 2017"}, {"Title" : "Best Doctorialship Award", "Date" : "May 2014"}],"Grants" : [ ], "Teaching" : [{"Course" : "Machine Learning", Date: "2018 Fall"}, {"Course" : "Database Systems", "Date" : "2019 Spring"}]}, {"username" : "f", "name" : "Mr. F", "email" : "f@iitrpr.ac.in", "password" : "12qwaszx","Overview": "Interested in MAchine Learning", "Publication" : [{"Date" : "1998", "Paper" : "Learning to Learn", "Conf" : "ICML 2017 Conference, Mac Hill"}, {"Date" : "1998", "Paper" : "Meta Optimizer Auto Loss", "Conf" : "ICML 2018 Conference, Mac Hill"}], "Education" : [{ "Study" : "IIT Ropar B.Tech CSE", "Year" : "1998" },{ "Study" : "Waterloo Univrsity", "Year" : "2003"}],"Award" : [{"Title" : "Best IEEE Conference Paper", "Date" : "Sept 2017"}, {"Title" : "Best Doctorialship Award", "Date" : "May 2014"}],"Grants" : [ ], "Teaching" : [{"Course" : "Machine Learning", Date: "2018 Fall"}, {"Course" : "Database Systems", "Date" : "2019 Spring"}]}