Data Analysis and Data Modeling in Visio

Lab Data Analysis and Data Modeling in Visio Overview In this lab, we pull up stakes learn to draw with Microsoft Visio the ERDs we created in flesh. Learning Objectives Upon consummation of this learning unit you should be able to ? Understand the concept of information idealing ? conk out business rules ? Develop and return good use upive information naming conventions ? Construct simple data models using Entity Relationship Diagrams (ERDs) ? Develop entity descents and define various types of attributes Lab Goals Our lab goals be to 1. Learn to constitute conceptual models in Microsoft Visio. 2. develop the 5 ERDs from class in Microsoft Visio.You get out accomplish this by drawing the 4 diagrams from the class exercise. You impart lay down to hand in all 4 diagrams by FTPing them to your account spot on the IST-S-STUDENTS seer and then pasting the url to the diagram in the text edition boxes for this weeks learning unit assessment. What you will need to put do wn 1. A copy of Microsoft Visio 2003 (or higher) 2. The Visio Conceptual Modeling stencil conceptual modeling. vss (should be with the other files from this weeks lesson) 3. The class exercises from this week (should also be with the other files from weeks lesson. ) Part 1 Getting rig for Using Microsoft Visio for Conceptual ModelingOverview This section will explain how to physical exercise Microsoft Visio to create conceptual Entity-Relationship data models. Microsoft Visio has built-in database tools for creating luculent data models (those that apply the relational database theory to your entity-relationship diagrams), and not very good at conceptual modeling. As a result, using the MS Visio database tools to create the conceptual model diagrams back sometimes feel like trying to jam a round peg into a square hole. Since not many spate are into shoving round pegs into square holes, this guide will explain how you can maximize the Visio database tools for creating conceptual models.For those of you familiar with Visio, here are the heuristics we will pass off to make Visio conceptual model fri closedownly purpose Database Model Diagrams stipulate the settings to be more user-friendly Do not use the relationship tool use my stencil instead meter 1 Create New Document The first step is to create a naked document. From the Visio Menu, make out File ( New ( Software & Database ( Database Model Diagram pic This will create your blank Visio paginateboy, and load the default database toolset. IMPORTANT The default Visio stencils are for logical modeling.Ive created a custom stencil for conceptual modeling. Step 2 Load the Conceptual Modeling Custom Stencil download the stencil file from our learning management system and save the conceptual modeling. vss somewhere on the local computer. From the Shapes Bar, select Shapes ( More Shapes ( Open Stencil Use the Open Stencil dialogue to browse for the conceptual modeling. vss and absolved it. You sho uld see the following pic Step 3 Configure Default Settings This is the more or less important step. In this step we will tweak the database document settings so that they are favorable to conceptual modeling.The benefits of doing this are there will be very little reworking of the document at the logical modeling step. From the Visio Ribbon, choose Database ( Display Options The Database Document Options Dialog will appear. From this dialog, select Relational type set, and Conceptual Names visible on the diagram, as displayed in this dialog pic Next, Click on the Table tab From this section of the dialog, display everything pull out annotations and vertical lines, do not show data types, and place primary feather keys at top, as displayed in the following dialog pic When youre have it off click ok.This will close the Database Document Options dialog. NOTE You might requisite to save your document at this time. Now that youve got things set-up this file can serve as a templat e for future conceptual modeling diagrams. AS A MATTER OF FACT, YOU CAN DOWNLOAD A PRE-BUILT VISIO TEMPLATE FROM THE air division WEBSITE WITH THIS WEEKS MATERIALS. Part 2 Microsoft Visio for Conceptual Modeling Walk-Thru Overview In this section, we will walk-through creating a conceptual data model with Microsoft Visio. We will use the vBay (E-bay like website case study as an example for conceptual modeling. ) To Create an EntityDrag the pic icon onto the page and drop. Name the entity in the database properties window pic YOU DO IT Now work these 4 Entities to your diagram pic To impart Attributes to the entity To add attributes to your entity, simply click on the chromatography columns section of the database properties window, and enter in your column names. Be certainly to include the appropriate attribute descriptors rucdm with the physical name. geld the data type Reqd and PK columns. Those are used in logical modeling. pic YOU DO IT Now add attributes to all 4 entit ies, like this pic To Add Relationships among the entitiesTo Add Relationships, simply drag the appropriate relationship cardinality (for example pic) onto the page and connect the ends to each entity. To snap the line to the entity drag the line end onto the box until it turns red, like this. Red symbolizes the shapes are glued together pic after(prenominal) to glue both ends of the line to an entity, you can double-click on the line to dish out it a label. For example pic YOU DO IT Now add all the relationships to complete the conceptual model, like this pic Note You might have to juggle the shapes and lines or so to achieve a best fit. It takes time and a whole rotary of patienceOther Tips You can place multiple diagrams in unmatchable file Just keep adding pages. To add a page, from the menu select Insert ( Blank Page pic To rename a page, right-click on the page and choose Rename You can add text to your diagram Use the Text tool in the ribbon. Home ( Text. When youre fini shed, be sure to select the Pointer Tool again. pic Part 3 Creating the 4 diagrams from class exercise & handing it in. Take the 4 diagrams from class and draw them in Microsoft Visio. array one diagram on each page. Label the pages accordingly nevertheless the document Upload the document to blackboard