CIS 336 STUDY Career Begins/cis336study.com CIS 336 STUDY Career Begins/cis336study.com | Page 10

ADD CONSTRAINT devry _ studentcity _ fk FOREIGN KEY references city;

ALTER table DEVRY

ADD CONSTRAINT devry _ studentcity _ fk FOREIGN KEY( student _ city) references city;

ALTER table DEVRY

ADD CONSTRAINT FOREIGN KEY( student _ city) references city;

8.( TCO 7) Given a table named EMPLOYEE, the SQL command to sort records in a specific order would be:( Points: 4)

SELECT EMP _ LNAME, EMP _ FNAME, EMP _ INITIAL, EMP _ AREACODE, EMP _ PHONE

FROM EMPLOYEE LIST BY EMP _ LNAME, EMP _ FNAME, EMP _ INITIAL;

SELECT EMP _ LNAME, EMP _ FNAME, EMP _ INITIAL, EMP _ AREACODE, EMP _ PHONE

FROM EMPLOYEE

ORDER BY EMP _ LNAME, EMP _ FNAME, EMP _ INITIAL;

SELECT EMP _ LNAME, EMP _ FNAME, EMP _ INITIAL, EMP _ AREACODE, EMP _ PHONE