For the project web-based Technical Institute DB, perform the following using Rational Rose:

(1)  Construct a reasonable top level use case diagram for the project.
(2)  List the use cases with the top three priorities to be implemented.
(3)  Construct a reasonable top level class diagram for the project.  In the minimum, you should include documentation for classes.  Attribute and association documentation are optional, but they are encouraged when they are not trivial.

Create a directory '\5931\pgm' in your Discovery NT account, save your Rational Rose file as proj1.mdl.  Do not change this file after you turn in your work.  Otherwise, it may not be graded.  Turn in a cover sheet with your name and your Discovery account name.  I will write my grading comments in this cover paper and return it to you.
 
The Technical Institute DB

A small technical institute wants to build a web-based database system to supports its operations.  The technical institute offers courses for students to enroll.

There are different users of the system.  For all users in the system, basic information, including names, addresses, phone numbers and email addresses should be kept.  For students, their work company names, company addresses and phone numbers should also be kept.

A student may enroll in as many course as he likes.  A course includes a course number, a title, a number of credit hours, a number of lecture hours, a description and a tuition.  A course is offered by a department (e.g. MSFT for Microsoft's Technology, ORCL for ORacle's Technology, PROG for general programming, etc).  A department provides certificate programs (e.g. Microsoft's internet application development, Microsoft's database development, etc).  A certificate program includes many courses (e.g. MSFT1001, MSFT1002, MSFT1003, etc).  A course may have many prerequisites (e.g. MSFT1003 may requires MSFT1002 and MSFT1001).  For a certificate program, an ID, its name and a description should be stored.  For a department, an ID and its name should be stored.

A student may transfer some courses from other institutions to satisfy courses here.  If a course is transferred to satisfy MSFT1001, for example, then the course number, course name, institute name and date of taking the course should be recorded.

There are many classrooms in the institute.  Not all classrooms support all courses as different courses have different requirements.  For example, classroom C101 may support MSFT1001 and MSFT1002, but not MSFT1003.  A classroom has a classroom number (e.g. C101) and a seating size.  A course should not be scheduled to use a classroom that does not support the course.

A course may be offered many times during the year.  Each course offering is a set of meeting times which include the information of a meeting date, a start time, an end time and the classroom used.

A course is taught by one faculty member, who belongs to a department.  Each department has a chairperson.  Sometimes, a department may not have a chairperson during transitional period.  A chair person of a department must be a faculty member of the same department.

A faculty member teaching a course has an hourly rate, which may differ for different course offerings.  The hourly rate is set by the chair person of the department.  An instructor can record and retrieve dated teaching notes on a course offering (e.g. "The background of the course is more diversified than usual.) or on a student in the class (e.g. "Student K. Yue seems not paying any attention to my lecture.").

A student taking a course gets a grade.  The current grades are 'A', 'B', 'C', 'D', 'P' and 'F'.  Each grade has a description of its meaning.

A student taking a course may evaluate the course more than once (e.g. mid-way and final evaluations).  The date of a student evaluation should be recorded.  Students can also write comments into their evaluation.

A given course uses a specific evaluation form.   An evaluation form may be shared by many courses.  There is an unique ID for an evaluation form.  There are also a name and a description for an evaluation form.  An evaluation form contains question sets.  A question set contains a group of questions which use the same sets of choices.  For examples, the following question set contains three questions.  Each question can be answered by selecting one of the following seven choices.

(1)  What is the overall quality of the course?
(2)  What is the overall quality of the instruction?
(3)  What is the overall quality of the instructional materials?

The choices for these questions are:

(1)  Excellent
(2)  Very Good
(3)  Good
(4)  Satisfactory
(5)  Poor
(6)  Very Poor
(7)  Disastrous

Various kind of statistics should be generated from the evaluation forms.  For example, it should be possible to find out the average answer to the overall quality of the course question for the course offerings of MSFT1001.

A clerk handles registration for students.  All tuition must be paid during registration.  A registration may be for multiple enrollment.  A discount may be applied to an individual enrollment (such as preferred customer discounts) and/or to the entire registration (such as group discounts).  There are predefined discount types (such as preferred customer discounts, group discounts, special promotion discounts, IT one day sale, etc).  The discount types and the actual tuition should be stored for enrolments and registrations.  A registration can be paid by either credit cards or checks.  In either case, a receipt is generated with a receipt number and a date.  The receipt number and date should be stored. When payment is made through checks, the bank name, account number and cheque number should be recorded.  When payment is made through credit cards, the holder name, card name, issuing institution, credit number and expiration date.  The institute also set up information about customer credit card account they don't need to be retyped again and again.

Besides clerks and faculty members, there are also administrators (e.g. president, vice presidents, dean of students, etc) that have no limit of access to the database, except for the management of accounts.  On the other hand, an instructor may only have access to the courses that he teaches.  All employees working for the institute should have their social security numbers stored for tax purposes.  Every staff has an unique ID.

To access the system, a person needs an password-protected account.  There are different kinds of accounts (for administrators, faculty members, students, etc).  A person may have only one account.