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.
The ready solutions purchased from Library are already used solutions. Please do not submit them directly as it may lead to plagiarism. Once paid, the solution file download link will be sent to your provided email. Please either use them for learning purpose or re-write them in your own language. In case if you haven't get the email, do let us know via chat support.
Get Free Quote!
270 Experts Online