import cx_Oracle
con=cx_Oracle.connect('SYSTEM/user1@localhost/xe')
cur =con.cursor()



##############################################
###########   Vatika Girls Hostel  ###########
##############################################
cur.execute("drop table stu_attendance1")
cur.execute("drop table sta_attendance1")
cur.execute("drop table stu_details1")
cur.execute("drop table sta_details1")
cur.execute("drop table stuid1")
cur.execute("drop table staffid1")
cur.execute('''CREATE TABLE stuid1(STUSER_ID VARCHAR(30) primary key not null,
STU_PSWD VARCHAR(15) not null check(length(stu_pswd)>6))''')
cur.execute("insert into stuid1 values('500061354', 'Aish@21')")
cur.execute("insert into stuid1 values('500060649', 'abcd1234')")
cur.execute("insert into stuid1 values('500062317', 'mcnr9999')")
cur.execute("insert into stuid1 values('500062131', 'asis1008')")
cur.execute("insert into stuid1 values('500061358', 'chocolava')")
cur.execute("insert into stuid1 values('500061359', 'apple123')")
cur.execute("insert into stuid1 values('500061360', 'mango123')")
cur.execute("insert into stuid1 values('500061361', 'banana123')")
cur.execute("insert into stuid1 values('500061362', 'aaloobukhara')")
cur.execute("insert into stuid1 values('500061363', 'hihello')")
cur.execute("insert into stuid1 values('500061364', 'howareu')")
cur.execute("insert into stuid1 values('500061365', 'password')")
con.commit()
#cur.execute("select * from stuid1")
#print(cur.fetchall())
cur.execute('''CREATE TABLE staffid1(STASER_ID VARCHAR(30) primary key not null,
STA_PSWD VARCHAR(15) not null check(length(sta_pswd)>6))''')
cur.execute("insert into staffid1 values('500051354', '12345678')")
cur.execute("insert into staffid1 values('500050649', '12345678')")
cur.execute("insert into staffid1 values('500052317', '12345678')")
cur.execute("insert into staffid1 values('500052131', '12345678')")
cur.execute("insert into staffid1 values('500051358', '12345678')")
cur.execute("insert into staffid1 values('500051359', '12345678')")
cur.execute("insert into staffid1 values('500051360', '12345678')")
cur.execute("insert into staffid1 values('500051361', '12345678')")
cur.execute("insert into staffid1 values('500051362', '12345678')")
cur.execute("insert into staffid1 values('500051363', '12345678')")
cur.execute("insert into staffid1 values('500051364', '12345678')")
cur.execute("insert into staffid1 values('500051365', '12345678')")
con.commit()
#cur.execute("select * from staffid1")
#print(cur.fetchall())
cur.execute('''CREATE TABLE stu_attendance1(stu_id VARCHAR(15),
Days_present number(35), foreign key(stu_id) references stuid1(stuser_id))''')
cur.execute("insert into stu_attendance1 values('500061354', 20)")
cur.execute("insert into stu_attendance1 values('500060649', 19)")
cur.execute("insert into stu_attendance1 values('500062317', 19)")
cur.execute("insert into stu_attendance1 values('500062131', 18)")
cur.execute("insert into stu_attendance1 values('500061358', 17)")
cur.execute("insert into stu_attendance1 values('500061359', 19)")
cur.execute("insert into stu_attendance1 values('500061360', 14)")
cur.execute("insert into stu_attendance1 values('500061361', 19)")
cur.execute("insert into stu_attendance1 values('500061362', 17)")
cur.execute("insert into stu_attendance1 values('500061363', 18)")
cur.execute("insert into stu_attendance1 values('500061364', 19)")
cur.execute("insert into stu_attendance1 values('500061365', 19)")
con.commit()
#cur.execute("select * from stu_attendance1")
#print(cur.fetchall())
cur.execute('''CREATE TABLE sta_attendance1(STA_ID VARCHAR(30),
STA_present number(35), foreign key(sta_id) references staffid1(staser_id))''')
cur.execute("insert into sta_attendance1 values('500051354', 20)")
cur.execute("insert into sta_attendance1 values('500050649', 20)")
cur.execute("insert into sta_attendance1 values('500052317', 18)")
cur.execute("insert into sta_attendance1 values('500052131', 20)")
cur.execute("insert into sta_attendance1 values('500051358', 19)")
cur.execute("insert into sta_attendance1 values('500051359', 20)")
cur.execute("insert into sta_attendance1 values('500051360', 20)")
cur.execute("insert into sta_attendance1 values('500051361', 20)")
cur.execute("insert into sta_attendance1 values('500051362', 20)")
cur.execute("insert into sta_attendance1 values('500051363', 20)")
cur.execute("insert into sta_attendance1 values('500051364', 20)")
cur.execute("insert into sta_attendance1 values('500051365', 20)")
con.commit()
#cur.execute("select * from sta_attendance1")
#print(cur.fetchall())
cur.execute('''CREATE TABLE stu_details1(STUSER_ID VARCHAR(30),
STU_NAME VARCHAR(30), STU_ROOMNO INTEGER, foreign key(stuser_id) references stuid1(stuser_id))''')
cur.execute("insert into stu_details1 values('500061354', 'Aishwarya Sharma', 316)")
cur.execute("insert into stu_details1 values('500060649', 'Ishita Singhal', 315)")
cur.execute("insert into stu_details1 values('500062317', 'Ishika Singh', 210)")
cur.execute("insert into stu_details1 values('500062131', 'Garishma Virk', 306)")
cur.execute("insert into stu_details1 values('500061358', 'Lakshika Parihar', 317)")
cur.execute("insert into stu_details1 values('500061359', 'Vanshika Garg', 317)")
cur.execute("insert into stu_details1 values('500061360', 'Pratibha Arya', 315)")
cur.execute("insert into stu_details1 values('500061361', 'Vasundhara Garg', 223)")
cur.execute("insert into stu_details1 values('500061362', 'Vedanshi Garg', 317)")
cur.execute("insert into stu_details1 values('500061363', 'Srishti Uppal', 316)")
cur.execute("insert into stu_details1 values('500061364', 'Sri Sai Valli', 316)")
cur.execute("insert into stu_details1 values('500061365', 'Nandini Sood', 318)")
con.commit()
#cur.execute("select * from stu_details1")
#print(cur.fetchall())
cur.execute('''CREATE TABLE sta_details1(STASER_ID VARCHAR(30),
STA_NAME VARCHAR(30), sta_ROOMNO INTEGER, foreign key(STASER_ID) references staffid1(STASER_ID))''')
cur.execute("insert into sta_details1 values('500051354', 'Anita Banerji', 1)")
cur.execute("insert into sta_details1 values('500050649', 'Sushant Thakre',333)")
cur.execute("insert into sta_details1 values('500052317', 'Animesh Jha', 333)")
cur.execute("insert into sta_details1 values('500052131', 'Arvind Kalelkar', 333)")
cur.execute("insert into sta_details1 values('500051358', 'Preeti Zinta',1)")
cur.execute("insert into sta_details1 values('500051359', 'Gauranvi Jain', 2)")
cur.execute("insert into sta_details1 values('500051360', 'Madhvi Dixit',2)")
cur.execute("insert into sta_details1 values('500051361', 'Sunidhi Chauhan', 3)")
cur.execute("insert into sta_details1 values('500051362', 'Drizza Khan', 3)")
cur.execute("insert into sta_details1 values('500051363', 'Susan Paul',4)")
cur.execute("insert into sta_details1 values('500051364', 'Amrita Singh',4)")
cur.execute("insert into sta_details1 values('500051365', 'Ashmeet Sharma',4)")
con.commit()
#cur.execute("select * from sta_details1")
#print(cur.fetchall())





