Use data model to answer the following questions:
1. Make a list of students who do not have phone numbers in
the system (you must use NOT IN)
2. List course sections with no students enrolled
(you must use OUTER (LEFT or RIGHT) JOIN).
Use Data Model To Answer The Following Questions 1 Make A List Of Students Who Do Not Have Phone Numbers In The System 1 (94.42 KiB) Viewed 14 times
STUDENT ID FIRST_NAME LAST NAME ADDRESS DOB GENDER STUDENT STUDENT PHONE STUDENT_ID PHONE_ID PHONE NUMBER Integer varchar2(30) varchar2(30) varchar2(100) date char(1) Integer Integer varchar2(20) PK FK PK PK STUDENT DEPARTMENT STUDENT_ID DEPARTMENT_ID MINOR_0_OR_MAJOR_1 STUDENT ID DEPARTMENT_ID COURSE_ID SECTION_ID GRADE GRADE REPORT Integer PK FK integer PK FK BO char(1) PK FK PK FK PK FK PK FK Integer integer integer Integer NUMBER(3) N DEPARTMENT integer DEPARTMENT ID PK DEPARTMENT_NAME varchar2(50) OFFICE NUMBER OFFICE PHONE COLLEGE_NAME varchar2(10) varchar2(20) varchar2(50) COURSE DEPARTMENT_ID COURSE_ID NAME DESCRIPTION SEMESTER HOURS COURSE_LEVEL DEPARTMENT_ID COURSE_ID SECTION_ID YEAR TERM LOCATION + integer integer varchar2(50) varchar2(200) integer char(1) COURSE_SECTION integer PK FK integer PK FK Integer PK integer integer char(1) PK FK PK
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!