creating a Data Model using Visio
来源:互联网 发布:淘宝上cf刷枪是真的吗 编辑:程序博客网 时间:2024/05/15 07:34
http://itoverview.com/visio_dm.php
Creating a Data Model using Visio:
Follow these simple steps to create a data model with two entities.
1: Open Visio software.
2: On the left hand side, under Choose Drawing Select Type, click the category 'Database'. Click the template 'Database Model Diagram'.
3: Alternate way of opening is to go to 'File' menu. Click New and then click 'Choose drawing type'. Out of the several options displayed, click 'Database Model Diagram'.
4: This will take you to a workplace where data model will be created. This workplace has got different panes. On the left hand side, you can see the different icons for creating entity, relationship, view etc. The grid is the place where you are going to drag and drop these icons to create the data model.
Below that, in 'Database Properties' tab, you can see the categories for creating Tables, Columns, Primary IDS, Indexes, Triggers, Check, Extended Notes etc. If you dont see the Database Properties tab then, double click on the table. This will open the Database Properties window. Drag that window in such a way that it positions itself at the bottom of the grid.
5: To create a Table, click the icon 'Entity' and drop it on the workplace. Under Category, place the cursor on the category 'Definition'. Change/Type the conceptual name(logical name) and physical name(table name) as 'COUNTRY'. As per your business requirements, you can enter metadata in name space, owner, source database and defining type.
6: To create a Column, place the cursor on the category 'Columns'. Type column name as 'COUNTRY_CODE'. Select the data type or type your datatype as VARCHAR(10). Select the optionPrimary Key to identify attribute 'COUNTRY_CODE' as the primary key. If you want to edit the column or need to add more properties to the column, place the cursor on the column 'COUNTRY_CODE'. Click edit and you can edit or add more properties like defintion, datatype, collection, extended, check, extended, notes.
7: Follow the same approach to create another column 'COUNTRY_NAME'. Type datatype as VARCHAR2(50), check 'Required' option and do not select the primary key option. Now you will be having two columns COUNTRY_CODE, and COUNTRY_NAME under the table 'COUNTRY' on the grid.
8: Create another table 'BANK' with two columns namely BANK_CODE and BANK_NAME by following steps 5 through 7.
9: In order to relate these two tables(COUNTRY & BANK), a Foreign Key relationship must be created. To create a Foreign Key relationship, follow these steps.
Drag the 'Relationship' icon and drop it on BANK_CODE column. Now you can see the relationship i.e a line drawn from Bank. Now drag that arrow until you drop it on the COUNTRY_CODE column of COUNTRY table. When you did that, you can see a new column 'COUNTRY_CODE' in BANK table, that has been inherited from COUNTRY table.
Place the cursor on the relationship and you can edit the database properties of that relationship.
You can give a name, change the cardinality, identifying and non-identifying relationship, etc.
Now the data model is ready and if you have a higher version of visio, then you can forward engineer the data model to create DDL scripts for creating a database.
- creating a Data Model using Visio
- 17.1.1.6 Creating a Data Snapshot Using Raw Data Files
- Creating a List Item instance programmatically using the object model
- 17.1.1.5 Creating a Data Snapshot Using mysqldump
- 17.1.1.5 Creating a Data Snapshot Using mysqldump
- Creating custom data graphics in Visio
- Creating a 2D Active Shape Model in ITK Using PCA
- 17.1.1.6 Creating a Data Snapshot Using Raw Data Files 创建一个数据快照使用 Raw Data Files
- 17.1.1.5 Creating a Data Snapshot Using mysqldump 创建一个快照使用mysqldump:
- Creating a custom data descriptor
- Creating a data step view
- Creating a Google Data Gadget
- Using Visio 2000 Enterprise Edition to Model Applications
- Creating a Chm build using Sandcastle
- Creating a Simple BSP Application Using AJAX
- Creating a Windows Service using C#
- Creating a GUI application using Qt
- Creating a Roulette Wheel Using HTML5 Canvas
- window任务计划命令详解 (一)
- VC6 在使用VC助手(Visual AssistX)在Win7下不能使用↑↓←→及回车键选择的解决办法
- xcode调试技巧
- Android特效第四篇:Android抽屉实现
- css之自动换行
- creating a Data Model using Visio
- 金山软件公司创始人求伯君简介 (is2120.zz)
- 查询本机ip和浏览器useragent的网址
- 【无限互联】iOS开发视频教程— 2.2 iPhone开发之OC变量和基本数据类型1
- 这样的情人节还是要彼此快乐
- 简洁实用JavaScript Tab滑动门选项卡特效
- 进程与线程的区别
- ios中摄像头/相册获取图片,压缩图片,上传服务器方法总结
- 模仿网易新闻客户端(RSS版)(一)