Choose one of the following four topics:
- United States Government
- Local Church or Community Group
- Hospital
- Library
- Charitable Organization
Using your chosen topic, identify at least one example of a one-to-one relationship, one-to-many relationship and a many-to-many relationship.
Document the relationships you identified by justifying/explaining each of the relationship examples. Describe in terms of how both entities are related to each other. Each example should be one or two sentences.
Create a visual representation of the relationships in an entity relationship diagram. The ERD should include: entity names, attributes, relationships and unique identifiers.
For each entity, provide at least eight instances of sample data. This should be done in Microsoft Word. Create a table for each entity with attributes as columns and the sample data instances as rows. Your chosen sample data should help illustrate the relationship types.
Deliverable: One Word document with:
- Name of chosen topic
- Relationship type examples with justifications
- ERD
- Sample data
Fill out acoording to provided sample and template, Must be orginal and non plagarized
0 comments