Week 1 Entity Relationship Diagrams – CROWS FEET
Description: Week 1 Entity Relationship Diagrams CROWS FEET NOTATION Part 7 CS3319 1 Student Objectives Upon completion of this video, you should be able to: Use the new notation, Crows Feet Notation, to create an ER Diagram. CS3319 2 Newer
Related Topics
Download Presentation
"Week 1 Entity Relationship Diagrams – CROWS FEET" is the property of its rightful owner. Permission is granted to download and print the materials on this website for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Presentation Transcript
slide1. Week 1 Entity Relationship Diagrams – CROWS FEET NOTATION – Part 7 CS3319 1<br>
slide2. Student Objectives Upon completion of this video, you should be able to:
Use the new notation, Crow’s Feet Notation, to create an ER Diagram. CS3319 2<br>
slide3. Newer Notation – Crow’s Foot Notation - ENTITIES Instead of this:
Do this: 5/25/2018 C53319 3 Patient OHIPNum FirstName LastName Patient
OHIPNum
FirstName
LastName<br>
slide4. Crow’s Foot Notation - RELATIONSHIPS Relationship indicated with just a line
End of the line indicates the cardinality AND the participation:
Zero or more
One or more
One and only one
Zero or 1 5/25/2018 C53319 4<br>
slide5. Examples One to One ïƒ
One to Many ïƒ
Many to Many ïƒ
One to Many ïƒ
Question: What is the participation on each example? 5/25/2018 C53319 5<br>
slide6. More examples Video Description 5/25/2018 C53319 6<br>
slide7. QUESTION: Draw the ER diagram for the following using Crow’s Foot Notation Entities:
Customer (customers may have never purchased from us before)
Movie (movies we have in our system)
Copy of DVD (actual DVD someone rents)
Show the relationships: currently renting, and is a
ANSWER: 5/25/2018 C53319 7 CUSTOMER
CustomerID
FirstName
LastName DVDCOPY
DVDID
HomeStore MOVIE
MovieID
Title
Year Currently renting Is a<br>
slide2. Student Objectives Upon completion of this video, you should be able to:
Use the new notation, Crow’s Feet Notation, to create an ER Diagram. CS3319 2<br>
slide3. Newer Notation – Crow’s Foot Notation - ENTITIES Instead of this:
Do this: 5/25/2018 C53319 3 Patient OHIPNum FirstName LastName Patient
OHIPNum
FirstName
LastName<br>
slide4. Crow’s Foot Notation - RELATIONSHIPS Relationship indicated with just a line
End of the line indicates the cardinality AND the participation:
Zero or more
One or more
One and only one
Zero or 1 5/25/2018 C53319 4<br>
slide5. Examples One to One ïƒ
One to Many ïƒ
Many to Many ïƒ
One to Many ïƒ
Question: What is the participation on each example? 5/25/2018 C53319 5<br>
slide6. More examples Video Description 5/25/2018 C53319 6<br>
slide7. QUESTION: Draw the ER diagram for the following using Crow’s Foot Notation Entities:
Customer (customers may have never purchased from us before)
Movie (movies we have in our system)
Copy of DVD (actual DVD someone rents)
Show the relationships: currently renting, and is a
ANSWER: 5/25/2018 C53319 7 CUSTOMER
CustomerID
FirstName
LastName DVDCOPY
DVDID
HomeStore MOVIE
MovieID
Title
Year Currently renting Is a<br>