O p of Q 18 SSN Fname Lname

  • Slides: 18
Download presentation

O / p of Q 18 SSN Fname Lname Dname 123456789 John Smith

O / p of Q 18 SSN Fname Lname Dname 123456789 John Smith Research 333445555 Franklin Wong Research 999887777 Alicia Zelaya administration 987654321 Jennifer Wallace administration 666884444 Ramesh Narayan Research 453453453 Joyce English Research 987987987 Ahmad Jabbar administration 888665555 James Borg Headquarters

Q 19 : Select SSN, Fname , Lname , Dname From Employee, Department Where

Q 19 : Select SSN, Fname , Lname , Dname From Employee, Department Where DNO = Dnumber AND Dname =‘administration’; O / p of Q 19 SSN Fname Lname Dname 999887777 Alicia Zelaya administration 987654321 Jennifer Wallace administration 987987987 Ahmad Jabbar administration

Q 21 : - Select * From Employee, Department Where DNO = Dnumber;

Q 21 : - Select * From Employee, Department Where DNO = Dnumber;

O / p of Q 21 Employee SSN 123456789 333445555 999887777 987654321 666884444

O / p of Q 21 Employee SSN 123456789 333445555 999887777 987654321 666884444 453453453 987987987 888665555 Fname MI Lname BDAT NIT E John B Smith 196501 -09 Franklin T Wong 195512 -08 Alicia J Zelaya 196801 -19 Jennifer S Wallace 194106 -20 Ramesh K Narayan 196209 -15 Joyce A English 197207 -31 Ahmad V Jabbar 196903 -29 James E Borg 193711 -10 ADDRESS SEX salary 731 fondren, Houton, tx 638 voss, houstong, tx M 30000 M 40000 3321 castle, spring, tx F 25000 291 berry, bellair, tx F 43000 975 fire oak, humble, tx 5631 rice, Houston, tx M 38000 F 25000 980 Dallas, Houston, tx M 25000 450 Stone, Houston, tx M 55000 Department DNAME Research Administration Headquarters DNUMBER 5 4 1 MGRSSN 333445555 987654321 888665555 MGRSTARTDATE 1988 -05 -22 1995 -01 -01 1981 -06 -19 Super SSN 33344555 5 88866555 5 98765432 1 88866555 5 33344555 5 98765432 1 Null DN O 5 5 4 4 5 5 4 1

O / p of Q 22 Employee SSN 123456789 333445555 999887777 987654321 666884444

O / p of Q 22 Employee SSN 123456789 333445555 999887777 987654321 666884444 453453453 987987987 888665555 Fname MI Lname BDAT NIT E John B Smith 196501 -09 Franklin T Wong 195512 -08 Alicia J Zelaya 196801 -19 Jennifer S Wallace 194106 -20 Ramesh K Narayan 196209 -15 Joyce A English 197207 -31 Ahmad V Jabbar 196903 -29 James E Borg 193711 -10 ADDRESS SEX salary 731 fondren, Houton, tx 638 voss, houstong, tx M 30000 M 40000 3321 castle, spring, tx F 25000 291 berry, bellair, tx F 43000 975 fire oak, humble, tx 5631 rice, Houston, tx M 38000 F 25000 980 Dallas, Houston, tx M 25000 450 Stone, Houston, tx M 55000 Department DNAME Research Administration Headquarters DNUMBER 5 4 1 MGRSSN 333445555 987654321 888665555 MGRSTARTDATE 1988 -05 -22 1995 -01 -01 1981 -06 -19 Super SSN 33344555 5 88866555 5 98765432 1 88866555 5 33344555 5 98765432 1 Null DN O 5 5 4 4 5 5 4 1

O / p of Q 23

O / p of Q 23

O / p of Q 24

O / p of Q 24

COMPANY schema EMPLOYEE FNAME MINIT LNAME SSN BDATECOMPANY schema EMPLOYEE FNAME MINIT LNAME SSN BDATE
q 1 Fname Minit Dno4 EMPLOYEE Lname Ssnq 1 Fname Minit Dno4 EMPLOYEE Lname Ssn
ERD 12 Fname Minit ER Lname Number NERD 12 Fname Minit ER Lname Number N
17 1 SQL 1 SQL SELECT LNAME FNAME17 1 SQL 1 SQL SELECT LNAME FNAME
ERD 12 Fname Minit ER Lname Number NERD 12 Fname Minit ER Lname Number N
public class Student private String AM Fname Lnamepublic class Student private String AM Fname Lname
Fname Minit Lname Number N Address Sex WORKSFORFname Minit Lname Number N Address Sex WORKSFOR
Fname Minit Lname Number N Address Sex WORKSFORFname Minit Lname Number N Address Sex WORKSFOR
ERD 12 Fname Minit ER Lname Number NERD 12 Fname Minit ER Lname Number N
La Medicina Legale nel SSN per il SSNLa Medicina Legale nel SSN per il SSN
CDM and SSN A winning combination SSN andCDM and SSN A winning combination SSN and
LSolved Fingerprint Analysis Developing Prints 3 20 LNameLSolved Fingerprint Analysis Developing Prints 3 20 LName
Joining Spreadsheet data in Excel LName Smith JohnsonJoining Spreadsheet data in Excel LName Smith Johnson
Example SET SERVEROUTPUT ON DECLARE lname VARCHAR 215Example SET SERVEROUTPUT ON DECLARE lname VARCHAR 215
public class Student private String AM Fname publicpublic class Student private String AM Fname public
Compterendu FNAME Ivan DARRAULT et JP KLEIN DansCompterendu FNAME Ivan DARRAULT et JP KLEIN Dans
order by where order by mysql select fnameorder by where order by mysql select fname