1 / 10

ERD

ERD. For a full discussion and more examples please consult: http://www.library.cornell.edu/cts/elicensestudy/dlfdeliverables/fallforum2003/ERD_final.doc Also search the WWW for more resources on ERD. Entities. So far, no relationship between students and schools has been indicated.

tuyen
Download Presentation

ERD

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ERD For a full discussion and more examples please consult: http://www.library.cornell.edu/cts/elicensestudy/dlfdeliverables/fallforum2003/ERD_final.doc Also search the WWW for more resources on ERD

  2. Entities • So far, no relationship between students and schools has been indicated.

  3. Relationships now? Read the first relationship definition, “attends,” when tracing the relationship left to right or top to bottom. Read the second definition, “enrolls,” when tracing the relationship right to left or bottom to top

  4. A little more descriptive…Optionality and Cardinality “Optionality” expresses whether the relationship is optional or mandatory. “Cardinality” expresses the maximum number of relationships. (first the optional aspect of the relationship, second the cardinal aspect)

  5. What’s happening here?

  6. What’s happening here… a supplier may provide many different products, and each type of product may be offered by many suppliers

  7. Brain Teaser…? Is this possible?

  8. Brain Teaser…? Recursive Relationship Is this possible? Yes… how? The diagram indicates that a person may be the father of zero or many persons (children), and that a person may have zero or one father. (Not every person’s father will be recorded in the system, so the relationship is modeled as optional).

  9. How about this one…?

  10. How about this one…? Exclusive-Or Relationship Each convict is assigned to a prison, or to a parole officer, but not both

More Related