Database Model

A database model or schema is a graphic representation of all of the table objects residing in the database along with all of the data elements or columns in each table. It is extremely useful for writing queries using SQL (Structured Query Language), especially when it is necessary to join two or more tables.

A graphic datamodel and brief SQL tutorial is provided with the application and can be viewed from the
FreeForm Query module.

Sample Schema

dbmodel.gif