1 / 10

Using ER/Studio

Using ER/Studio. Modeling a Relational Database Using ER Studio. We will use ER Studio as the modeling Tool to build ER diagrams. ER Studio Is a CASE tool providing a Repository (or System Catalog) of an organization’s databases

Download Presentation

Using ER/Studio

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. Using ER/Studio

  2. Modeling a Relational DatabaseUsing ER Studio • We will use ER Studio as the modeling Tool to build ER diagrams. • ER Studio Is a CASE tool providing a Repository (or System Catalog) of an organization’s databases • Fully specified logical models in ER studio can be used to generate DDL • the code of the create tables statements

  3. Getting to ER Studio Data Architect • Enter ERS in the Search are of the start menu • Click on the ER Studio Data Architect 9.6 icon • Click on tools in the top menu and then select options from the drop-down menu

  4. Set Options to Produce Crow’s-Foot Notation Pick logical Pick options from tools drop-down Choose Crow’s feet notation

  5. Create a New Model • Select File from the top menu and new from the drop down • On the dialog box, ensure that Draw a new data model is checked and that relational is selected, then click OK

  6. Add Entities 2 1 • Click on the entity icon (1) • Move the cursor to the location where you want an entity and click • Repeat to place additional entities in the model area of the screen • Click on the blue arrow (2) when you are through adding entities

  7. Name Your Entities • Double click on an entity to open its Editor • In the Entity Name textbox enter the name you wish to use for your Entity • Click save • Repeat for each entity

  8. Adding 1 to Many Relationships • Click on the relationship icon shown • In the model area click first on the entity that is on the 1 side of the relationship • Then click on the entity on the many side 1 to Many

  9. Adding Many to Many Relationships • Click on the relationship icon shown (described as non-specific realtionship • In the model area click on one of the entities to be linked • Then click on the other entity to complete the relationship Many to Many

  10. Saving the Model Change to desired J drive space • Select file save

More Related