lecture-10-er-diagrams-continued

lecture-10-er-diagrams-continued - The Entity-Relationship...

Info iconThis preview shows pages 1–11. Sign up to view the full content.

View Full Document Right Arrow Icon
The Entity-Relationship Model Continued T. M. Murali September 27, 2010 T. M. Murali September 27, 2010 CS 4604: E/R model
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Roles in Relationships I Can the same entity set appear more than once in the same relationship? T. M. Murali September 27, 2010 CS 4604: E/R model
Background image of page 2
Roles in Relationships I Can the same entity set appear more than once in the same relationship? I Prerequisite relationship between two Courses PreReq Courses Enrollment Classroom Name I Which course is the pre-requisite? T. M. Murali September 27, 2010 CS 4604: E/R model
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Roles in Relationships I Which course is the pre-requisite? I Label the lines connecting entity to relationship with the role of the entity. Requirement Requirer PreReq Courses Enrollment Classroom Name T. M. Murali September 27, 2010 CS 4604: E/R model
Background image of page 4
Parallel Relationships I Can there be more than one relationship between the same pair of entities? T. M. Murali September 27, 2010 CS 4604: E/R model
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Parallel Relationships I Can there be more than one relationship between the same pair of entities? I TA and Take relationship between Students and Classes Courses TA Take Students T. M. Murali September 27, 2010 CS 4604: E/R model
Background image of page 6
Are Attributes on Relationships Needed? Students Courses Take Name Address Enrollment Classroom Name Grade T. M. Murali September 27, 2010 CS 4604: E/R model
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Are Attributes on Relationships Needed? Students Courses Take Name Address Enrollment Classroom Name Grade I We can convert the attribute to an entity and make the relationship multiway. Students Courses Take Name Address Enrollment Classroom Name Grade Grade T. M. Murali September 27, 2010 CS 4604: E/R model
Background image of page 8
Multiway Relationships I Relationships may connect more than two entity sets. I Consider scenario two in the handout: 1 professor can teach a course but each student evaluates each professor separately. T. M. Murali September 27, 2010 CS 4604: E/R model
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Multiway Relationships I Relationships may connect more than two entity sets. I Consider scenario two in the handout: 1 professor can teach a course but each student evaluates each professor separately.
Background image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 26

lecture-10-er-diagrams-continued - The Entity-Relationship...

This preview shows document pages 1 - 11. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online