1 / 12

Characteristics of Things

Characteristics of Things. Relationship Naturally occurring association among specific things Occur in two directions Number of associations is cardinality or multiplicity Binary, unary, ternary, n-ary Attribute One specific piece of information about a thing.

jered
Download Presentation

Characteristics of Things

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. Characteristics of Things • Relationship • Naturally occurring association among specific things • Occur in two directions • Number of associations is cardinality or multiplicity • Binary, unary, ternary, n-ary • Attribute • One specific piece of information about a thing

  2. Relationships Naturally Occur Between Things

  3. Cardinality/Multiplicity of Relationships

  4. Attributes and Values‏

  5. Data Entities • Things system needs to store data about in traditional IS approach • Modeled with entity-relationship diagram (ERD)‏ • Requirements model used to create the database design model for relational database

  6. The Entity-Relationship Diagram (ERD)‏

  7. Cardinality Symbols of Relationships for ERD

  8. Expanded ERD with Attributes Shown

  9. Customers, Orders, and Order Items

  10. ERD with Many-to-Many Relationship

  11. Many-to-Many Relationship Converted to Associative Entity to Store Grade Attribute

  12. RMO Customer Support System ERD

More Related