Working with a Database Project

A database project is where your database model will be stored.

Launching SchemaBank 

After logging in, click on the Start Now button  to launch SchemaBank.

Creating a New Database Project

To create a new database project, choose File > New.

You need to give a name to the project and choose the target database from the list.

The Project Environment

The ERD Pane tab is where you will draw your Entity Relationship Diagram. You will find the buttons on the menu bar to create new entities and relationships.

The Tree View window shows all entities and their attributes in tree form.

The Bird's View window shows your ERD from a bird's eye view. You can click anywhere inside the window to set the focus of the ERD Pane. You can also drag any one of the small boxes (representing your entities) to move the corresponding entity.

Under the Text Objects tab, you can enter the SQL statements directly for database objects like views, functions, triggers, etc.

The Version Manager tab shows all committed versions and allows you to check in your working copy as a new version.

The Notes tab is where you can put notes about your database project.

The Options tab carries settings available for your database project.

Saving Changes

Click on the File > Save button.

Auto-Save

You can have your project automatically saved every 10 minutes, using the setting under the Options tab.

Opening a Project

Select File > Open and you can choose from the drop down list the project you want to open.