Rules to follow for the Assignment:
Part 1: Create an Entity Relationship Diagram:
Using, ERD Plus, create a conceptual ERD that satisfies these business rules for a Personal Information Manager (PIM): Use ER diagram which is located on the menu tab of ERD PLUS when completing part.
Now these business rules may not be realistic. You may know people who live at multiple addresses, and you certainly know people who hold more than one job. But these rules simplify database creation by eliminating many to many relationships. (The next module tells us how to resolve many to many relationships more realistically.)
A conceptual ERD contains only the entities (there are three) and the relationships between them. Be sure to name each relationship and indicate the cardinality on your diagram. No attributes are required for this part.
Copy your ERD into a Word or Writer file called YourNameERD.
Part 2: Add attributes to ERD
Add a primary key (following our naming standards) to each entity of the ERD created in Part 1. In addition, add these fields (attributes) to the ERD.
|PIM Database Fields|
Put each field in an appropriate entity that reduces data redundancy. For example, WorkAddress could logically be put in Person or Company, but if we put it in Person, redundant information would have to be entered for each person who worked in the same company. It is more efficiently put in Company.
Most fields should be pretty self explanatory. The Role field depicts what role each person plays in the family. We will give the person we most likely want to talk to, the role of 'Main Contact'. After that, the spouse will be 'Spouse', and each child will have the role of 'Child'.
Finally, add foreign keys, as indicated by the relationships.
(The primary key of "the one" becomes a foreign key in "the many". )
Post any questions about the fields to this week's discussion board.
DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma
Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t
Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th
1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of
1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of