How to create erd in visio 2016

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.

C:\Users\eugene\AppData\Local\Microsoft\Windows\INetCache\Content.Word\Elementary school database .jpg

Important Decisions and Assumptions made during constructing ERD.

· Each student is identified using a unique number throughout the student’s school year

· Each teacher has a unique code that identifies him or her

· A teacher must be certified by a board and given a unique number.

· A parent can have one or more students in the school

· A teacher must oversee any sport

· A teacher can teacher can teach 2 or 3 subjects.

· A weak entity is the contact details since the student and the parents share the same contacts. So, the primary key of both is used to make the table.

References

Harrington, J. L. (2009). Relational Database Design and Implementation. 3rd Ed. Amsterdam: Morgan Kaufmann. Retrieved from http://vlib.excelsior.edu/login?url=http://search.ebscohost.com/login.aspx?direct=true&db=nlebk&AN=319641&site=eds-live&scope=site

Microsoft. (2016). Tutorial for Visio 2016. Retrieved from:

https://support.office.com/en-us/article/Tutorial-for-Visio-2016-c8fd9b8b-6e8c-4252-937d-a0eea0cddd94