Scenario
In conjunction with taking MIS 200, Drexel has decided to test the idea of offering weekend seminars to cover the basics of the Internet and the Web. Initially, Drexel will offer two such seminars: Web101 - The Basics of the Web and Internet, and Web205 - Building a Web Site. Web 101 will have five different sections, and Web 205 will have four different sections.
Although they are not required to, students can enroll in one or both seminars. The seminars are held for eight hours on a single day. There is no cost associated with taking the seminars. One instructor, from a pool of qualified instructors, will be assigned to each section of each seminar. Some instructors will obviously not be assigned to teach any of the sections, and some instructors may be assigned to several different sections.
The system should track the final grades assigned to each student. Drexel is simply testing this idea in this particular term. So, don't worry about the term (e.g., Fall, Winter, Spring, or Summer) or the year.
Phase 1
For the above scenario, create a simple two-column table that lists all the entity classes in the left column and their associated primary keys in the right column. Then, record as many business rules as you can find provided in the scenario.
Phase 2
In this phase, define and draw the basic relationships among the entity classes.
If you correctly completed Phase 1, you know there are four entity classes.
Your task is to define among which of those entity classes relationships exist and then write some verbs that describe each relationship.
Phase 3
In this phase, you are to define the cardinality among entity classes.
Your tasks is to create the numerical relationships by adding the symbols of |, O, and ← (crow's foot) in the appropriate places.
Phase 4
In this phase, you are to eliminate a many-to-many relationship. If you correctly completed phase 3, you will be able to identify a many-to-many relationship between _____ and ______. You need to eliminate this many-to-many relationship by creating an intersection relation. What did you name the intersection relation? What does the completed E-R diagram look like?