Question Details

Answered: - Display student id, student first name, student last name,


Display student id, student first name, student last name, the students? faculty advisor id, advisor last name, advisor location and phone number. You will join uc_student and uc_faculty

Write a SELECT statement that will return the faculty last name, faculty first name and the room for faculty whose offices are located in the ?BUS? building.

Display data from the uc_course_section table by performing a Three Table Join with the uc_course_section, uc_location and uc_course. The SELECT statement will display the course section id (c_sec_id), the course name, number of credits, maximum number of enrollments in a course section, building and room where the class meets and the capacity of the room ? and only for courses for term_id 5.

Write a select statement that will display student id, student last name and the number of courses a student has been enrolled. You will need to join two table, use a COUNT aggregate and a GROUP BY clause in your SELECT statement.

Create a SELECT statement that would provide data for a faculty directory. Display should include faculty id, first name, middle initial, last name, office location (building and room), rank and phone number. The display should be sorted by last name ascending. Concatenate first name, middle initial and last name to look like ? James E. Smith?. Concatenate building and room to look like ?ENG102?. Override the column labels with meaningful descriptions.


IST210 --- World Campus

 

Lab # 5 Demonstration of JOINS

 

1.

 


 

Provide a listing of courses being offered. Include course identification, course name,

 

section identification, term identification and maximum enrollment.

 


 

select uc_course.course_id, course_name, c_sec_id, term_id, max_enrl

 

FROM uc_course, uc_course_section

 

WHERE uc_course_section.course_id = uc_course.course_id

 


 

2. For situation in # 1, only display the courses if the course meets on

 

Monday/Wednesday/Friday

 

select uc_course.course_id, course_name, c_sec_id, term_id, max_enrl

 

FROM uc_course, uc_course_section

 

WHERE uc_course_section.course_id = uc_course.course_id

 

and c_sec_day = 'MWF'

 


 

3.

 


 

Display the grades sorted by term include student identification, student last name, term

 

identification, course identification and section identification (c_sec_id) and grade. Do

 

not select if no grade exists.

 


 

select uc_student.s_id, s_last, course_id, uc_enrollment.c_sec_id, grade

 

FROM uc_student, uc_course_section, uc_enrollment

 

WHERE uc_student.s_id = uc_enrollment.s_id AND

 

uc_enrollment.c_sec_id = uc_course_section.c_sec_id

 

AND grade IS NOT NULL

 

4. Display the number of sections that each faculty teaches. Display

 

facutly identification, faculty last name and number of course

 

sections.

 

select uc_faculty.f_id, f_last, COUNT(*) as NumSections

 

FROM uc_faculty, uc_course_section

 

WHERE uc_faculty.f_id = uc_course_section.f_id

 

GROUP BY uc_faculty.f_id, f_last

 

5. Display student id and student entire name formatted ?Smith, James? with

 

the labels ?S#? and ?Name?

 

select s_id AS S#, s_last+', '+s_first AS Name

 

FROM uc_student

 


 

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 18, 2020

PRICE: $15

Solution~0001185645.zip (25.37 KB)

Buy this answer for only: $15

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 18, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now