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

  Who are the opposition leaders

Write SQL SELECT statements to retrieve the following information from the prime_minister database.

  How does the order of joins in an sql statement

How does the order of joins in an SQL statement affect the performance of the join and what can the DBA do to determine the preferred order of joins for an SQL statement that includes the join of at least three tables?

  Write a select statement

Write a Select statement that determines whether the PaymentDate column of The Invoices table has any invalid values.

  Database analysis and design

Implement the initial database design for the Customer Relationship Management VIEW as described below in your selected RDBMS. You need to create the Entity-Relationship model from your normalization and Database analysis, define tables, primary k..

  Write sql queries using between, like and union

write SQL queries using Between, Like and Union

  Create a view named largeslip using the data

Create a view named LargeSlip using the data in the MarinaNum, SlipNum, RentalFee, BoatName, and OwnerNum columns in the MarinaSlip table for those slips with lengths of 40 feet. Display the data in the view.

  Display the customerid from the orders table

Display the CustomerID from the Orders table and the sum of the associated ItemPrice multiplied by Quantity using Gross Sales (with a space) as the column name from the OrderItems table.

  Create the sql queries

Create the queries listed below: (Just write the SQL command for each query), RIDER - POINT TOTALS BY RACE LEVEL LISTING, List the Rider's Name, RaceLevel as Race_Level and the total number of all points based on their placement. Make sure that you..

  What are the two major components of sql

Explain the function of each of the clauses in the SELECT statement. What restrictions are imposed on these clauses. What are the two major components of SQL and what function do they serve

  Determine the commissions paid to specific employees of sale

Design a query that will allow the finance department to determine the commissions paid to specific employees of the sales department for the month of December.

  Write programme in oracle to make employee table

List the employee_id and employee_name of the employees form the l_employees table with the top 4 credit limits.

  Question 1 given the series rlc resonant circuit in the

question 1 given the series rlc resonant circuit in the figure operating at variable frequency determinenbspa. the

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