Information System Analysis Lab 7 ERD entityrelationship diagram
![Information System Analysis Lab 7 Information System Analysis Lab 7](https://slidetodoc.com/presentation_image/e1d094a0d94fd26d378a53ed9e107e3a/image-1.jpg)
Information System Analysis Lab 7
![ERD • entity-relationship diagram is a data modeling technique that creates a graphical representation ERD • entity-relationship diagram is a data modeling technique that creates a graphical representation](http://slidetodoc.com/presentation_image/e1d094a0d94fd26d378a53ed9e107e3a/image-2.jpg)
ERD • entity-relationship diagram is a data modeling technique that creates a graphical representation of the entities, and the relationships between entities.
![Components used in the creation of an ERD • Entity – A person, place Components used in the creation of an ERD • Entity – A person, place](http://slidetodoc.com/presentation_image/e1d094a0d94fd26d378a53ed9e107e3a/image-3.jpg)
Components used in the creation of an ERD • Entity – A person, place or thing about which we want to collect and store multiple instances of data. It has a name, which is a noun, and attributes which describe the data we are interested in storing. It also has an identifier.
![Components used in the creation of an ERD • Relationship – Illustrates an association Components used in the creation of an ERD • Relationship – Illustrates an association](http://slidetodoc.com/presentation_image/e1d094a0d94fd26d378a53ed9e107e3a/image-4.jpg)
Components used in the creation of an ERD • Relationship – Illustrates an association between two entities. It has a name which is a verb.
![Crow’s foot symbol Ring represent zero Dash represent one Crow’s foot represent many Crow’s foot symbol Ring represent zero Dash represent one Crow’s foot represent many](http://slidetodoc.com/presentation_image/e1d094a0d94fd26d378a53ed9e107e3a/image-5.jpg)
Crow’s foot symbol Ring represent zero Dash represent one Crow’s foot represent many
![Chen and Crow’s foot notations One-to-many (1: M) relationship: Chen notation Crow’s foot notation Chen and Crow’s foot notations One-to-many (1: M) relationship: Chen notation Crow’s foot notation](http://slidetodoc.com/presentation_image/e1d094a0d94fd26d378a53ed9e107e3a/image-6.jpg)
Chen and Crow’s foot notations One-to-many (1: M) relationship: Chen notation Crow’s foot notation a painter can paint many painting ; each painting is painted by one painter
![Chen and Crow’s foot notations many-to-many (M: N) relationship: Chen notation Crow’s foot notation Chen and Crow’s foot notations many-to-many (M: N) relationship: Chen notation Crow’s foot notation](http://slidetodoc.com/presentation_image/e1d094a0d94fd26d378a53ed9e107e3a/image-7.jpg)
Chen and Crow’s foot notations many-to-many (M: N) relationship: Chen notation Crow’s foot notation an Employee can learn many skills; each skill can be learned by many employees.
![Chen and Crow’s foot notations one-to-one(1: 1) relationship: Chen notation Crow’s foot notation an Chen and Crow’s foot notations one-to-one(1: 1) relationship: Chen notation Crow’s foot notation an](http://slidetodoc.com/presentation_image/e1d094a0d94fd26d378a53ed9e107e3a/image-8.jpg)
Chen and Crow’s foot notations one-to-one(1: 1) relationship: Chen notation Crow’s foot notation an Employee can manages one store; each store is managed by one employee.
![Chen and Crow’s foot notations Chen and Crow’s foot notations](http://slidetodoc.com/presentation_image/e1d094a0d94fd26d378a53ed9e107e3a/image-9.jpg)
Chen and Crow’s foot notations
![Using Visio to Draw ERD Using Visio to Draw ERD](http://slidetodoc.com/presentation_image/e1d094a0d94fd26d378a53ed9e107e3a/image-10.jpg)
Using Visio to Draw ERD
![• A student fills a seat. This is a 1: 1 relationship. 1 • A student fills a seat. This is a 1: 1 relationship. 1](http://slidetodoc.com/presentation_image/e1d094a0d94fd26d378a53ed9e107e3a/image-11.jpg)
• A student fills a seat. This is a 1: 1 relationship. 1 student can fill a maximum of 1 seat can be filled by a maximum of 1 student. • A student takes a course. This is a M: M relationship. One student can take many courses, and one course can be taken by many students. -a student must take at least one course, and a course must be taken by at least one student. • An instructor teaches a course. This is a 1: M relationship. One instructor can teach many courses, but one course can only be taught by one instuctor. – an instructor must teach at least 1 course, and a course must be taught by 1 instructor.
![• Starting a New Database Model Diagram Choose File, New, Database Model Diagram • Starting a New Database Model Diagram Choose File, New, Database Model Diagram](http://slidetodoc.com/presentation_image/e1d094a0d94fd26d378a53ed9e107e3a/image-12.jpg)
• Starting a New Database Model Diagram Choose File, New, Database Model Diagram
![• Starting a New Database Model Diagram To set the modeling options you • Starting a New Database Model Diagram To set the modeling options you](http://slidetodoc.com/presentation_image/e1d094a0d94fd26d378a53ed9e107e3a/image-13.jpg)
• Starting a New Database Model Diagram To set the modeling options you want to use, choose Database, Options, Document
![](http://slidetodoc.com/presentation_image/e1d094a0d94fd26d378a53ed9e107e3a/image-14.jpg)
![](http://slidetodoc.com/presentation_image/e1d094a0d94fd26d378a53ed9e107e3a/image-15.jpg)
![](http://slidetodoc.com/presentation_image/e1d094a0d94fd26d378a53ed9e107e3a/image-16.jpg)
![](http://slidetodoc.com/presentation_image/e1d094a0d94fd26d378a53ed9e107e3a/image-17.jpg)
![](http://slidetodoc.com/presentation_image/e1d094a0d94fd26d378a53ed9e107e3a/image-18.jpg)
![Format line Format line](http://slidetodoc.com/presentation_image/e1d094a0d94fd26d378a53ed9e107e3a/image-19.jpg)
Format line
![](http://slidetodoc.com/presentation_image/e1d094a0d94fd26d378a53ed9e107e3a/image-20.jpg)
![ERD Using Visio ERD Using Visio](http://slidetodoc.com/presentation_image/e1d094a0d94fd26d378a53ed9e107e3a/image-21.jpg)
ERD Using Visio
- Slides: 21