##############################################
###########   Vatika Boys Hostel  ###########
##############################################
cur.execute("drop table stu_attendance2")
cur.execute("drop table sta_attendance2")
cur.execute("drop table stu_details2")
cur.execute("drop table sta_details2")
cur.execute("drop table stuid2")
cur.execute("drop table staffid2")
cur.execute('''CREATE TABLE stuid2(STUSER_ID VARCHAR(30) primary key not null,
STU_PSWD VARCHAR(15) not null check(length(stu_pswd)>6))''')
cur.execute("insert into stuid2 values('500061354', 'Aish@21')")
cur.execute("insert into stuid2 values('500060649', 'abcd1234')")
cur.execute("insert into stuid2 values('500062317', 'mcnr9999')")
cur.execute("insert into stuid2 values('500062131', 'asis1008')")
cur.execute("insert into stuid2 values('500061358', 'chocolava')")
cur.execute("insert into stuid2 values('500061359', 'apple123')")
cur.execute("insert into stuid2 values('500061360', 'mango123')")
cur.execute("insert into stuid2 values('500061361', 'banana123')")
cur.execute("insert into stuid2 values('500061362', 'aaloobukhara')")
cur.execute("insert into stuid2 values('500061363', 'hihello')")
cur.execute("insert into stuid2 values('500061364', 'howareu')")
cur.execute("insert into stuid2 values('500061365', 'password')")
con.commit()
#cur.execute("select * from stuid2")
#print(cur.fetchall())
cur.execute('''CREATE TABLE staffid2(STASER_ID VARCHAR(30) primary key not null,
STA_PSWD VARCHAR(15) not null check(length(sta_pswd)>6))''')
cur.execute("insert into staffid2 values('500051354', '12345678')")
cur.execute("insert into staffid2 values('500050649', '12345678')")
cur.execute("insert into staffid2 values('500052317', '12345678')")
cur.execute("insert into staffid2 values('500052131', '12345678')")
cur.execute("insert into staffid2 values('500051358', '12345678')")
cur.execute("insert into staffid2 values('500051359', '12345678')")
cur.execute("insert into staffid2 values('500051360', '12345678')")
cur.execute("insert into staffid2 values('500051361', '12345678')")
cur.execute("insert into staffid2 values('500051362', '12345678')")
cur.execute("insert into staffid2 values('500051363', '12345678')")
cur.execute("insert into staffid2 values('500051364', '12345678')")
cur.execute("insert into staffid2 values('500051365', '12345678')")
con.commit()
#cur.execute("select * from staffid2")
#print(cur.fetchall())
cur.execute('''CREATE TABLE stu_attendance2(stu_id VARCHAR(15),
Days_present number(35), foreign key(stu_id) references stuid2(stuser_id))''')
cur.execute("insert into stu_attendance2 values('500061354', 20)")
cur.execute("insert into stu_attendance2 values('500060649', 19)")
cur.execute("insert into stu_attendance2 values('500062317', 19)")
cur.execute("insert into stu_attendance2 values('500062131', 18)")
cur.execute("insert into stu_attendance2 values('500061358', 17)")
cur.execute("insert into stu_attendance2 values('500061359', 19)")
cur.execute("insert into stu_attendance2 values('500061360', 14)")
cur.execute("insert into stu_attendance2 values('500061361', 19)")
cur.execute("insert into stu_attendance2 values('500061362', 17)")
cur.execute("insert into stu_attendance2 values('500061363', 18)")
cur.execute("insert into stu_attendance2 values('500061364', 19)")
cur.execute("insert into stu_attendance2 values('500061365', 19)")
con.commit()
#cur.execute("select * from stu_attendance2")
#print(cur.fetchall())
cur.execute('''CREATE TABLE sta_attendance2(STA_ID VARCHAR(30),
STA_present number(35), foreign key(sta_id) references staffid2(staser_id))''')
cur.execute("insert into sta_attendance2 values('500051354', 20)")
cur.execute("insert into sta_attendance2 values('500050649', 20)")
cur.execute("insert into sta_attendance2 values('500052317', 18)")
cur.execute("insert into sta_attendance2 values('500052131', 20)")
cur.execute("insert into sta_attendance2 values('500051358', 19)")
cur.execute("insert into sta_attendance2 values('500051359', 20)")
cur.execute("insert into sta_attendance2 values('500051360', 20)")
cur.execute("insert into sta_attendance2 values('500051361', 20)")
cur.execute("insert into sta_attendance2 values('500051362', 20)")
cur.execute("insert into sta_attendance2 values('500051363', 20)")
cur.execute("insert into sta_attendance2 values('500051364', 20)")
cur.execute("insert into sta_attendance2 values('500051365', 20)")
con.commit()
#cur.execute("select * from sta_attendance2")
#print(cur.fetchall())
cur.execute('''CREATE TABLE stu_details2(STUSER_ID VARCHAR(30),
STU_NAME VARCHAR(30), STU_ROOMNO INTEGER, foreign key(stuser_id) references stuid2(stuser_id))''')
cur.execute("insert into stu_details2 values('500061354', 'Daksh Sharma', 316)")
cur.execute("insert into stu_details2 values('500060649', 'Prateek Singhal', 315)")
cur.execute("insert into stu_details2 values('500062317', 'Vishwas Singh', 210)")
cur.execute("insert into stu_details2 values('500062131', 'Sarthak Virk', 306)")
cur.execute("insert into stu_details2 values('500061358', 'Laksh Parihar', 317)")
cur.execute("insert into stu_details2 values('500061359', 'Daksh Garg', 317)")
cur.execute("insert into stu_details2 values('500061360', 'Pranabh Arya', 315)")
cur.execute("insert into stu_details2 values('500061361', 'Vaasu Garg', 223)")
cur.execute("insert into stu_details2 values('500061362', 'Vedansh Garg', 317)")
cur.execute("insert into stu_details2 values('500061363', 'Srishtham Uppal', 316)")
cur.execute("insert into stu_details2 values('500061364', ' Gaurang Trivedi', 316)")
cur.execute("insert into stu_details2 values('500061365', 'Navdeesh Araya', 318)")
con.commit()
#cur.execute("select * from stu_details2")
#print(cur.fetchall())
cur.execute('''CREATE TABLE sta_details2(STASER_ID VARCHAR(30),
STA_NAME VARCHAR(30), sta_ROOMNO INTEGER, foreign key(STASER_ID) references staffid2(STASER_ID))''')
cur.execute("insert into sta_details2 values('500051354', 'Mukesh Banerji', 1)")
cur.execute("insert into sta_details2 values('500050649', 'Sushant Thakre',333)")
cur.execute("insert into sta_details2 values('500052317', 'Animesh Jha', 333)")
cur.execute("insert into sta_details2 values('500052131', 'Arvind Kalelkar', 333)")
cur.execute("insert into sta_details2 values('500051358', 'Pranav Zinta',1)")
cur.execute("insert into sta_details2 values('500051359', 'Gaurav Jain', 2)")
cur.execute("insert into sta_details2 values('500051360', 'Madhav Dixit',2)")
cur.execute("insert into sta_details2 values('500051361', 'Sashank Chauhan', 3)")
cur.execute("insert into sta_details2 values('500051362', 'Drizz Khan', 3)")
cur.execute("insert into sta_details2 values('500051363', 'Sushant Paul',4)")
cur.execute("insert into sta_details2 values('500051364', 'Amit Solanki',4)")
cur.execute("insert into sta_details2 values('500051365', 'Deeghambar Solanki',4)")
con.commit()
#cur.execute("select * from sta_details2")
#print(cur.fetchall())
##############################################
###########   Aman Residency ###########
##############################################
#cur.execute("drop table stu_attendance3")
#cur.execute("drop table sta_attendance3")
#cur.execute("drop table stu_details3")
#cur.execute("drop table sta_details3")
#cur.execute("drop table stuid3")
#cur.execute("drop table staffid3")
cur.execute('''CREATE TABLE stuid3(STUSER_ID VARCHAR(30) primary key not null,
STU_PSWD VARCHAR(15) not null check(length(stu_pswd)>6))''')
cur.execute("insert into stuid3 values('500061354', 'Aish@21')")
cur.execute("insert into stuid3 values('500060649', 'abcd1234')")
cur.execute("insert into stuid3 values('500062317', 'mcnr9999')")
cur.execute("insert into stuid3 values('500062131', 'asis1008')")
cur.execute("insert into stuid3 values('500061358', 'chocolava')")
cur.execute("insert into stuid3 values('500061359', 'apple123')")
cur.execute("insert into stuid3 values('500061360', 'mango123')")
cur.execute("insert into stuid3 values('500061361', 'banana123')")
cur.execute("insert into stuid3 values('500061362', 'aaloobukhara')")
cur.execute("insert into stuid3 values('500061363', 'hihello')")
cur.execute("insert into stuid3 values('500061364', 'howareu')")
cur.execute("insert into stuid3 values('500061365', 'password')")
con.commit()
#cur.execute("select * from stuid3")
#print(cur.fetchall())
cur.execute('''CREATE TABLE staffid3(STASER_ID VARCHAR(30) primary key not null,
STA_PSWD VARCHAR(15) not null check(length(sta_pswd)>6))''')
cur.execute("insert into staffid3 values('500051354', '12345678')")
cur.execute("insert into staffid3 values('500050649', '12345678')")
cur.execute("insert into staffid3 values('500052317', '12345678')")
cur.execute("insert into staffid3 values('500052131', '12345678')")
cur.execute("insert into staffid3 values('500051358', '12345678')")
cur.execute("insert into staffid3 values('500051359', '12345678')")
cur.execute("insert into staffid3 values('500051360', '12345678')")
cur.execute("insert into staffid3 values('500051361', '12345678')")
cur.execute("insert into staffid3 values('500051362', '12345678')")
cur.execute("insert into staffid3 values('500051363', '12345678')")
cur.execute("insert into staffid3 values('500051364', '12345678')")
cur.execute("insert into staffid3 values('500051365', '12345678')")
con.commit()
#cur.execute("select * from staffid3")
#print(cur.fetchall())
cur.execute('''CREATE TABLE stu_attendance3(stu_id VARCHAR(15),
Days_present number(35), foreign key(stu_id) references stuid1(stuser_id))''')
cur.execute("insert into stu_attendance3 values('500061354', 20)")
cur.execute("insert into stu_attendance3 values('500060649', 19)")
cur.execute("insert into stu_attendance3 values('500062317', 19)")
cur.execute("insert into stu_attendance3 values('500062131', 18)")
cur.execute("insert into stu_attendance3 values('500061358', 17)")
cur.execute("insert into stu_attendance3 values('500061359', 19)")
cur.execute("insert into stu_attendance3 values('500061360', 14)")
cur.execute("insert into stu_attendance3 values('500061361', 19)")
cur.execute("insert into stu_attendance3 values('500061362', 17)")
cur.execute("insert into stu_attendance3 values('500061363', 18)")
cur.execute("insert into stu_attendance3 values('500061364', 19)")
cur.execute("insert into stu_attendance3 values('500061365', 19)")
con.commit()
#cur.execute("select * from stu_attendance3")
#print(cur.fetchall())
cur.execute('''CREATE TABLE sta_attendance3(STA_ID VARCHAR(30),
STA_present number(35), foreign key(sta_id) references staffid1(staser_id))''')
cur.execute("insert into sta_attendance3 values('500051354', 20)")
cur.execute("insert into sta_attendance3 values('500050649', 20)")
cur.execute("insert into sta_attendance3 values('500052317', 18)")
cur.execute("insert into sta_attendance3 values('500052131', 20)")
cur.execute("insert into sta_attendance3 values('500051358', 19)")
cur.execute("insert into sta_attendance3 values('500051359', 20)")
cur.execute("insert into sta_attendance3 values('500051360', 20)")
cur.execute("insert into sta_attendance3 values('500051361', 20)")
cur.execute("insert into sta_attendance3 values('500051362', 20)")
cur.execute("insert into sta_attendance3 values('500051363', 20)")
cur.execute("insert into sta_attendance3 values('500051364', 20)")
cur.execute("insert into sta_attendance3 values('500051365', 20)")
con.commit()
#cur.execute("select * from sta_attendance3")
#print(cur.fetchall())
cur.execute('''CREATE TABLE stu_details3(STUSER_ID VARCHAR(30),
STU_NAME VARCHAR(30), STU_ROOMNO INTEGER, foreign key(stuser_id) references stuid1(stuser_id))''')
cur.execute("insert into stu_details3 values('500061354', 'Abhinav Sharma', 316)")
cur.execute("insert into stu_details3 values('500060649', 'Ishaan Singhal', 315)")
cur.execute("insert into stu_details3 values('500062317', 'Ishant Singh', 210)")
cur.execute("insert into stu_details3 values('500062131', 'Gaurav Virk', 306)")
cur.execute("insert into stu_details3 values('500061358', 'Lakshay Parihar', 317)")
cur.execute("insert into stu_details3 values('500061359', 'Vansh Garg', 317)")
cur.execute("insert into stu_details3 values('500061360', 'Prateek Arya', 315)")
cur.execute("insert into stu_details3 values('500061361', 'Vasu Garg', 223)")
cur.execute("insert into stu_details3 values('500061362', 'Vedansh Garg', 317)")
cur.execute("insert into stu_details3 values('500061363', 'Sriyansh Uppal', 316)")
cur.execute("insert into stu_details3 values('500061364', 'Sri Samarth Valli', 316)")
cur.execute("insert into stu_details3 values('500061365', 'Nandan Sood', 318)")
con.commit()
#cur.execute("select * from stu_details3")
#print(cur.fetchall())
cur.execute('''CREATE TABLE sta_details3(STASER_ID VARCHAR(30),
STA_NAME VARCHAR(30), sta_ROOMNO INTEGER, foreign key(STASER_ID) references staffid1(STASER_ID))''')
cur.execute("insert into sta_details3 values('500051354', 'Anita Banerji', 1)")
cur.execute("insert into sta_details3 values('500050649', 'Sushant Thakre',333)")
cur.execute("insert into sta_details3 values('500052317', 'Animesh Jha', 333)")
cur.execute("insert into sta_details3 values('500052131', 'Arvind Kalelkar', 333)")
cur.execute("insert into sta_details3 values('500051358', 'Preeti Zinta',1)")
cur.execute("insert into sta_details3 values('500051359', 'Gauranvi Jain', 2)")
cur.execute("insert into sta_details3 values('500051360', 'Madhvi Dixit',2)")
cur.execute("insert into sta_details3 values('500051361', 'Sunidhi Chauhan', 3)")
cur.execute("insert into sta_details3 values('500051362', 'Drizza Khan', 3)")
cur.execute("insert into sta_details3 values('500051363', 'Susan Paul',4)")
cur.execute("insert into sta_details3 values('500051364', 'Amrita Singh',4)")
cur.execute("insert into sta_details3 values('500051365', 'Ashmeet Sharma',4)")
con.commit()
#cur.execute("select * from sta_details3")
#print(cur.fetchall())
##############################################
###########   Sarthak Boys Hostel  ###########
##############################################
#cur.execute("drop table stu_attendance4")
#cur.execute("drop table sta_attendance4")
#cur.execute("drop table stu_details4")
#cur.execute("drop table sta_details4")
#cur.execute("drop table stuid4")
#cur.execute("drop table staffid4")
cur.execute('''CREATE TABLE stuid4(STUSER_ID VARCHAR(30) primary key not null,
STU_PSWD VARCHAR(15) not null check(length(stu_pswd)>6))''')
cur.execute("insert into stuid4 values('500061354', 'Aish@21')")
cur.execute("insert into stuid4 values('500060649', 'abcd1234')")
cur.execute("insert into stuid4 values('500062317', 'mcnr9999')")
cur.execute("insert into stuid4 values('500062131', 'asis1008')")
cur.execute("insert into stuid4 values('500061358', 'chocolava')")
cur.execute("insert into stuid4 values('500061359', 'apple123')")
cur.execute("insert into stuid4 values('500061360', 'mango123')")
cur.execute("insert into stuid4 values('500061361', 'banana123')")
cur.execute("insert into stuid4 values('500061362', 'aaloobukhara')")
cur.execute("insert into stuid4 values('500061363', 'hihello')")
cur.execute("insert into stuid4 values('500061364', 'howareu')")
cur.execute("insert into stuid4 values('500061365', 'password')")
con.commit()
#cur.execute("select * from stuid4")
#print(cur.fetchall())
cur.execute('''CREATE TABLE staffid4(STASER_ID VARCHAR(30) primary key not null,
STA_PSWD VARCHAR(15) not null check(length(sta_pswd)>6))''')
cur.execute("insert into staffid4 values('500051354', '12345678')")
cur.execute("insert into staffid4 values('500050649', '12345678')")
cur.execute("insert into staffid4 values('500052317', '12345678')")
cur.execute("insert into staffid4 values('500052131', '12345678')")
cur.execute("insert into staffid4 values('500051358', '12345678')")
cur.execute("insert into staffid4 values('500051359', '12345678')")
cur.execute("insert into staffid4 values('500051360', '12345678')")
cur.execute("insert into staffid4 values('500051361', '12345678')")
cur.execute("insert into staffid4 values('500051362', '12345678')")
cur.execute("insert into staffid4 values('500051363', '12345678')")
cur.execute("insert into staffid4 values('500051364', '12345678')")
cur.execute("insert into staffid4 values('500051365', '12345678')")
con.commit()
#cur.execute("select * from staffid4")
#print(cur.fetchall())
cur.execute('''CREATE TABLE stu_attendance4(stu_id VARCHAR(15),
Days_present number(35), foreign key(stu_id) references stuid1(stuser_id))''')
cur.execute("insert into stu_attendance4 values('500061354', 20)")
cur.execute("insert into stu_attendance4 values('500060649', 19)")
cur.execute("insert into stu_attendance4 values('500062317', 19)")
cur.execute("insert into stu_attendance4 values('500062131', 18)")
cur.execute("insert into stu_attendance4 values('500061358', 17)")
cur.execute("insert into stu_attendance4 values('500061359', 19)")
cur.execute("insert into stu_attendance4 values('500061360', 14)")
cur.execute("insert into stu_attendance4 values('500061361', 19)")
cur.execute("insert into stu_attendance4 values('500061362', 17)")
cur.execute("insert into stu_attendance4 values('500061363', 18)")
cur.execute("insert into stu_attendance4 values('500061364', 19)")
cur.execute("insert into stu_attendance4 values('500061365', 19)")
con.commit()
#cur.execute("select * from stu_attendance4")
#print(cur.fetchall())
cur.execute('''CREATE TABLE sta_attendance4(STA_ID VARCHAR(30),
STA_present number(35), foreign key(sta_id) references staffid1(staser_id))''')
cur.execute("insert into sta_attendance4 values('500051354', 20)")
cur.execute("insert into sta_attendance4 values('500050649', 20)")
cur.execute("insert into sta_attendance4 values('500052317', 18)")
cur.execute("insert into sta_attendance4 values('500052131', 20)")
cur.execute("insert into sta_attendance4 values('500051358', 19)")
cur.execute("insert into sta_attendance4 values('500051359', 20)")
cur.execute("insert into sta_attendance4 values('500051360', 20)")
cur.execute("insert into sta_attendance4 values('500051361', 20)")
cur.execute("insert into sta_attendance4 values('500051362', 20)")
cur.execute("insert into sta_attendance4 values('500051363', 20)")
cur.execute("insert into sta_attendance4 values('500051364', 20)")
cur.execute("insert into sta_attendance4 values('500051365', 20)")
con.commit()
#cur.execute("select * from sta_attendance4")
#print(cur.fetchall())
cur.execute('''CREATE TABLE stu_details4(STUSER_ID VARCHAR(30),
STU_NAME VARCHAR(30), STU_ROOMNO INTEGER, foreign key(stuser_id) references stuid1(stuser_id))''')
cur.execute("insert into stu_details4 values('500061354', 'Aishwarya Sharma', 316)")
cur.execute("insert into stu_details4 values('500060649', 'Ishita Singhal', 315)")
cur.execute("insert into stu_details4 values('500062317', 'Ishika Singh', 210)")
cur.execute("insert into stu_details4 values('500062131', 'Garishma Virk', 306)")
cur.execute("insert into stu_details4 values('500061358', 'Lakshika Parihar', 317)")
cur.execute("insert into stu_details4 values('500061359', 'Vanshika Garg', 317)")
cur.execute("insert into stu_details4 values('500061360', 'Pratibha Arya', 315)")
cur.execute("insert into stu_details4 values('500061361', 'Vasundhara Garg', 223)")
cur.execute("insert into stu_details4 values('500061362', 'Vedanshi Garg', 317)")
cur.execute("insert into stu_details4 values('500061363', 'Srishti Uppal', 316)")
cur.execute("insert into stu_details4 values('500061364', 'Sri Sai Valli', 316)")
cur.execute("insert into stu_details4 values('500061365', 'Nandini Sood', 318)")
con.commit()
#cur.execute("select * from stu_details4")
#print(cur.fetchall())
cur.execute('''CREATE TABLE sta_details4(STASER_ID VARCHAR(30),
STA_NAME VARCHAR(30), sta_ROOMNO INTEGER, foreign key(STASER_ID) references staffid1(STASER_ID))''')
cur.execute("insert into sta_details4 values('500051354', 'Anil Banerji', 1)")
cur.execute("insert into sta_details4 values('500050649', 'Sushant Thakre',333)")
cur.execute("insert into sta_details4 values('500052317', 'Animesh Jha', 333)")
cur.execute("insert into sta_details4 values('500052131', 'Arvind Kalelkar', 333)")
cur.execute("insert into sta_details4 values('500051358', 'Pranay Zinta',1)")
cur.execute("insert into sta_details4 values('500051359', 'Gaurav Jain', 2)")
cur.execute("insert into sta_details4 values('500051360', 'Madhav Dixit',2)")
cur.execute("insert into sta_details4 values('500051361', 'Sumit Chauhan', 3)")
cur.execute("insert into sta_details4 values('500051362', 'Drizz Khan', 3)")
cur.execute("insert into sta_details4 values('500051363', 'Suryansh Paul',4)")
cur.execute("insert into sta_details4 values('500051364', 'Amit  Singh',4)")
cur.execute("insert into sta_details4 values('500051365', 'Ashmeet Sharma',4)")
con.commit()
#cur.execute("select * from sta_details4")
#print(cur.fetchall())
##############################################
###########   Pride Girls Hostel  ###########  7060030972
##############################################
#cur.execute("drop table stu_attendance5")
#cur.execute("drop table sta_attendance5")
#cur.execute("drop table stu_details5")
#cur.execute("drop table sta_details5")
#cur.execute("drop table stuid5")
#cur.execute("drop table staffid5")
cur.execute('''CREATE TABLE stuid5(STUSER_ID VARCHAR(30) primary key not null,
STU_PSWD VARCHAR(15) not null check(length(stu_pswd)>6))''')
cur.execute("insert into stuid5 values('500061354', 'Aish@21')")
cur.execute("insert into stuid5 values('500060649', 'abcd1234')")
cur.execute("insert into stuid5 values('500062317', 'mcnr9999')")
cur.execute("insert into stuid5 values('500062131', 'asis1008')")
cur.execute("insert into stuid5 values('500061358', 'chocolava')")
cur.execute("insert into stuid5 values('500061359', 'apple123')")
cur.execute("insert into stuid5 values('500061360', 'mango123')")
cur.execute("insert into stuid5 values('500061361', 'banana123')")
cur.execute("insert into stuid5 values('500061362', 'aaloobukhara')")
cur.execute("insert into stuid5 values('500061363', 'hihello')")
cur.execute("insert into stuid5 values('500061364', 'howareu')")
cur.execute("insert into stuid5 values('500061365', 'password')")
con.commit()
#cur.execute("select * from stuid5")
#print(cur.fetchall())
cur.execute('''CREATE TABLE staffid5(STASER_ID VARCHAR(30) primary key not null,
STA_PSWD VARCHAR(15) not null check(length(sta_pswd)>6))''')
cur.execute("insert into staffid5 values('500051354', '12345678')")
cur.execute("insert into staffid5 values('500050649', '12345678')")
cur.execute("insert into staffid5 values('500052317', '12345678')")
cur.execute("insert into staffid5 values('500052131', '12345678')")
cur.execute("insert into staffid5 values('500051358', '12345678')")
cur.execute("insert into staffid5 values('500051359', '12345678')")
cur.execute("insert into staffid5 values('500051360', '12345678')")
cur.execute("insert into staffid5 values('500051361', '12345678')")
cur.execute("insert into staffid5 values('500051362', '12345678')")
cur.execute("insert into staffid5 values('500051363', '12345678')")
cur.execute("insert into staffid5 values('500051364', '12345678')")
cur.execute("insert into staffid5 values('500051365', '12345678')")
con.commit()
#cur.execute("select * from staffid5")
#print(cur.fetchall())
cur.execute('''CREATE TABLE stu_attendance5(stu_id VARCHAR(15),
Days_present number(35), foreign key(stu_id) references stuid1(stuser_id))''')
cur.execute("insert into stu_attendance5 values('500061354', 20)")
cur.execute("insert into stu_attendance5 values('500060649', 19)")
cur.execute("insert into stu_attendance5 values('500062317', 19)")
cur.execute("insert into stu_attendance5 values('500062131', 18)")
cur.execute("insert into stu_attendance5 values('500061358', 17)")
cur.execute("insert into stu_attendance5 values('500061359', 19)")
cur.execute("insert into stu_attendance5 values('500061360', 14)")
cur.execute("insert into stu_attendance5 values('500061361', 19)")
cur.execute("insert into stu_attendance5 values('500061362', 17)")
cur.execute("insert into stu_attendance5 values('500061363', 18)")
cur.execute("insert into stu_attendance5 values('500061364', 19)")
cur.execute("insert into stu_attendance5 values('500061365', 19)")
con.commit()
#cur.execute("select * from stu_attendance5")
#print(cur.fetchall())
cur.execute('''CREATE TABLE sta_attendance5(STA_ID VARCHAR(30),
STA_present number(35), foreign key(sta_id) references staffid1(staser_id))''')
cur.execute("insert into sta_attendance5 values('500051354', 20)")
cur.execute("insert into sta_attendance5 values('500050649', 20)")
cur.execute("insert into sta_attendance5 values('500052317', 18)")
cur.execute("insert into sta_attendance5 values('500052131', 20)")
cur.execute("insert into sta_attendance5 values('500051358', 19)")
cur.execute("insert into sta_attendance5 values('500051359', 20)")
cur.execute("insert into sta_attendance5 values('500051360', 20)")
cur.execute("insert into sta_attendance5 values('500051361', 20)")
cur.execute("insert into sta_attendance5 values('500051362', 20)")
cur.execute("insert into sta_attendance5 values('500051363', 20)")
cur.execute("insert into sta_attendance5 values('500051364', 20)")
cur.execute("insert into sta_attendance5 values('500051365', 20)")
con.commit()
#cur.execute("select * from sta_attendance5")
#print(cur.fetchall())
cur.execute('''CREATE TABLE stu_details5(STUSER_ID VARCHAR(30),
STU_NAME VARCHAR(30), STU_ROOMNO INTEGER, foreign key(stuser_id) references stuid1(stuser_id))''')
cur.execute("insert into stu_details5 values('500061354', 'Aishwarya Sharma', 316)")
cur.execute("insert into stu_details5 values('500060649', 'Ishita Singhal', 315)")
cur.execute("insert into stu_details5 values('500062317', 'Ishika Singh', 210)")
cur.execute("insert into stu_details5 values('500062131', 'Garishma Virk', 306)")
cur.execute("insert into stu_details5 values('500061358', 'Lakshika Parihar', 317)")
cur.execute("insert into stu_details5 values('500061359', 'Vanshika Garg', 317)")
cur.execute("insert into stu_details5 values('500061360', 'Pratibha Arya', 315)")
cur.execute("insert into stu_details5 values('500061361', 'Vasundhara Garg', 223)")
cur.execute("insert into stu_details5 values('500061362', 'Vedanshi Garg', 317)")
cur.execute("insert into stu_details5 values('500061363', 'Srishti Uppal', 316)")
cur.execute("insert into stu_details5 values('500061364', 'Sri Sai Valli', 316)")
cur.execute("insert into stu_details5 values('500061365', 'Nandini Sood', 318)")
con.commit()
#cur.execute("select * from stu_details5")
#print(cur.fetchall())
cur.execute('''CREATE TABLE sta_details5(STASER_ID VARCHAR(30),
STA_NAME VARCHAR(30), sta_ROOMNO INTEGER, foreign key(STASER_ID) references staffid1(STASER_ID))''')
cur.execute("insert into sta_details5 values('500051354', 'Ankita Desai', 1)")
cur.execute("insert into sta_details5 values('500050649', 'Sonu Nigam',333)")
cur.execute("insert into sta_details5 values('500052317', 'Arijit Singh', 333)")
cur.execute("insert into sta_details5 values('500052131', 'Justin Beiber', 333)")
cur.execute("insert into sta_details5 values('500051358', 'Palak Mucchal',1)")
cur.execute("insert into sta_details5 values('500051359', 'Mohit Gaur', 2)")
cur.execute("insert into sta_details5 values('500051360', 'Madhuri Dixit',2)")
cur.execute("insert into sta_details5 values('500051361', 'Sunidhi Chauhan', 3)")
cur.execute("insert into sta_details5 values('500051362', 'Honey Singh', 3)")
cur.execute("insert into sta_details5 values('500051363', 'Baadshah',4)")
cur.execute("insert into sta_details5 values('500051364', 'Atif Aslam',4)")
cur.execute("insert into sta_details5 values('500051365', 'Javed Ali',4)")
con.commit()
#cur.execute("select * from sta_details5")
#print(cur.fetchall())


con.close()
