ISM 4212 Sample Exam 4   

Situation: Students take courses. Courses can have one or more sections. A student can be in only section of a course, but may be in several sections, if they are of different courses. Sections can have one or many students. Final grades are assigned to each student in each course at the end of the term.

Information requirements: 1. List the courses. 2. List the students with their course section and course name  and final grade. 3. List the courses and their sections. 4. Calculate an average grade point average for each course. 5. Calculate an average grade point average for each section.

For the above situation: Develop an ERD for a database which supports ONLY the information requirements specifically listed and numbered. Include all of your attributes on the ERD. Denote PKs. Develop SQL Create Table statements for the database design.

Implement your design for the above situation in MS-ACCESS. Include all Create statements as saved queries. Develop SQL Select statements for all reports. Have dropdown combo box everywhere they are appropriate. Have at least one multi-table form. Include a main menu. Include report-writer reports for each of the information requirements.