ISM3011 - E-Business System Fundamentals
Second Project Information
Use Microsoft Access to develop three reports from the Academic database that you can download.
First, you will want to print the instructions for working with Access RDBMS. This tutorial illustrates how to use ACCESS. It refers to a database named "Sales Example Database." We will use this tutorial and database during class to illustrate the logic of Relational Database Management Systems.
Your assignment utilizes the "Academic Information Database," which can also be copied from the College of Business server using the instructions referenced above.
You can also copy the Academic Information Database from here (file name: ACADEMIC.MDB) (note: file is in Access 2000 format)
You can also copy the Academic Information Database in Office 97 format from here (file name: ACADEMIC97.MDB) (note: file is in Access 97 format for students who don't have Office 2000)
The files in the "Academic Information Database" are:
Student Information File - the file of Student Data
- Student Number - Six digit student number (just like at USA)
- Student Name
- Student Major Code - Three character code of department of student major
- Grade Point Average - Student grade point average
Department Information File - the file of College Departments
- Department Code - Three character code of department
- Department Name
Professor Information File - the file of Professor Information
- Professor Code - Three character professor code (WAB)
- Professor Name
Classes Offered File - the file of Classes Offered during the quarter
- Course ID Code - the unique four digit class identification code
- Department Code - the three character College Department code (MGT for example)
- Course Number - the class number (503 for example)
- Course Section - the class section (01 for example)
- Course Description - the class description (Management Information Systems for example)
- Professor Code - the code of the professor teaching the class
- Course Fee - the special fee for taking the course
Course Enrollment File - the file of students enrolled in classes
- Course Identification Number- the unique four digit class identification code
- Student Number - the student number of the student enrolled in the class
- Course Grade - the letter grade of the student in the course
Your assignment is to create the queries necessary to prepare three reports:
- Report of Enrollment by Class
- Report of Enrollment by Student
- Report of Enrollment by Professor
Your challenge is to develop the relationships necessary to create these reports, then produce the reports. As always, your FIRST task is to take pencil and paper in hand and develop the report formats as well as the relationships between data files necessary to provide all data.
Once your database is complete, e-mail it to me as an attachment. Use this file naming convention: FirstNameLastNameProj2.mdb
Return to ISM3011 Page