Chapter 7 Using Adaptive Server Anywhere with EAServer

Building Adaptive Server Anywhere databases

You can use SQL Modeler™, which is included in SQL Anywhere Studio (SQL Anywhere Studio is not included in EAServer), to design and populate your databases. SQL Modeler is a graphical tool that you use to create a database schema, including all tables, views, indexes, references, triggers, and procedures.

Designing a database is not difficult, but it is important. Poor database design can lead to an inefficient and possibly unreliable database system. Because most client applications are built to work on specific parts of a database and rely on the database design, a poor design can be difficult to revise at a later time.

For information about basic database design, see the Adaptive Server Anywhere User's Guide. For more advanced information about database design, see:

Documentation on DataArchitect, which is a component of PowerDesigner and a database design tool available from Sybase
An Introduction to Database Systems, by C. J. Date

After designing your database, build the tables and other objects that you need in the database.