GTBIT SQL QUERY
ITPROFESSIONALSROCKS.BLOGSPOT.COM ---2 QUESTION-- · Create a database named ‘ Employee’. · Use the database ‘Employee’ and create a table ‘Emp’ with attributes ‘ename’,’ecity’,’salary’,’enumber’,’eaddress’,’depttname’. · Create another table ‘Company’ with attributes ‘cname’,’ ccity’,’numberof emp’,’empnumber’ in the database ‘Employee’. create database employee use employee create table emp ( ename varchar(20),ecity varchar(20),salary float,enumber int,eaddres varchar(40),deptname varchar(20)); Create table Company ( cname varchar(20), ccity varchar(20),numberofemp int,empnumber int ) insert into emp values('hemant','delhi',500000,98993142,'karol bagh','techsolution'); insert into emp values('rajiv','delhi',300000,99999234,'moti nagar','finanace'); insert into emp values('raji','delhi',300000,99999234,'moti nagar','manager','finanace'); ins