Show the top student(s) (the one with the highest GPA) of each major. List students who are
Fantastic news! We've Found the answer you've been seeking!
Question:
- Show the top student(s) (the one with the highest GPA) of each major.
- List students who are taking a course(s) and its prerequisite(s) at the same time.
- List the earliest class (in terms of starting time) of each instructor.
Transcribed Image Text:
staff StaffID INT(11) StfFirstName VARCHAR(25) StfLastname VARCHAR(25) HH StfStreetAddress VARCHAR(50) >StfCity VARCHAR(30) >StfState VARCHAR(2) StfZipCode VARCHAR(5) StfAreaCode VARCHAR(5) StfPhoneNumber VARCHAR(8) Salary DECIMAL (15,2) >DateHired DATE Position VARCHAR(50) Indexes ▶ H ||+++ faculty_classes▼ ClassID INT (11) StaffID INT(11) Indexes faculty StaffID INT(11) departments V DepartmentID INT(11) DeptName VARCHAR(50) H DeptChair INT(11) Indexes Title VARCHAR(50) Status VARCHAR(12) Tenured BIT (1) Indexes TH HI ➤ categories CategoryID VARCHAR(10) CategoryDescription VARCHAR(75) DepartmentID INT(11) Indexes faculty_categories StaffID INT(11) CategoryID VARCHAR(10) Indexes StaffID INT(11) SubjectID INT (11) faculty_subjects HH Indexes ProficiencyRating DOUBLE ▶ classes ClassID INT (11) SubjectID INT (11) ClassRoom ID INT (11) >Credits TINYINT(4) Semester Number SMALLINT(6) ||+ StartDate DATE StartTime TIME Duration SMALLINT (6) MondaySchedule BIT(1) TuesdaySchedule BIT (1) Indexes WednesdaySchedule BIT(1) ThursdaySchedule BIT(1) FridaySchedule BIT (1) SaturdaySchedule BIT(1) Indexes V subjects SubjectID INT (11) CategoryID VARCHAR(10) SubjectCode VARCHAR(8) SubjectName VARCHAR(50) SubjectPreReq VARCHAR(8) Subject Description TEXT SubjectEstClassSize SMALLINT (6) L # student schedules StudentID INT(11) ClassID INT (11) ClassStatus INT(11) Grade DOUBLE Indexes class_rooms ClassRoom ID INT (11) BuildingCode VARCHAR(3) PhoneAvailable BIT (1) Capacity SMALL INT(6) Indexes ▶ ➤ students StudentID INT(11) >StudFirstName VARCHAR(25) StudLastName VARCHAR(25) StudStreetAddress VARCHAR(50) StudCity VARCHAR(30) StudState VARCHAR(2) StudZipCode VARCHAR(5) StudAreaCode VARCHAR(5) StudPhoneNumber VARCHAR(8) StudBirthDate DATE StudGender VARCHAR(1) StudMarital Status VARCHAR(1) StudMajor INT (11) Indexes majors MajorID INT(11) Major VARCHAR(20) Indexes buildings BuildingCode VARCHAR(3) > BuildingName VARCHAR(25) HNum berOfFloors SMALLINT (6) Elevator Access BIT(1) SiteParking Available BIT (1) Indexes staff StaffID INT(11) StfFirstName VARCHAR(25) StfLastname VARCHAR(25) HH StfStreetAddress VARCHAR(50) >StfCity VARCHAR(30) >StfState VARCHAR(2) StfZipCode VARCHAR(5) StfAreaCode VARCHAR(5) StfPhoneNumber VARCHAR(8) Salary DECIMAL (15,2) >DateHired DATE Position VARCHAR(50) Indexes ▶ H ||+++ faculty_classes▼ ClassID INT (11) StaffID INT(11) Indexes faculty StaffID INT(11) departments V DepartmentID INT(11) DeptName VARCHAR(50) H DeptChair INT(11) Indexes Title VARCHAR(50) Status VARCHAR(12) Tenured BIT (1) Indexes TH HI ➤ categories CategoryID VARCHAR(10) CategoryDescription VARCHAR(75) DepartmentID INT(11) Indexes faculty_categories StaffID INT(11) CategoryID VARCHAR(10) Indexes StaffID INT(11) SubjectID INT (11) faculty_subjects HH Indexes ProficiencyRating DOUBLE ▶ classes ClassID INT (11) SubjectID INT (11) ClassRoom ID INT (11) >Credits TINYINT(4) Semester Number SMALLINT(6) ||+ StartDate DATE StartTime TIME Duration SMALLINT (6) MondaySchedule BIT(1) TuesdaySchedule BIT (1) Indexes WednesdaySchedule BIT(1) ThursdaySchedule BIT(1) FridaySchedule BIT (1) SaturdaySchedule BIT(1) Indexes V subjects SubjectID INT (11) CategoryID VARCHAR(10) SubjectCode VARCHAR(8) SubjectName VARCHAR(50) SubjectPreReq VARCHAR(8) Subject Description TEXT SubjectEstClassSize SMALLINT (6) L # student schedules StudentID INT(11) ClassID INT (11) ClassStatus INT(11) Grade DOUBLE Indexes class_rooms ClassRoom ID INT (11) BuildingCode VARCHAR(3) PhoneAvailable BIT (1) Capacity SMALL INT(6) Indexes ▶ ➤ students StudentID INT(11) >StudFirstName VARCHAR(25) StudLastName VARCHAR(25) StudStreetAddress VARCHAR(50) StudCity VARCHAR(30) StudState VARCHAR(2) StudZipCode VARCHAR(5) StudAreaCode VARCHAR(5) StudPhoneNumber VARCHAR(8) StudBirthDate DATE StudGender VARCHAR(1) StudMarital Status VARCHAR(1) StudMajor INT (11) Indexes majors MajorID INT(11) Major VARCHAR(20) Indexes buildings BuildingCode VARCHAR(3) > BuildingName VARCHAR(25) HNum berOfFloors SMALLINT (6) Elevator Access BIT(1) SiteParking Available BIT (1) Indexes
Expert Answer:
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date:
Students also viewed these databases questions
-
A transmission shaft is supported on two bearings which are 1m apart.Power is supplied to the shaft by means of a flexible coupling, which islocated to the left of left hand bearing. Power is...
-
What role does stakeholder engagement play in co-creating and refining organizational visions that resonate with diverse interests, values, and aspirations, thereby fostering collective ownership and...
-
Compute the contour integral 2 dz, where ris the contour of the perimeter of the square with vertices at the points z = 0, z 1, z 1+i, and z = i traversed once in that order. Select one: O a 2 +i O...
-
=) An alternating emf of peak-to-peak value of 40 V is applied across the series combination of an inductor of inductance 100 mH, capacitor of capacitance 1 F and resistance 10052. Determine maximum...
-
What is the standard enthalpy of a reaction for which the equilibrium constant is (a) doubled, (b) halved when the temperature is increased by 15 K
-
In the near future, which generation of workers will be larger and more diverse than the Baby Boomer generation? a. Generation X b. Generation Y c. Generation Z d. Millenniums
-
Describe the wide variety of legal issues that occur in the emergency department setting.
-
MULTIPLE-CHOICE QUESTIONS 1. Which of the following is not a reason that audit firms continue to experience high levels of litigation? a. Joint and several liability statutes. b. Class action...
-
If two trading partners suddenly become entangled in a trade war, what impact will this have on each nation? Explain.
-
Dwight Donovan, the president of Donovan Enterprises, is considering two investment opportunities. Because of limited resources, he will be able to invest in only one of them. Project A is to...
-
Find the limit by converting this into a Riemann sum and then to a definite integral. lim In n 2 1+ + ) ( + ) - (1 + )) n n
-
A country's population in 1965 was 12.4 million and it was growing at 3% per year. Assume no net migration. If necessary, round answers to 2 decimal points. Show all work. (10 points total) a. In...
-
Based on your own internet research, track the changes in the euro/USD exchange rate since the euro was launched in 2002. Which currency has appreciated and which has depreciated over the years since...
-
1. In what ways might capitalism be a better economic system than socialism? On the other hand, in what ways might socialism be a better economic system than capitalism? 2. Despite its documented...
-
Provide a brief but clear explanation 1)The rapid expansion of middle class is likely to aid not only the growth of the Asian economy but also the global economy. 2)Real effective exchange rate and...
-
Suppose you are tasked with reducing income inequality in the United States. Briefly discuss one policy you would implement to achieve this goal, making sure to explain why this policy makes sense...
-
Incremental Analysis including the terms Relevant, Opportunity, and Sunk Costs as well as examples including Special Orders, Make / Buy, Repair / Replace, and Unprofitable Segments. Choose one or...
-
An 8.0 kg crate is pulled 5.0 m up a 30 incline by a rope angled 18 above the incline. The tension in the rope is 120 N, and the crates coefficient of kinetic friction on the incline is 0.25. a. How...
-
1. What is meant by the phrase cost of nonconformance in relation to quality? 2. Waste, rework, and net cost of scrap are examples of what kinds of quality costs? 3. Quality engineering, quality...
-
Why is it said that a kaizen costing system operates outside the standard costing system?
-
From a behavioral point of view, what potential problems can occur when implementing a target costing system?
-
Figure 4.11 shows the \(v_{x}(t)\) curves for a collision between two identical carts moving not on a low-friction track but rather on a rough surface, so that friction affects their motion. Are the...
-
(a) Classify and give examples of the kinds of processes that can change (i) the number of loaves of bread in a bakery, (ii) the number of Lego pieces inside a house, and (iii) the number of coins in...
-
Cite at least two possible choices of system in each of the following situations. For each choice, make a sketch showing the system boundary and state which objects (excluding air) are inside the...
Study smarter with the SolutionInn App