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...
-
1. Should the executive board have fired Tim for failing to live up to expectations? What alternatives are there? 2. What could the board have done to help Tim address these disruptive behaviors? 3....
-
Selected data concerning the past years operations of the Ozarks Manufacturing Company are as follows: Required: 1. What was the cost of raw materials purchased during the year? 2. What was the...
-
What is the objective of OT&E?
-
The executive team at Current Designs has gathered to evaluate the companys operations for the last month. One of the topics on the agenda is the special order from Huegel Hollow, which was presented...
-
Explain by giving examples the causes of the differences between taxable income and accounting income ( 5 Marks ) b . Dolphin Company Limited has results of its operations for the year 2 0 1 4 as...
-
b. Prepare all consolidating entries needed to prepare consolidated statements for 20X5. (If no entry is required for a transaction/event, select "No journal entry required" in the first account...
-
Juicy Froots Company is being sued by a former employee. The lawsuit claims that Candi Barrs suffered emotional pain and trauma as a result of having to have all of her teeth removed. As an employee...
-
The promises exchanged by parties to a contract. a. competent pa rty b. consideration c. divisible c ontract d. entire, or indivisible, contract e. executed c ontract f. executory c ontract g....
-
Indicate whether each of the following statements is true or false by writing T or F in the answer column. Workers compensation laws are designed to ensure that all employees are paid fairly.
-
Indicate whether each of the following statements is true or false by writing T or F in the answer column. Acts of an employee while performing duties of employment are considered the acts of the...
-
A person who is of legal age and normal mentality. a. competent pa rty b. consideration c. divisible c ontract d. entire, or indivisible, contract e. executed c ontract f. executory c ontract g....
-
You are considering opening your own photography studio specializing in weddings and other events. You think that there is a 40% probability of your business being successful, at which point you will...
-
Ken and Daniel always eat miso soup and sushi in exact proportions: Ken eats one miso per two sushi; Daniel eats two miso per one sushi. They throw away any extra soup or sushi as it would not give...
-
Apply Jacobis method to the given system. Take the zero vector as the initial approximation and work with four-significant-digit accuracy until two successive iterates agree within 0.001 in each...
-
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?
-
The inversion point of a gas can be mathematically expressed as (a) \(T_{i}=\frac{2 a b}{R}\) (b) \(T_{i}=\frac{2 b}{R a}\) (c) \(T_{i}=\frac{2 a}{R b}\) (d) None of these.
-
Residual free energy is defined as (a) \(G^{R}=G-G^{\mathrm{ig}}\) (b) \(G^{R}=G^{\mathrm{ig}}-G\) (c) \(G^{R}=G+G^{\mathrm{ig}}\) (d) None of these.
-
Departure functions are useful to calculate the thermodynamic property of real fluids (a) When the \(P-V-T\) data of the substance is unavailable (b) When the \(P-V-T\) data of the substance is...
Study smarter with the SolutionInn App