Transcription of Exercises - web.cs.ucla.edu
{{id}} {{{paragraph}}}
Exercises9personownscarparticipatedaccid entaddressdamage-amountmodelyearlicensen amereport-numberdatelocationdriver-iddri verFigure for a Car-insurance the distinctions among the terms primary key, candidate key, and :Asuperkeyis a set of one or more attributesthat, taken collectively, al-lows us to identify uniquelyan entityin the entity set. A superkeymay containextraneous attributes. IfKis a superkey, then so is any no proper subsetis also a superkeyis called that severaldistinct sets of attributescould serve as candidatekeys. Theprimary keyis one of the candidate keys that is chosen by the database designeras the principal means of identifying entitieswithin an entity anE-Rdiagram for a car-insurance company whose customers ownone or more cars each.
additional entity sets could be de˚ned, along with relationship sets to replace some of the attributes of the exam entity set, as course with attributes name, department,andc-number section with attributes s-number and enrollment, and dependent as a weak entity set on course room with attributes r-number, capacity,andbuilding a.
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}