IS 441 Database Management Entity Tables Sample Paper.
Three problems, 20 points
Use Microsoft Visio or Drawing tools in Word/PPT to develop the ERDs for all ERD HWs.
Problem 1 (5 pts).
(1) Follow the format of the entity definitions on P.59 of the text, define the entity [define ENTITY! Not define attributes] given below;
(2) in the entity defined in step (1), identify one distinguishing/defining attributes of the entity.IS 441 Database Management Entity Tables Sample Paper.
ORDER A CUSTOM-WRITTEN, PLAGIARISM-FREE PAPER HERE
Entity to be defined: a real estate agent serving a certain geographical region (i.e., not necessarily those within the same company, but those serving the same geo region).
Problem 2 (9 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):
ORDER A CUSTOM-WRITTEN, PLAGIARISM-FREE PAPER HERE
| Business Scenario | Last Name |
| 1. DRIVER receives CITATION, POLICE issues CITATION | A-G |
| 2. TUTOR has APPOINMENT, STUDENT comes to APPOINTMENT | H-R |
| 3. CUSTOMER books RENTAL-CONTRACT, CAR is rented in RENTAL-CONTRACT | S-Z |
| 4. STUD-ORG makes BOOKING (of ROOM), ROOM is booked in BOOKING. | No-credit exercises |
| 5. （Library）PATRON has CHECK-OUT, BOOK appears in CHECK-OUT | |
| 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 (6 points). Chapter 2, end of chapter “Problems and Exercises”: P. 105, 2-39e
[Note: THREE variations of ERDs]
Please follow the “Official Homework Requirements” on top of the class schedule.IS 441 Database Management Entity Tables Sample Paper.