The sample is given below STUDENT DATA S_ID S_LAST S_FIRST S_MI S_ADDRESS S_CITY S_STATE S_ZIP S_PHONE S_CLASS 1 Miller

[answerhappygod]

The sample is given below
STUDENT DATA
S_ID S_LAST S_FIRST S_MI S_ADDRESS S_CITY S_STATE S_ZIP S_PHONE
S_CLASS
1 Miller Sarah M 144 Windridge Blvd. Eau Claire WI 54703 7155559876
SR
2 Umato Brian D 454 St. John's Place Eau Claire WI 54702 7155552345
SR
3 Black Daniel 8921 Circle Drive Bloomer WI 54715 7155553907
JR
4 Mobley Amanda J 1716 Summit St. Eau Claire WI 54703 7155556902
SO
5 Sanchez Ruben R 1780 Samantha
Court
Eau Claire WI 54701 7155558899 SO
6 Connoly Michael S 1818 Silver Street Elk Mound WI 54712
7155554944 FR
S_DOB S_PIN F_ID
14-Jul-85 8891 1
19-Aug-85 1230 1
10-Oct-82 1613 1
24-Sep-86 1841 2
20-Nov-86 4420 4
04-Dec-86 9188 3
FACULTY DATA
F_ID F_LAST F_FIRST F_MI LOC_ID F_PHONE F_RANK F_PIN
1 Cox Kim J 9 7155551234 ASSO 1181
2 Blanchard John R 10 7155559087 FULL 1075
3 Williams Jerry F 12 7155555412 ASST 8531
4 Sheng Laura M 11 7155556409 INST 1690
5 Brown Philip E 13 7155556082 ASSO 9899
COURSE DATA
COURSE_ID CALL_ID COURSE_NAME CREDITS
1 MIS 101 Intro. to Info. Systems 3
2 MIS 301 Systems Analysis 3
3 MIS 441 Database Management 3
4 CS 155 Programming in C++ 3
5 MIS 451 Web-Based Systems 3
LOCATION DATA
LOC_ID BLDG_CODE ROOM CAPACITY
1 CR 101 150
2 CR 202 40
3 CR 103 35
4 CR 105 35
5 BUS 105 42
6 BUS 404 35
7 BUS 421 35
8 BUS 211 55
9 BUS 424 1
10 BUS 402 1
11 BUS 433 1
12 LIB 217 2
13 LIB 222 1
COURSE SECTION DATA
C_SEC_ID COURSE_ID TERM_ID SEC_NUM F_ID C_SEC_DAY C_SEC_TIME LOC_ID
MAX_ENRL
1 1 4 1 2 MWF 10:00 AM 1 140
2 1 4 2 3 TR 9:30 AM 7 35
3 1 4 3 3 MWF 8:00 AM 2 35
4 2 4 1 4 TR 11:00 AM 6 35
5 2 5 2 4 TR 2:00 PM 6 35
6 3 5 1 1 MWF 9:00 AM 5 30
7 3 5 2 1 MWF 10:00 AM 5 30
8 4 5 1 5 TR 8:00 AM 3 35
9 5 5 1 2 MWF 2:00 PM 5 35
10 5 5 2 2 MWF 3:00 PM 5 35
11 1 6 1 1 MTWRF 8:00 AM 1 50
12 2 6 1 2 MTWRF 8:00 AM 6 35
13 3 6 1 3 MTWRF 9:00 AM 5 35
S_ID C_SEC_ID GRADE
1 1 A
1 4 A
1 6 B
1 9 B
2 1 C
2 5 B
2 6 A
2 9 B
3 1 C
3 12
3 13
4 11
4 12
5 1 B
5 5 C
5 9 C
5 11
5 13
6 11
6 12
TERM DATA
TERM_ID TERM_DESC STATUS
1 Fall 2005 CLOSED
2 Spring 2006 CLOSED
3 Summer 2006 CLOSED
4 Fall 2006 CLOSED
5 Spring 2007 CLOSED
6 Summer 2007 OPEN
What SQL oracle developer code need to be type for the following
to be done:
Its from norhwoods tables given above..
1(a)List the building code and room of every record in the
LOCATION table,
and also list the term description, call id section number, day,
and time of
every course ever taught at that location. Format the time field so
the values
appear as times, not dates. (Hint: you need to use multiple outer
joins.)
(b)List the building code and room number of all locations that
have the same
capacity as CR 103.
(c)List the first and last names of all faculty members who have
ever taught
any of the same courses as faculty member Kim Cox or who have
ever
taught a class in the same room as Kim Cox.