write sql queries]
9. The total number of sections taught by each instructor in each (semester, year)
10. The total number of D and F grades in each (semester,
year)
11. The total number of D and F grades in each (semester, year) for the “Graph Theory” course
Homework Answers
Add Answer to:
write sql queries]
9. The total number of sections taught by each instructor in
each (semester,...
10- Specify the following queries in SQL on the database schema of Figure 2. a. Retrieve...
10- Specify the following
queries in SQL on the database schema of Figure 2. a. Retrieve the
names of all senior students majoring in ‘CS’ (Computer Science).
b. Retrieve the names of all courses taught by Professor King in
2004 and 2005. c. For each section taught by Professor King,
retrieve the course number, semester, year, and number of students
who took the section. d. Retrieve the name and transcript of each
senior student (Class =4) majoring in CS. A...
Create sql queries to find the following miscrosoft access compatible commands please 9. Courses for which...
Create sql queries to find the following
miscrosoft access compatible commands please
9. Courses for which at least three students earned a grade of A, showing the grade and the course code 10. Semesters when the highest number of courses have been scheduled, showing the semester name and the number of sections 11. (Extra) Professors that are not students, and students that are not professors, showing their ID and SSN 12. (Extra) Semesters for which all courses are taught by...
Subject : computer science -web development Qus: using the database tables below write the SQL queries:...
Subject : computer science -web development Qus: using the database tables below write the SQL queries: ( SELECT; FORM; WHERE; ORDER BY; DISTINCT; GROUP BY; COUNT(); SUM(); AVG(); MAX(); MIN(); JOIN; ON) Student (StudentId, Major, GPA) Transcript( Studentid, CourseNo, Gread); Course( CourseNo, Title, Credits) Display the title of the course(s) that are 3 credits? Display the average GPA of the students Majoring in ‘CSC’ List non duplicated major(s) of students who have received a grades of ‘A’ in CSC350 List...
Problem 1-5 using the table below in the picture to be answered in Microsoft SQL. Thanks...
Problem 1-5 using the table below in the picture to be
answered in Microsoft SQL. Thanks
4. Write SQL queries to answer the following questions, a. How many students were enrolled in secoon 14 b. How many students were enrolled in ISM 3113 5. Write an SOL query to answer the following question Which students were not enrolled in any courses on Problems and Exercises 6 through 14 are based on Figure 7-15. The problem set continues from Chapter 6,...
EXERCISE Provide working SQL DML statements for the following database schema and queries CUSTOMER (ID, Type,...
EXERCISE Provide working SQL DML statements for the following database schema and queries CUSTOMER (ID, Type, Firstname, Lastname, Address, City) INVENTORY(ID, ItemName, Type, MadeInStore, SupplierName, DailyAverageSold, Price) ORDERS(ID, Customer_FK, Item_FK, Quantity, DeliveryDate) 16. Find the total amount due for each order, where the total is at least $70 . Show: order id, lastname, and total-amount . Hint: variation of previous query 17. Find the total amount due for each order placed by a customer that is a restaurant owner, total...
I have already turned in my HW, I need some understanding of the below SQL queries....
I have already turned in my HW, I need some understanding of the
below SQL queries.
1. Find the number of employees in each department.
2. List the names of departments that have more than 5 employees
working there.
3. Retrieve the lowest and highest salary in each department.
Output the department name in alphabetical order.
Consider the following relational schema. An employee can work in more than on department; also, the percentTime field of the Works relations shows the...
2. SQL queries (40 points total, 5 points each query) Write SQL query statements to query...
2. SQL queries (40 points total, 5 points each query) Write SQL query statements to query the following Hotel Room Booking Database Tables. "cid" is Customer ID. "rid" is Room ID. "bid" is Booking ID. "dob" means Date of Vwwww Birth; "beds" means the number of beds in the room which is normally 1 or 2 beds. "DueDate" and "DueAmount" are the payment due dates and due amounts of this booking. Customers fname name phone email cid dob zipcode Rooms...
4. Write SQL data definition commands for each of the following queries: a. How would you add an attribute, Class, to the Student table? b. How would you remove the Registration table? c. How would you change the FacultyName field from 25 characters
Problems and Exercises 1 through 9 are based on the dass scheduling
3NF relations along with some sample data shown in Figure 6-11.
Not shown in this figure are data for an ASSIGNMENT relation,
which represents a many-to-many relationship between faculty and
sections.4. Write SQL data definition commands for each of the following queries:a. How would you add an attribute, Class, to the Student
table?b. How would you remove the Registration table?c. How would you change the FacultyName field from...
7. Using the provided schema of a Purchase Order Administration database, write the following queries in...
7. Using the provided schema of a Purchase Order Administration database, write the following queries in SQL. (In the schema, bold attributes are primary keys and italicized attributes are foreign keys.) SUPPLIER (SUPNR, SUPNAME, SUPADDRESS, SUPCITY, SUPSTATUS) SUPPLIES (SUPNR, PRODNR, PURCHASE_PRICE, DELIV_PERIOD) PRODUCT (PRODNR, PRODNAME, PRODTYPE, AVAILABLE_QUANTITY) PO_LINE (PONR, PRODNR, QUANTITY) PURCHASE_ORDER (PONR, PODATE, SUPNR) 7d) Write a nested SQL query to retrieve the supplier number, supplier name, and supplier status of each supplier who has a higher supplier status...
Find all courses taught by Mozart. For each such course, output the title, semester, and year.
Query 1 (2 pts)Find all courses taught by Mozart. For each such course, output the title, semester, and year.Query 2 (2 pts)Find the names of all students who took both “Intro. to Computer Science” and “Game Design”.Query 3 (2 pts)Find the names of all instructors in the computer science department who never taught “Intro. to Computer Science”.Query 4 (2 pts)For each student, find the number of courses taken by this student. Output a table consisting of two columns: name of...
10- Specify the following
queries in SQL on the database schema of Figure 2. a. Retrieve the
names of all senior students majoring in ‘CS’ (Computer Science).
b. Retrieve the names of all courses taught by Professor King in
2004 and 2005. c. For each section taught by Professor King,
retrieve the course number, semester, year, and number of students
who took the section. d. Retrieve the name and transcript of each
senior student (Class =4) majoring in CS. A...
Create sql queries to find the following
miscrosoft access compatible commands please
9. Courses for which at least three students earned a grade of A, showing the grade and the course code 10. Semesters when the highest number of courses have been scheduled, showing the semester name and the number of sections 11. (Extra) Professors that are not students, and students that are not professors, showing their ID and SSN 12. (Extra) Semesters for which all courses are taught by...
Problem 1-5 using the table below in the picture to be
answered in Microsoft SQL. Thanks
4. Write SQL queries to answer the following questions, a. How many students were enrolled in secoon 14 b. How many students were enrolled in ISM 3113 5. Write an SOL query to answer the following question Which students were not enrolled in any courses on Problems and Exercises 6 through 14 are based on Figure 7-15. The problem set continues from Chapter 6,...
EXERCISE Provide working SQL DML statements for the following database schema and queries CUSTOMER (ID, Type, Firstname, Lastname, Address, City) INVENTORY(ID, ItemName, Type, MadeInStore, SupplierName, DailyAverageSold, Price) ORDERS(ID, Customer_FK, Item_FK, Quantity, DeliveryDate) 16. Find the total amount due for each order, where the total is at least $70 . Show: order id, lastname, and total-amount . Hint: variation of previous query 17. Find the total amount due for each order placed by a customer that is a restaurant owner, total...
I have already turned in my HW, I need some understanding of the
below SQL queries.
1. Find the number of employees in each department.
2. List the names of departments that have more than 5 employees
working there.
3. Retrieve the lowest and highest salary in each department.
Output the department name in alphabetical order.
Consider the following relational schema. An employee can work in more than on department; also, the percentTime field of the Works relations shows the...
2. SQL queries (40 points total, 5 points each query) Write SQL query statements to query the following Hotel Room Booking Database Tables. "cid" is Customer ID. "rid" is Room ID. "bid" is Booking ID. "dob" means Date of Vwwww Birth; "beds" means the number of beds in the room which is normally 1 or 2 beds. "DueDate" and "DueAmount" are the payment due dates and due amounts of this booking. Customers fname name phone email cid dob zipcode Rooms...
Most questions answered within 3 hours.
-
(CO 2) A field can be added to a report to
values for two or more...
asked 23 minutes ago -
Identify 3 research scenarios that might provide a low,
medium, and high degree of variability in...
asked 46 minutes ago -
how
does gravity affect the trajectory of projectile? what would be the
shape of the trajactory...
asked 1 hour ago -
Two small plastic spheres are given positive electrical charges.
When they are a distance of 15.4...
asked 1 hour ago -
An acidic solution containing gold ions is
electrolyzed, producing gaseous oxygen (from water) at the anode...
asked 1 hour ago -
Assume that the population of Mexico is 128
million and that the population increases 1.01
percentannually....
asked 2 hours ago -
Can someone please help me add appropriate descriptive
comments to each line of code in the...
asked 3 hours ago -
Romeo wishes to throw a bouquet of flowers to Juliet, who is on
a second-story balcony,...
asked 4 hours ago -
Why is QE a controversial monetary policy tool.
A. It may lead to excessive inflation.B. By...
asked 4 hours ago -
Principles of Programming midterm study guide help!
1.)
______ Which of the following would reference the...
asked 3 hours ago -
A finite potential well has depth U0 = 2.78 eV . What is the
penetration distance...
asked 4 hours ago -
1. The bus bars of a power station are in two sections A and B
separated...
asked 4 hours ago