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