Category INF503

Other Links: Statistics Quiz Networking Quiz See other websites for quiz: Check on QUIZLET Check on CHEGG

Other Links: Statistics Quiz Networking Quiz See other websites for quiz: Check on QUIZLET Check on CHEGG

Other Links: Statistics Quiz Networking Quiz See other websites for quiz: Check on QUIZLET Check on CHEGG

Other Links: Statistics Quiz Networking Quiz See other websites for quiz: Check on QUIZLET Check on CHEGG

Other Links: Statistics Quiz Networking Quiz See other websites for quiz: Check on QUIZLET Check on CHEGG

Other Links: Statistics Quiz Networking Quiz See other websites for quiz: Check on QUIZLET Check on CHEGG

LAB 1 1) 2) 3) 4) 5) 6)  LAB-2 1)  2)  3) 4) 5) LAB-3 1)CREATE INDEX upper_ix ON EMPLOYEE_REC (UPPER(Lname)); 2)SELECT Fname, LnameFROM EMPLOYEE_RECWHERE UPPER(Lname)= “SMITH”; Other Links: Statistics Quiz Networking Quiz See other websites for quiz: Check on…

LAB-1 1. 2SELECT COUNT(DISTINCT Dnumber)FROM EMPLOYEE_REC E, EMPLOYEE_DEPARTMENT DWHERE D.Dnumber = E.Dno and E.Salary > 40000; 3SELECT COUNT(*)FROM EMPLOYEE_RECWHERE EMPLOYEE_REC.Dno NOT IN (SELECT EMPLOYEE_DEPARTMENT.DnumberFROM EMPLOYEE_DEPARTMENTWHERE Zipcode =30332); 4SELECT City FROM EMP_CUSTOMERSINTERSECTSELECT City FROM EMP_SUPPLIERSORDER BY City; LAB-2 1 2 LAB-3…

LAB-8 1. SELECT DISTINCT Pnumber, PnameFROM PROJECTWHERE  Pnumber IN(SELECT PnumberFROM PROJECT, EMPLOYEE_DEPARTMENT, EMPLOYEE_RECWHERE Dnum = Dnumber ANDMgr_ssn = Super_ssn AND Lname = ‘Zelaya’)ORPnumber IN(SELECT PnoFROM WORKS_ON, EMPLOYEE_RECWHERE Essn = Ssn AND Lname = ‘Smith’); 2. SELECT Lname, FnameFROM EMPLOYEE_RECWHERE Salary >…

1. CREATE TABLE EMPLOYEE_UC(Ssn VARCHAR(5) NOT NULL PRIMARY KEY,Fname VARCHAR(15) NOT NULL,Minit VARCHAR(15) NOT NULL,Lname VARCHAR(15) NOT NULL,Bdate DATE,Address VARCHAR(30),Gender CHAR,Salary Decimal(10,2),Age INT); 2. CREATE TABLE DEPARTMENT_UC(Dptname VARCHAR(15),Dptnmbr INT NOT NULL PRIMARY KEY,Mgr_ssn CHAR(9),Mgr_start_date DATE,Mgr_last_date DATE,Ssn VARCHAR(5) FOREIGN KEY REFERENCES…