You can estimate the size of a database for all or some of the tables and other objects in your model. You can estimate the initial size of the database or project its growth over a number of years.
Estimated number of records in tables - Specify the number of rows (and their annual projected growth rate) in a table in the Number and Row growth rate fields on the General tab of its property sheet (see Table Properties).
Table columns and their sizes - Specify the average size for variable length columns in the Average length field on the Detail tab of its property sheet (see Column Properties). If you do not specify an average length for variable length columns, then the maximum length is used. It is particularly important to specify an average length for strings or long binary data types, as a Binary Long OBject (BLOB), such as a picture, can represent the largest portion of the space actually taken by a table.
Indexes in the model - including primary, alternate, and foreign key indexes (if supported) and database-specific indexes such as IQ join indexes.
Tablespaces in the model - the size of a tablespace is estimated as a total of all the tables and all the indexes in the tablespace.
DBMS and its storage options.