1 / 8

Visio Notes

Visio Notes. Establishing relationships. Set Database Modeling Options. Show Relationships with crows feet and forward text. Set Database Modeling Options. Relationships. Each relationship link will have a 1 side . One-Side -- top of the relationship line.

maxine
Télécharger la présentation

Visio Notes

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. Visio Notes Establishing relationships

  2. Set Database Modeling Options

  3. Show Relationships with crows feet and forward text Set Database Modeling Options

  4. Relationships • Each relationship link will have a 1 side One-Side -- top of the relationship line Cardinality unknown -- bottom of the relationship line (round circle) • Only 1:M or 1:1 relationships • All Many to Many (M:N) relationships must be connected though an associative entity

  5. Relationships • Create dynamic links so when you move the entity the relationship will be maintained • While you are establishing the relationship, the entities will turn RED when the relationship line is connected to it. • The ends of the relationship line will appear red to indicate the line is dynamically connected to both entities.

  6. Establish the cardinality of unknown side Name the link Relationships

  7. Relationships • Select “identifying relationship” if the primary key of one entity is needed as foreign primary key of the other Order_ID is automatically included as a foreign, primary key in ORDERLINE

  8. Relationships • When you establish a relationship, the primary key of one entity is automatically included as a foreign key of the other. • You can choose not to show the foreign key in the diagram by changing Database/Options/Document

More Related