IEE 305 Homework Assignment 4

HW3_Project_Solution.accdb

Home >Information Systems homework help >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	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	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;