- Smart Personal Cloud

Building Database Application - Advanced


This tutorial will show you how to create advanced database application. Before continuing, you may want to read the Basic Tutorial first. The example in this tutorial is based upon the example of the Basic Tutorial.

The steps of this tutorial is recorded in a 2 minutes screencast.


In the Basic Tutorial, we have built the 'Student List' application. Now, let's expand upon the example to add the ability to track students and registration for classes.

The basic 'Student List' application have defined the 'Students' table. We don't need to change it. Now, let's add two more tables - Classes and Registrations. The 'Classes' table will keep track of all the class information. The registration table will link the 'Students' table and 'Classes' table together in a Many-to-Many relationship, which means, one student can register for multiple classes; while one class can take multiple students.

The additional tables of the advanced 'Student List' application is as below:

The new 'Classes' table and 'Registrations' tables are showing above with red border.


Database application generated on MyEzApp.com can be modified and re-generated. When an application is re-generated, we keep all the data you have already entered. If you delete a table or a column, the old data is still there, but they will not be displayed on any generated page. If you add new tables or new columns, the new tables or columns will contain empty value.

If you want to remove old data, you need to either write a script to do it, or run the 'uninstall.ws' script in your application folder, which will remove the entire application along with all its data.

To make changes to the 'Student List' application, let's open the database application builder's page and click 'Modify'

On the select applications page, please choose the 'Student List' application and click the 'Edit' link.

Once you click the 'Edit' link, you will be on the 'Define Tables' page and you can start making changes.

To add the 'Classes' table and 'Registrations' table, please click the 'Add Table' button.

Classes Table

Similar to the 'Students' table, let's define the table name to be 'Classes'.

Let's define the column for 'Class Name', 'Term', 'Year', and 'Notes'. After defining the columns, let's set the object label to 'Class Name , Year Term'.

Then click 'Save' to go back to the define tables page.

Registrations Table

On the define tables page, please click the 'Add Table' button to create the new 'Registrations' table.

The 'Registrations' table is very important. It connects the 'Students' table with 'Classes' table through reference columns. Below is the screenshot of the 'Registrations' table.

Please click the 'Save' button to go back to the define tables page.

Generate the Application

On the define tables page, you will see three tables defined.

Please click the 'Generate' button to regenerate the 'Student List' application

Once you clicked the 'Generate' button, you will be redirected to the next step 'Complete'

The complete step is informational. No additional information you need to provide at this step.


To use the application, you simply click the 'Student List' icon on your user's homepage.


When you click the 'Student List' icon, you will open up the 'Student List' application dashboard.

Add Student

Now you can start adding student. Below is an example of the 'Add Students' page. As you can see from the screenshot, Gender is displayed as a drop down while date-of-birth is display using a date picker.

Add Classes

Now you can start adding classes. Below is an example of the 'Add Classes' page.

Add Registrations

Once you added student and class, you can add registrations. Below is an example 'Add Registrations' page.

View Student Detail

When you drill down to the student detail page, you will see the student information and all the registered classes for that student.

View Class Detail

When you drill down to the class detail page, you will see the class information and all the registered students for that class.


This tutorial shows you how to create advanced database application with multiple tables. If you like the generated application, you can use it now. If you are not fully satisfied and wants to customize the application, the complete source code is available to you. Please refer to the tutorial Building the Ez Notes Application for customization steps.

Try it out and have fun!