User Account

All Pages

Find the sum of all credits that history major have

Assignment Help PL-SQL Programming
Reference no: EM13993850

SQL

1. Find the most classes taken by students

2. Change the department of the facility who teach math

3. Change the department of the facility who teach math course to MCS

4. Find names of students who enrolled in all courses

5. Find the students by student ID who have taken the most class (counted by enrolled students) and not counting where an ‘F' was the grade.

6. Find the facility by facility id who teach math class (class that have math in their name)

7. Change the major of all students who are math majors and have taken math course from Byrne to MCS.

8. Display the student's ID for all students enrolled in math course by Byrne.

9. Find all students by student ID enrolled in math course taught by Byrne.

10. Change the major of all students who are math majors to MCS.

11. Add three credit to credit earned by students who have taken the most course.

12. Insert a new facility record with id of F330, name jones, department of CSC and rank of instructor.

13. Erase all enrollment records for jane rivers

14. Find the names of all students by first name and last name are not enrolled in CSC201A

15. Find all courses in which fewer than three students are enrolled

16. Find the sum of all credits that history major have

17. Find the number of departments that have facility in them.

18. For each major, find the sum of all the credits that students with that major have.

FIGURE 5.4 The University Database

Student

stuId lastName firstName major credits

$1,001 Smith Tom History 90

S1002 Chin Ann Math 36

$1,005 Lee Perry History 3

S1010 Burns Edward Art 63

$1,013 McCarthy Owen Math 0

51015 Jones Mary Math 42

S1020 Rivera Jane CSC 15

Faculty

facld name department rank


F101 Adams Art Professor


F105 Tanaka CSC Instructor


F110 Byrne Math Assistant


1115 Smith History Associate


F221 Smith CSC Professor


Class Enroll
classNumber  facld  schedule  room stuld  classNumber  grade
ART103A F101 MWF9 H221 51001 AR1IO3A A
CSC201A F105 TuTh110 M110 $1,001 HST205A C
CSC203A F105 MThF12 11110 S1002 ARTIO3A D
HST205A F115 MWF11 H221 S1002 CSC201A F
MTHIOIB F110 MTuTh9 H225 S1002 MTM103C B
MTHIO3C F110 MWF11 H225 S1010 ART103A




S1010 MTHIO3C




S1020 CSC201A B




S1020 MTH101B A

Verified Expert

This assignment illustrates the concepts of SQL. Several Queries involving the concepts of insertion, selection and updating of tables are explained in the solution for this task.

Reference no: EM13993850

Questions Cloud

Should the passenger motion to suppress : Should the passenger's motion to suppress the seized evidence be granted? Please provide a single video presentation that contains your response to this question, followed by your response to the question from the second case below
What are the risk factors in a prospectus : What are the risk factors in a prospectus? Why are they important to the issuer and to the investor?
Provide examples of disclosure required by united state : Disclosure of information to investors is another recurring theme in U.S. regulation of the securities industry. Provide examples of disclosure required by U.S. regulations.
What procedural steps must the orange county prosecutor take : What procedural steps must the Orange County prosecutor take to extradite Hurst from Arizona? What procedural steps must the Orange County prosecutor take to extradite Brook from Mexico
Find the sum of all credits that history major have : Find the most classes taken by students and Find the facility by facility id who teach math class and display the student's ID for all students enrolled in math course by Byrne.
What is the z component of the resultant magnetic field : Each straight wire is 20 cm from the center of the loop. What is the z component of the resultant magnetic field at the center of the loop?
What is the induced emf in the loop : A circular loop made from a flexible, conducting wire is shrinking. Its radius as a function of time is r = r0eβt. What is the induced emf in the loop at t = 3.00 s?
Name four of these acts and briefly describe their purpose : Following the 1929 stock market crash, Congress passed a series of Acts to regulate the securities industries. Name four of these Acts and briefly describe their purpose.
Should we expect journalists to uphold a higher level : Blair has since joined the "speaker circuit," lecturing on ethics under the title "Lessons Learned." Is it ethical to make money from lecturing on your own unethical behavior? Why or why not?

Reviews

Write a Review

PL-SQL Programming Questions & Answers

  Create a database model

Create a database model and Submit the table creation statements for the Database Model.

  Write pl-sql procedures and functions

Write PL/SQL procedures and functions to populate and query that database

  Sql questions

Write a query to display using the employees table the EMPLOYEE_ID, FIRST_NAME, LAST_NAME and HIRE_DATE of every employee who was hired after to 1 January, 1995.

  Run the lab_03_01.sql script

Run the lab_03_01.sql script in the attached file to create the SAL_HISTORY table. Display the structure of the SAL_HISTORY table.

  Write sql queries

Write a query to display the last name, department number, and salary of any employee whose department number and salary both match the department number and salary of any employee who earns a commission.

  Explaining sql insert statement to insert new row in cds

Write down a SQL insert statement to insert new row in "CDS" table.

  Write down name of actors in ascending order

Write down actors (or actress, your choice, but not both) who have won at least two (2) Academy Awards for best actor/actress. Provide the actor name, movie title & year. Order the result by actor name."

  What is an sql injection attack

What is an SQL injection attack? Explain how it works, and what precautions must be taken to prevent SQL injection attacks.What are two advantages of encrypting data stored in the database?

  Determine resonant frequency in series rlc resonant circuit

Given the series RLC resonant circuit in the figure, operating at variable frequency, determine: The resonant frequency ω o ,  The circuit’s quality factor Q , The cut-off frequencies, f 1  & f 2  and the bandwidth BW

  Query that uses cube operator to return lineitemsum

Write summary query which uses CUBE operator to return LineItemSum (which is the sum of InvoiceLineItemAmount) group by Account(an alias for AccountDesciption).

  Query to show customers were missing for existing orders

As DBA, your manager called a meeting and asked why there are so many orders for customers that don't exist in the customer table. Write query which would shows which customers were missing for existing orders. Use a join or a subquery.

  Sql query into a relational algebra statement

Turn this SQL query into a relational algebra statement? SELECT Request.reqfor, Ordering.invamt, Ordering.invnbr, Ordering.invdat

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd