IEE 305 Homework Assignment 4

RoomNo CourseNo PeriodNo

CDN-60 IEE300 P04

COORL1-74 IEE376 P01

COOR170 IEE385 P05

BA241 ACC232 P11

BA365 ACC340 P02

CLCC107 STP315 P06

CLCC238 STP421 P07

ISTB2175 CEE351 P10

ISTB2175 CEE486 P03

BAC116 ECN211 P08

ED216 ECN453 P09

InstructorID CourseTitle Prerequisites CreditHours CoureLevel CourseNo NewOffer

In01 Economic Analysis for Engineers 200-level 3 Junior IEE300 false

In02 Operations Research 200-level 3 Junior IEE376 true

In03 Engineering statistics and probability 200-level 3 Junior IEE385 false

In04 Financial Accounting 100-level 3 Sophomore ACC232 true

In05 External Reporting 200-level 3 Junior ACC340 false

In06 Statistical Computing 200-level 3 Junior STP315 false

In07 Probability 300-level 3 Senior STP421 false

In08 Geotechnical Engineering 200-level 3 Junior CEE351 false

In09 Concrete Structure 300-level 3 Senior CEE486 false

In10 Macroeconomic Priciples 100-level 3 Sophomore ECN211 true

IN10 Industrial Organization 300-level 3 Senior ECN453 false

WER101 false

Name Address Department College specialty InstructorID

Jennings 121 Mill Ave. IEE Eng In01

Clough 32 College Ave. IEE Eng In02

Chattin 219 Oragne St. IEE Eng In03

Rasono 738 Rural Rd. ACC Bus In04

Huston 1975 University Dr. ACC Bus In05

Shanno 439 Forest Ave. STP Sci In06

Wang 24 Vista Del Cerro Rd. STP Sci In07

Lawrence 321 Hardon Dr. CEE Eng In08

Fox 178 101 Loop Dr. CEE Eng In09

Geogan 123 Apache Blvd. ECN Bus In10

StartTime PeriodNo Days EndTime Assigned

12/30/99 P01 M W 12/30/99 true

12/30/99 P02 M W 12/30/99 true

12/30/99 P03 M W 12/30/99 true

12/30/99 P04 T Th 12/30/99 true

12/30/99 P05 T Th 12/30/99 true

12/30/99 P06 T Th 12/30/99 true

12/30/99 P07 T Th 12/30/99 true

12/30/99 P08 T Th 12/30/99 true

12/30/99 P09 T Th 12/30/99 true

12/30/99 P10 F 12/30/99 true

12/30/99 P11 F 12/30/99 true

12/30/99 P12 M W 12/30/99 false

12/30/99 P13 F 12/30/99 false

StudentID CourseNo

S01 IEE300

S01 STP315

S02 ACC232

S02 IEE376

S03 ACC340

S03 STP315

S04 IEE300

S04 IEE385

S05 STP315

S05 STP421

S06 STP421

S06 IEE376

S07 CEE351

S07 IEE376

S08 CEE486

S08 IEE385

S09 IEE376

S09 STP421

S10 ECN211

S10 IEE300

S11 ECN453

S11 STP315

S12 STP315

S12 IEE300

S13 ACC340

S13 STP315

S14 IEE300

S14 CEE351

S15 CEE351

S15 IEE376

S16 CEE486

S16 STP315

S17 IEE385

S17 ACC340

S18 IEE376

S18 IEE385

S19 ECN453

S19 ECN211

S20 STP421

S20 IEE385

S21 CEE486

S21 CEE351

S22 CEE351

S22 CEE486

Location Capacity FeasureDescription RoomNo

Design North 810 S. Forest Mall 6 Normal CDN-60

976 S. Forest Mall 7 Normal COORL1-74

976 S. Forest Mall 6 Normal COOR170

300 E. Lemon St. 1 Multi-Media BA241

300 E. Lemon St. 4 Multi-Media BA365

13493 N. 47th Ave. 8 Multi-Media CLCC107

13493 N. 47th Ave. 5 Multi-Media CLCC238

850 S. McAllister Ave. 5 Multi-Media ISTB2175

400 E. Lemon St. 2 Normal BAC116

1050 S. Forest Mall 2 Normal ED216

Name Address Birthday StudentID Gender Department College

James S01 M IEE Eng

Margaret S02 F ACC Bus

Robert S03 M ACC Bus

Karen S04 F IEE Eng

William S05 M STP Sci

Dorothy S06 F STP Sci

Richard S07 M CEE Eng

Sandra S08 F CEE Eng

Thomas S09 M IEE Eng

Ashley S10 F ECN Bus

Christopher S11 M ECN Bus

Kimberly S12 F STP Sci

Matthew S13 M ACC Bus

Donna S14 F IEE Eng

Donald S15 M CEE Eng

Michelle S16 F CEE Eng

Paul S17 M IEE Eng

Amanda S18 F IEE Eng

George S19 M ECN Bus

Melissa S20 F STP Sci

Curry S21 M CEE Eng

Emily S22 F CEE Eng

SELECT Period.Days, Period.StartTime, Period.EndTime, Instructor.Name
FROM Period INNER JOIN (Instructor INNER JOIN (Course INNER JOIN Assign ON Course.CourseNo = Assign.CourseNo) ON Instructor.InstructorID = Course.InstructorID) ON Period.PeriodNo = Assign.PeriodNo
WHERE (((Instructor.Name)=[Enter a professor’s name]));
SELECT Course.CourseNo, Period.Days, Period.StartTime, Period.EndTime, Student.StudentID
FROM Student INNER JOIN (Period INNER JOIN ((Course INNER JOIN Assign ON Course.CourseNo = Assign.CourseNo) INNER JOIN Register ON Course.CourseNo = Register.CourseNo) ON Period.PeriodNo = Assign.PeriodNo) ON Student.StudentID = Register.StudentID
WHERE (((Student.StudentID)=[Please enter students ID]));
SELECT Period.EndTime, Course.CourseTitle, Period.Days, Period.StartTime
FROM Period INNER JOIN (Course INNER JOIN Assign ON Course.CourseNo = Assign.CourseNo) ON Period.PeriodNo = Assign.PeriodNo
WHERE (((Course.CourseTitle)=[Please enter course name]));
SELECT Register.CourseNo, Count(Register.StudentID) AS [Total Register# of Students], Room.RoomNo, Room.Capacity, Room.FeasureDescription
FROM Room INNER JOIN ((Course INNER JOIN Assign ON Course.CourseNo = Assign.CourseNo) INNER JOIN Register ON Course.CourseNo = Register.CourseNo) ON Room.RoomNo = Assign.RoomNo
GROUP BY Register.CourseNo, Room.RoomNo, Room.Capacity, Room.FeasureDescription
ORDER BY Count(Register.StudentID);
SELECT Course.CourseNo, Course.CourseTitle, Course.NewOffer
FROM Course
WHERE (((Course.NewOffer)=Yes));
SELECT Course.CourseNo, Period.Days, Period.StartTime, Period.EndTime, Instructor.Department, Course.CoureLevel
FROM Period INNER JOIN (Instructor INNER JOIN (Course INNER JOIN Assign ON Course.CourseNo = Assign.CourseNo) ON Instructor.InstructorID = Course.InstructorID) ON Period.PeriodNo = Assign.PeriodNo
WHERE (((Instructor.Department)=[Please enter department name]) AND ((Course.CoureLevel)=[Please enter course level]));
SELECT Room.RoomNo, Period.PeriodNo, Period.Days, Period.StartTime, Period.EndTime
FROM Room, Period
GROUP BY Room.RoomNo, Period.PeriodNo, Period.Days, Period.StartTime, Period.EndTime, Period.Assigned
HAVING (((Period.Assigned)=No))
ORDER BY Period.Days;