Table of Contents
Designing a database can be a difficult thing to do well. There are pitfalls to catch out the unwary and performance or maintence problems can easily occur.
SQLEditor can't design your database for you, it takes judgement and thought to design a database well, which means that a human being is a better bet than a computer. However what SQLEditor can do is help you to design a better database.
SQLEditor shows a graphical view of your database. Each table is represented visually as a block containing fields such as table columns, indexes or other options. Connections between tables are indicated by lines which may have symbols or names attached to them.
A relational database is a database that is structured according to the relational model. This means that it follows certain rules and typically contains information ordered into tables which contain rows which in turn contain columns. By linking rows in one table to rows in another table different views of the data can be created.