使用ERStudio建立数据库逻辑模型，物理模型并生成数据库表

1.建立逻辑模型
File->New
[img]http://dl.iteye.com/upload/picture/pic/101428/ced166cc-d878-3091-9a9f-39c3d1c66a4d.png[/img]

Entities->New Entity
[img]http://dl.iteye.com/upload/picture/pic/101430/87138407-e276-3e19-b8e7-447d5a91dd57.png[/img]

2.生成物理模型
Logical->Generate Physical Model
[img]http://dl.iteye.com/upload/picture/pic/101432/86d0a2d8-dfd0-3855-819f-260e85b15a4c.png[/img]

3.安装ODBC
这里以MySQL为例，安装mysql-connector-odbc-5.1.9-win32.msi
[url]http://www.mysql.com/downloads/connector/odbc/5.1.html[/url]


4.生成数据库表
PhysicalModel->Main Model->Generate Database
[img]http://dl.iteye.com/upload/picture/pic/101434/54bfb4fc-ae18-3c62-9da5-ff6e56baf0b9.png[/img]

选择Generate Objects with a Database Connection
点击“Connect...”
[img]http://dl.iteye.com/upload/picture/pic/101436/9345f5da-ea21-3a36-aad3-ae668933ee5b.png[/img]

点击“Setup”
[img]http://dl.iteye.com/upload/picture/pic/101438/a08f26e6-93d2-3816-af43-ed2449e07de0.png[/img]

如果列表中没有MySQL，点击“添加”
[img]http://dl.iteye.com/upload/picture/pic/101440/f024c843-b0ed-36a6-ad71-bb90db641899.png[/img]

如果列表中有MySQL，选择后点击“配置”
[img]http://dl.iteye.com/upload/picture/pic/101442/8353ee92-ba9b-37e1-9793-488dda15c1e5.png[/img]

根据提示，填入相关信息，然后“Next”
[img]http://dl.iteye.com/upload/picture/pic/101444/c903a66e-8f72-35bb-957d-33d120e1820a.png[/img]

完成
[img]http://dl.iteye.com/upload/picture/pic/101446/626784b6-ddaa-3524-9248-91ae2235ae96.png[/img]