Using the attached image of a relationship between the two entities, faculty and student, and the instances shown in the tables for both, identify the faculty member who has no advisees. 2 Start Page MidTerm Exam 6 Relational_1 (Untitled_1) CIS25501STUDENT PS ID SLAST S FIRST S_MI SADDRESS SCITY S STATE S ZIP S_PHONE 5_CLASS S_DOB S_PIN F VARCHAR2 (6 BYTE VARCHAR2 (30 BYTE VARCHAR2 (30 BYTE CHAR (1 BYTE VARCHAR2 (25 BYTE) CIS25501FACULTY P FID F_LAST F_FIRST F_MI F_PHONE VARCHAR2 (10 BYTE F_RANK FSUPER FPIN FACULTY_F_ID_PK (F_ID) O FACULTY_F_ID PK (F_ID) NUMBER (6) VARCHAR2 (30 BYTE VARCHAR2 (30 BYTE CHAR (1 BYTE VARCHAR2 (20 BYTE) CHAR (2 BYTE VARCHAR2 (10 BYTE VARCHAR2 (10 BYTE CHAR (2 BYTE DATE NUMBER (4) VARCHAR2 (9 BYTE) NUMBER (6) NUMBER (4) FID TIME ENROLLED NUMBER (6) INTERVAL YEAR TO MONTH STUDENT S_ID_PK (S_ID) Script Output x DQuery Result x STUDENT_F_ID_FK (F_ID) *A a SQL | All Rows Fetched: 5 in 0.74 seconds F_ID F_LAST O F_FIRST F_MI F_PHONE F_RANK 1 Marx 2 Zhulin Mark 3 Langley Colin O STUDENT S_ID PK (S_ID) F_SUPER F_PIN 1 Teresa J 4075921695 Associate 4. 6338 M 4073875682 Full (null) 1121 3 A 4075928719 Assistant 4 9871 4 4 Brown Jonnel D 4078101155 Full (null) 8297 5 Sealy James 4079817153 Associate 1 6089 5 L |Script Output x DQuery Result x A A R sQL SQL | All Rows Fetched: 6 in 0.759 seconds O5 IDS LASTOS FIRSTOS MI S ADDRESS 1 J0100 Jones Tammy R 2 PE100 Perez }5_CITY S_STATE S_ZIP s_PHONE S_CLASSS_DOB S_PIN F_ID TIME_ENROLLED 1 +03-02 1817 Eagleridge Circle Tallahassee FL 32811 7155559876 SR 14-JUL-85 8891 1 +04-02 1 +03-00 Jorge 951 Rainbow Dr Clermont FL 34711 7155552345 SR 19-AUG-85 1230 3 MA100 Marsh 1275 West Main St Carrabelle FL John A 32320 7155553907 JR 10-0СТ-82 1613 4 SM100 Smith Mike (null) 428 Markson Ave Eastpoint FL 32328 7155556902 so 24-SEP-86 1841 2 +02-02 5 J0101 Johnson Lisa 6 NG100 Nguyen Ni M 764 Johnson Place Leesburg FL 34751 7155558899 so 20-NOV-86 4420 4 +01-11 M 688 4th Street Orlando FL 31458 7155554944 FR 04-DEC-86 9188 3 +00-04 O Jonnel Brown O Mark Zhulin O James Sealy O Teresa Marx O Colin Langley O They all have advisees. o o o o o

Using the attached image of a relationship between the two entities, faculty and student, and the instances shown in the tables for both, identify the faculty member who has no advisees. 2 Start Page MidTerm Exam 6 Relational_1 (Untitled_1) CIS25501STUDENT PS ID SLAST S FIRST S_MI SADDRESS SCITY S STATE S ZIP S_PHONE 5_CLASS S_DOB S_PIN F VARCHAR2 (6 BYTE VARCHAR2 (30 BYTE VARCHAR2 (30 BYTE CHAR (1 BYTE VARCHAR2 (25 BYTE) CIS25501FACULTY P FID F_LAST F_FIRST F_MI F_PHONE VARCHAR2 (10 BYTE F_RANK FSUPER FPIN FACULTY_F_ID_PK (F_ID) O FACULTY_F_ID PK (F_ID) NUMBER (6) VARCHAR2 (30 BYTE VARCHAR2 (30 BYTE CHAR (1 BYTE VARCHAR2 (20 BYTE) CHAR (2 BYTE VARCHAR2 (10 BYTE VARCHAR2 (10 BYTE CHAR (2 BYTE DATE NUMBER (4) VARCHAR2 (9 BYTE) NUMBER (6) NUMBER (4) FID TIME ENROLLED NUMBER (6) INTERVAL YEAR TO MONTH STUDENT S_ID_PK (S_ID) Script Output x DQuery Result x STUDENT_F_ID_FK (F_ID) *A a SQL | All Rows Fetched: 5 in 0.74 seconds F_ID F_LAST O F_FIRST F_MI F_PHONE F_RANK 1 Marx 2 Zhulin Mark 3 Langley Colin O STUDENT S_ID PK (S_ID) F_SUPER F_PIN 1 Teresa J 4075921695 Associate 4. 6338 M 4073875682 Full (null) 1121 3 A 4075928719 Assistant 4 9871 4 4 Brown Jonnel D 4078101155 Full (null) 8297 5 Sealy James 4079817153 Associate 1 6089 5 L |Script Output x DQuery Result x A A R sQL SQL | All Rows Fetched: 6 in 0.759 seconds O5 IDS LASTOS FIRSTOS MI S ADDRESS 1 J0100 Jones Tammy R 2 PE100 Perez }5_CITY S_STATE S_ZIP s_PHONE S_CLASSS_DOB S_PIN F_ID TIME_ENROLLED 1 +03-02 1817 Eagleridge Circle Tallahassee FL 32811 7155559876 SR 14-JUL-85 8891 1 +04-02 1 +03-00 Jorge 951 Rainbow Dr Clermont FL 34711 7155552345 SR 19-AUG-85 1230 3 MA100 Marsh 1275 West Main St Carrabelle FL John A 32320 7155553907 JR 10-0СТ-82 1613 4 SM100 Smith Mike (null) 428 Markson Ave Eastpoint FL 32328 7155556902 so 24-SEP-86 1841 2 +02-02 5 J0101 Johnson Lisa 6 NG100 Nguyen Ni M 764 Johnson Place Leesburg FL 34751 7155558899 so 20-NOV-86 4420 4 +01-11 M 688 4th Street Orlando FL 31458 7155554944 FR 04-DEC-86 9188 3 +00-04 O Jonnel Brown O Mark Zhulin O James Sealy O Teresa Marx O Colin Langley O They all have advisees. o o o o o

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter1: Overview Of Database Concepts

Section: Chapter Questions

Problem 2MC

See similar textbooks