CIS-333

ER Modeling Homework-1

Draw a clear and complete ER diagram using the notation we used in class to capture the following database requirements.

Notes:

? If necessary, you can make any reasonable assumptions as long as they dont contradict the specs given below and you state them clearly.

? You can draw this assignment by hand or use some drawing tool (Ill explain DIA later during class).

Design a database to keep data about college students, their academic advisors, the clubs they belong to, the moderators to the clubs, and the activities that the clubs sponsor.

[a] Only some advisors advise students and every student is advised by one advisor only. An advisor may advise several students

[b] Each student can belong to any number of clubs and every club must have one or more students associated with it. You can have students that dont belong to any club.

[c] Each club must be supervised by a moderator. A moderator may supervise several clubs but a club has only one moderator.

[d] Some of the experienced advisors mentor newly hired advisors for the first year. A mentored advisor can have only one mentor while an experienced advisor can mentor several new advisors. The database shall keep track of who mentored whom.

[e] A club may be sponsoring several activities. Each club can only sponsor an activity per date. During a specific date several clubs may be sponsoring activities. It does not make sense to have an activity that is not sponsored by a club.

Additional information to be kept in the database is as follows:

For each student: studId (unique), name and date the student joined a particular club.

For each advisor: advisorId (unique), name and phone(s).

For each club: clubName (unique), budget, meeting date, number of members belonging to the club (generated by the computer)

For each moderator: modId (unique), name, position and date he/she started to be the moderator of the club.

For each activity: activity name, date of the activity, type and location.