Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

  1. Show the top student(s) (the one with the highest GPA) of each major.
  2. List students who are taking a course(s) and its prerequisite(s) at the same time.
  3. List the earliest class (in terms of starting time) of each instructor.
  4. staff StaffID INT(11) StfFirstName VARCHAR(25) StfLastname VARCHAR(25) HH StfStreetAddress VARCHAR(50) 

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

Step by Step Solution

3.34 Rating (157 Votes )

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Accounting Information for Decision-Making and Strategy Execution

Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young

6th Edition

137024975, 978-0137024971

More Books

Students also viewed these Databases questions

Question

What was the positive value of Max Weber's model of "bureaucracy?"

Answered: 1 week ago