工欲善其事, its prerequisite--modeling and generating database files with PowerDesigner

let's start with power Designer: It's a case toolset for Sybase, which makes it easy to analyze and design a management information system that almost includes the entire database design process. With Power designer , you can create a data flow diagram, a conceptual data model, a physical data model, and a structure model for the data Warehouse to control the team design model. It can be combined with many popular software development tools such as PowerBuilder, Delphi, VB and so on to shorten the development time and optimize the system design.

The design of database is the most troublesome in the reconstruction stage of computer room charge system, so designing a good database can save a lot of code in the future. Find some tools from the Internet, find power designer features are powerful and easy to use. I'll share with you the whole process of modeling and building database files with power Designer.

1. Create a new model

2. Create a new table by using the table control in the toolbar, and double-click the tables to add fields to your table

3. This is my design. Data Model of computer room charge system

4. Below we export the database file

5. Open the file with SQL Server2008

6. The database is created automatically after execution.

  Ax, spend more time designing a good database provides us with a foundation for making good software, Power Designer can create a visual data model for us, have a global understanding of the data structure, and can automatically generate database double benefit. To make good software, you have to design a database, and you have to use powerful tools to design a database. 工欲善其事, its prerequisite!