Start Page dis-data.student. directory.jott * INSTRUCTOR Columns Data |Model | Constraints | Grants | Statistics | Triggers | Flashback |...
View the step-by-step solution to:

Question

Screen Shot 2019-09-24 at 1.47.36 PM.png

src="/qa/attachment/10518530/" alt="Screen Shot 2019-09-24 at 1.47.25 PM.png" />Screen Shot 2019-09-24 at 1.51.05 PM.pngfinding the query that ill not kick me back an error

Screen Shot 2019-09-24 at 1.47.25 PM.png

Start Page
dis-data.student. directory.jott *
INSTRUCTOR
Columns Data |Model | Constraints | Grants | Statistics | Triggers | Flashback | Dependencies | Details | Partitions | Indexes | SQL
Actions...
#COLUMN_NAME
DATA_TYPE
NULLABLE DATA_DEFAULT
# COLUMN_ID
#COMMENTS
1 INSTRUCTOR ID
NUMBER (8, 0)
No
(null)
1 The unique ID for an instructor.
2 SALUTATION
VARCHAR2 (5 BYTE)
Yes
(null)
2 This instructor's title (Mr., Ms., Dr., Rev., etc.)
3 FIRST NAME
VARCHAR2 (25 BYTE) Yes
(null)
3 This instructor's first name.
4 LAST NAME
VARCHAR2 (25 BYTE) Yes
(null)
4 This instructor's last name
5 STREET ADDRESS VARCHAR2 (50 BYTE) Yes
(null)
5 This Instructor's street address.
6 ZIP
VARCHAR2 (5 BYTE)
Yes
(null)
6 The postal zip code for this instructor.
7 PHONE
VARCHAR2 (15 BYTE) Yes
[null)
7 The phone number for this instructor including area
8 CREATED BY
VARCHAR2 (30 BYTE) No
[null)
8 Audit column - indicates user who inserted data.
9 CREATED DATE
DATE
No
(null)
9 Audit column - indicates date of insert.
10 MODIFIED BY
VARCHAR2 (30 BYTE) No
(null)
10 Audit column - indicates who made last update.
11 MODIFIED DATE
DATE
No
(null)
11 Audit column - date of last update.

Screen Shot 2019-09-24 at 1.47.36 PM.png

(3) Start Page
Cool OS-data.student. directory.jccc *
SECTION *
Columns Data |Model | Constraints | Grants | Statistics | Triggers | Flashback | Dependencies | Details | Partitions | Indexes | SQL
Actions...
# COLUMN_NAME
DATA_TYPE
NULLABLE DATA_DEFAULT
#COLUMN_ID # COMMENTS
1 SECTION ID
NUMBER (8, 0)
No
(null)
1 The unique ID for a section.
2 COURSE NO
NUMBER (8 , 0)
No
(null)
2 The course number for which this is a section.
3 SECTION NO
NUMBER (3, 0)
No
(null)
3 The individual section number within this course.
4 START DATE TIME DATE
Yes
(null)
4 The date and time on which this section meets.
5 LOCATION
VARCHAR2 (50 BYTE) Yes
(null)
5 The meeting room for the section.
6 INSTRUCTOR ID
NUMBER (8, 0)
No
(null)
6 The ID number of the instructor who teaches this s
7 CAPACITY
NUMBER (3, 0)
Yes
(null)
7 The maximum number of students allowed in this sec
8 CREATED BY
VARCHAR2 (30 BYTE) No
(null)
8 Audit column - indicates user who inserted data.
9 CREATED DATE
DATE
No
(null)
9 Audit column - indicates date of insert.
10 MODIFIED BY
VARCHAR2 (30 BYTE) No
(null)
10 Audit column - indicates who made last update.
11 MODIFIED DATE
DATE
No
(null)
11 Audit column - date of last update.

Screen Shot 2019-09-24 at 1.51.05 PM.png

4.
(Instructor table and Section table) Use the MINUS operator to determine if any
instructors are
not currently teaching any sections. Display the following result table. No points will
be given if
the MINUS operator is not used.
Instructors Not Teaching
110
109

Top Answer

The way to answer this question is ... View the full answer

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question