Answered step by step
Verified Expert Solution
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
- 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.
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started