Tutorial: Creating a simple database design

In this tutorial we will introduce SQLEditor, explain how to create a simple database design and then export it to a SQL text file for later use.

In our simple example we are going to create a simple database representing a library. The library will keep records of books and borrowers.

• Creating a new Document

• Adding a new Table

• Renaming the Table

• Adding a field to the table

• Make one of the fields into a primary key

• Create more fields

• Create more tables

• Making foreign key relations

• Exporting to SQL