Guide2Use_Ms-Visio - 7.104 Database Engineering I Semester...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
7.104 Database Engineering I Semester 1, 2011 - Week 5 Guide to use MS-Visio for Drawing ERD Resources: 1. http://office.microsoft.com/en-us/visio/HA102144941033.aspx 2. http://www.scribd.com/doc/21789/Visio-Tutorial Tutorial To change the modeling notation, choose Database, Options, Document. On the General tab, under Symbol Set, select the notation you want to use, and then click OK. Follow these steps to add and name a new table: 1. Drag an Entity shape from the Entity Relationship or Object Relational stencil onto the drawing page. 2. If the Database Properties window is not visible, right-click the new table, and then choose Database Properties. 3. Select Definition in the Categories list, then type a name in the Physical Name box. Visio Professional 2007 updates the Conceptual Name box if the Sync Names When Typing check box is selected (the default); otherwise, you must type a value for Conceptual Name. Note To display the Database Properties window, double-click a table shape. 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Adding Columns to a Table You can add columns to an existing table or define columns for a new shape in the Database Properties window. When you add a column to a table, you can define it as the primary key. If you're using Relational notation, primary, alternate, and foreign keys are visible on the table, as Figure 19-16 shows. Visio Professional 2007 automatically creates unique indexes on primary keys. Other columns can be assigned a non-unique index called the inversion key. Figure 19-16. OfficeLoc is the primary key (PK); StreetAddress, IsHeadquarters, and Countryname are required values and appear in bold. PostCode, StateCode, and CityName are unique indexed columns. Before you start adding columns, you might want to define a default naming convention. Visio Professional 2007 generates default names for columns, primary keys, foreign keys, and other attributes based on a prefix and suffix specified in the Database Modeling Preferences dialog box. For example, if you add a new column to the Orders table, Visio Professional 2007 provides the name OrdersCol1. To specify default names, choose Database, Options, Modeling, and then change the settings on the Logical Misc tab. Follow these steps to add a column and define its properties: 1. Right-click the table to which you want to add a column, and then choose Database Properties. 2. In the Categories box, choose Columns, and then click Add . 3. To create a primary key, place a check mark in the PK column. 4. To define the column's attributes, click Edit. 2
Background image of page 2
3
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
5. In the Column Properties dialog box, click the tab that contains the information you want to define and make your changes. Table 19-2 describes the options available in the Column Properties dialog box. Visio Professional 2007 updates the database model diagram to reflect your choices. Table 19-2. Options in the Column Properties Dialog Box
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 9

Guide2Use_Ms-Visio - 7.104 Database Engineering I Semester...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online