Assignment

The entity-relationship (ER) diagram is a modeling tool used to create and depict the logical structure of a database. You have interviewed your customer/stakeholder for his/her database management needs in "Conduct Client Interviews" (M2A1) you will take that information and create a preliminary ER diagram for your stakeholder. Please use the IE table/relation notation (also called crow's foot notation) specified in (Harrington, 2009, pages 70-71) to create the ER diagram.

Using Microsoft Visio or an open source alternative such as Dia, create an entity-relationship model for your data management need that you previously documented. when assembling your diagram:

• All entities should have an identifier/primary key

• All attributes should be scalar (i.e., have one and only one value)

• All attributes should have an appropriate data type

• Relationships should be clearly notated with their cardinalities (you may need to create new attributes as foreign keys in order to specify relationships)

• You should convert M:N relationships to composite entities

• There might be weak entities in the diagram

Place a explaining any important or interesting design decisions you made, such as identification and creation of composite entities or weak entities, or how entities are related.

Compose your work in a .doc or .docx file type using a word processor (such as Microsoft Word, etc.) and save it frequently to your computer. For those assignments that are not written essays and require uploading images or PowerPoint slides, please follow uploading guidelines provided by your instructor.