Question: Write SQL queries to answer the following questions: a. Which students have an ID number that is less than 50000? b. What is the name

Write SQL queries to answer the following questions:
a. Which students have an ID number that is less than 50000?
b. What is the name of the faculty member whose ID is 4756?
c. What is the smallest section number used in the first semester of 2008?

The class scheduling 3NF relations along with some sample data shown in Figure 6-10. Not shown in this figure are data for an ASSIGNMENT relation, which represents a many-to-many relationship between faculty and sections.

STUDENT (StudentID, StudentName) QUALIFIED (FacultylD, CourselD, DateQualified) StudentID StudentName FacultylD CourselD DateQualified 38214 Letersky Altvater 2143 ISM 3112 9/1988 54907 2143 ISM 3113 9/1988 66324 Aiken 3467 ISM 4212 9/1995 70542 Marra 3467 ISM 4930 9/1996 4756 ISM 3113 9/1991 4756 ISM 3112 9/1991 .. FACULTY (FacultyID, FacultyName) SECTION (SectionNo, Semester, CourselD) FacultyID FacultyName SectionNo Semester CourselD 2143 Birkin 2712 1-2008 ISM 3113 3467 Berndt 2713 1-2008 ISM 3113 4756 Collins 2714 1-2008 ISM 4212 2715 1-2008 ISM 4930 .. COURSE (CourselD, CourseName) REGISTRATION (StudentID, SectionNo, Semester) CourselD CourseName StudentID SectionNo Semester ISM 3113 ISM 3112 Syst Analysis Syst Design Database Networking 38214 2714 2714 1-2008 1-2008 54907 54907 ISM 4212 2715 1-2008 ISM 4930 66324 2713 1-2008 FIGURE 6-10 Class scheduling relations (missing ASSIGNMENT)

Step by Step Solution

★★★★★

3.41 Rating (167 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a SELECT StudentID StudentName FROM S... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Essentials Database Management Questions!

Write SQL queries to answer the following questions: a. Which students have an ID number that is less than 50000? b. What is the name of the faculty member whose ID is 4756? c. What is the smallest...

Write SQL queries to answer the following questions: a. How many students are enrolled in Section 2714 in the first semester of 2015? b. Which faculty members have qualified to teach a course since...

Write SQL queries to answer the following questions: a. Which students are enrolled in Database and Networking? b. Which instructors cannot teach both Syst Analysis and Syst Design? c. Which courses...

Question1: Use SQL to define the following view: StudentID StudentName 38214 Letersky 54907 Altvater 54907 Altvater 66324 Aiken Q2: Write SQL data definition commands for each of the following...

Use SQL to define the following view: StudentID StudentName 38214 Letersky 54907 Altvater 54907 Altvater 66324 Aiken Q2: Write SQL data definition commands for each of the following queries: a. How...

1. Write a database description for each of the relations shown, using SQL DDL. 2. Write SQL data definition commands for each of the following queries: a) How would you add an attribute, country...

Microsoft Access Assignment: Please Post Link to Download: 6-36. Use SQL to define the following view: StudentID StudentName 38214 Letersky 54907 Altvater 54907 Altvater 66324 Aiken 6-37. Because of...

8. Write SQL queries to answer the following questions: A) Which students are enrolled in both Database and Networking? (Hint: use SectionNo for each class, so that you can determine theanswer from...

please solve part 2 of this question. and please post a new answer and not the one here previously Marks 2 Part-1/during lab-2/Week-2/day-2 1. Create a database as "your last_name_A1" then crate all...

7-28 A. B. C. of that were introduced of the temp extensions Chapter 7 Advanced SQL 331 Discuss in ere to SQL 724. This chapter discusses the data dictionary views for as the temporal used 12e,...

Solve the linear programming model formulated in Problem 59 for the Wisham family farm using the computer. a. Are there any extra (slack) resources available? b. If the Wisham family could obtain...

The bad debt ratio for a financial institution is defined to be the dollar value of loans defaulted divided by the total dollar value of all loans made. Suppose a random sample of seven Ohio banks is...

A company sells goods for $ 1 5 0 , 0 0 0 that 0 0 st $ 5 4 , 0 0 0 so mandfacture. Which of the following statements is true? a . The connpany will reoognize sales on the balunce ubeet of $ 1 5 0 ,...

Telehealth has been associated with fraud. TRUE OR FALSE

Calculate 1.666015625 10 0 (1.9760 10 4 + -1.9744 10 4 ) by hand, assuming each of the values are stored in the 16-bit half precision format described in Exercise 3.27 (and also described in the...

Calculate (1.666015625 10 0 1.9760 10 4 ) + (1.666015625 10 0 -1.9744 10 4 ) by hand, assuming each of the values are stored in the 16-bit half precision format described in Exercise 3.27 (and...

Based on your answers to 3.38 and 3.39, does (1.666015625 10 0 1.9760 10 4 ) + (1.666015625 10 0 -1.9744 10 4 ) = 1.666015625 10 0 (1.9760 10 4 + -1.9744 10 4 )?

Your team asks VTEPS. Inc. to purchase a light duty delivery truck for $15,000 It a anticipated that the purchase of the truck will increase revenue by $10,000 annually, but have operating expenses...

We have studied the Go-Back-N and the Selective Reject flow control Protocols. In both cases we have seen that the Sliding Window size has to be carefully selected to avoid duplicates. Starting from...

The coupon rate on a floating rate note that makes payments in June and December is expressed as six-month Libor plus 28 bps. The six-month LIBOR in December 2018 was 2% and the six-month LIBOR in...