Data Modeling Homework

IS 441 Data Modeling Homework

20, + 4 extra points

Please follow the “Official Homework Requirements” right on top of the class schedule.

Use Microsoft Visio or Drawing tools in Word/PPT to develop the ERDs for all ERD HWs.

Problem 1 (6 pts). – (1) Follow the format of the entity definitions on P.57 of the text, define the entity [ENTITY! Not attributes] given below according to your last name; (2) identify two distinguishing attributes of the entity: A~C: A BIZ MEETING inside a company (i.e., no customer); D~P: A CONFERENCE of a professional association; O~Z: A political MEETING ( of local party supporters ).

Problem 2 (8 points).

Business rules, and ER diagram with cardinality. (TWO E-R diagrams for this problem)

(1) Create business rule(s) for the given business scenario. Please follow the format of definitions and the statements of business rules on PP. 58-59. You are FREE to make YOUR OWN assumptions – clearly state your assumptions. Remember: for each relationship, you need to state from both directions .

(2) Based on the rules, create the ER diagram ( ONE diagram reflecting all rules ).

(3) Then make a/some change(s) in the assumptions that will lead to change(s) in cardinality (or even the relationship), and create the revised ER diagram.

You are assigned ONE problem (by last name) from the following (all have associative entity):

Business Scenario	Last Name
1. CUSTOMER books RENTAL-CONTRACT, CAR is rented in RENTAL-CONTRACT	Aa~Al
2. DRIVER receives CITATION, POLICE issues CITATION	Al~C
3. BUYER buys HOME, AGENT sells HOME	D~G
4. STUD-ORG makes BOOKING (of ROOM), ROOM is booked in BOOKING.	H~P
5. （Library）PATRON has CHECK-OUT, BOOK appears in CHECK-OUT	Q~T
6. TUTOR has APPOINMENT, STUDENT comes to APPOINTMENT	U~Z
1) All entities are in CAPS; 2) No attribute except keys (PK, FK); 3) All relationships are already given; please do NOT “introduce” your own relationship; in other words, ONLY depict what is explicitly given.

Problem 3 (5 points).

Create one E-R diagram for the 3 entities given below, with attributes (given in a simplified manner):

(1) INSTRUCTOR: Each instructor may teach many COURSEs or none, each instructor may use many TEXTBOOKs (for different courses);

(2) Each COURSE must be taught by at least one INSTRUCTOR, each COURSE may use many TEXTBOOKs;

(3) Each TEXTBOOK may be used in many COURSEs or none, each TEXTBOOK may be used by many INSTRUCTORs or none.

The ERD needs to keep track of the requirement status (Req’d or Optional) of a textbook, for a specific semester.

Write any business rules that help to clarify your construction of the ERD.

If there needs to be any associative entity, create as your logic supports (and please state your reasoning, possibly with the support of citation of the text), and correctly indicate the entity’s attributes.

Problem 4 (5 points). Chapter 2, end of chapter “Problems and Exercises”: P. 103, 2-39e [Note: THREE variations of ERDs]