Before creating a database in SQL Anywhere, prepare by defining all the tables it will have (entities), the columns you want in each table (attributes), and the relationship each table has with the other tables (keys and constraints).
Consider constructing a Conceptual Database Model (CDM) for the database. A CDM helps you visualize your database as a map. You can construct the CDM on paper, or use software such as Sybase PowerDesigner. CDM tools help you validate your design as you construct it, and can also help you create the database.
For more information on designing databases, including how to construct a Conceptual Database Model, visit the PowerDesigner documentation at http://infocenter.sybase.com/help/index.jsp.
For more information about database objects such as tables and views, see Working with database objects.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|