CSE 132B Lecture 2: L2 1/9/19

43 views2 pages

Document Summary

Relationship set - mathematical relation among n >= 2 entities, each taken from entity sets. An attribute can also be a property of a relationship set! Express # of entities to which another entity can be associated via a relationship set. One-to-one: each element in a is mapped to exactly one element in b. One-to-many: an element in a may be mapped to many elements in b. Super key of an es is a set of 1 or more attributes whose values uniquely determine each entity. Candidate key of an entity set is a minimal super key. Although several candidate keys may exist, one of the candidate keys is selected to be the primary key. Combination of primary keys of the participating eses forms a super key of a relationship set! Must consider the mapping cardinality of the rs when deciding what are the candidate keys! Lines link attributes to entity sets and entity sets to relationship sets.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers

Related Documents

Related Questions