VOICE - Mail Order Sales and Services
INSS 640 - Fall 1996
Mini Project B - Create a simplified Entity-Relationship (E-R) diagram.
In this part of the project you are concentrating in creating a blueprint of the data base (DB) for the mail order system for Voice, using a simplified E-R diagram. You should use Freelance or another graphical package and:
- identify the entities involved in the Voice Mail Order system
- draw a simplified E-R diagram for Voice:
- draw the entities as rectangles.
- draw lines connecting the rectangles with arrows pointing to and from another rectangle to indicate a relation from each entity to another.
- write 1 or M on top of the lines, if one entity can "have" or "do" one or many things to another entity, respectively. Replace in your mind have or do with a verb that can better express the relation (see class examples).
- apply the five DB principles seen in class to the case, taking into consideration the relations you found before, and
- write in the bottom of the diagram the DB design for the Voice Mail Order system in relational notation.
This page is maintained by Al Bento
who can be reached at abento@ubmail.ubalt.edu. This page was last updated on March 24, 1996. Although we will attempt to keep this information accurate, we can not guarantee the accuracy of the information provided.