structured query language
RAMESHWAR NAGODE DBSchoolManagement Practical createtable tblDepartment ( Deptid intprimarykey , DeptName varchar ( 50 )) insertinto tblDepartment values ( 1 , 'BCs' ); insertinto tblDepartment values ( 2 , 'MCs' ); insertinto tblDepartment values ( 3 , 'MCA' ); select * from tblDepartment createtable tblTeachers ( Teachid int , TName varchar ( 50 ), Tsalary money , TPhone varchar ( 15 ), JoinD varchar ( 15 ), Deptid intforeignkeyreferences tblDepartment ( Deptid )); insertinto tblTeachers values ( 1 , 'Sandeep Nagaode' , 100000 , '8888080407' , '07/02/2016' , 1 ) insertinto tblTeachers values ( 2 , 'Gitanjali Nagode' , 100000 , '8888080401' , '07/02/2017' , 1 ) insertinto tblTeachers values ( 3 , 'Kiran Supekar' , 50000 , '775774697' , '07/02/2018' , 2 ) insertinto tblTeachers values ( 4 , 'Sanket Nagode' , 12000 , ...