ERBuilder Data Modeler integrates three powerful functionalities to validate a data model and avoid potential errors in the built model.
In the previous posts we saw how to validate a model using the check control utility and sample test data.In this post we will discuss the third validation method provided by ERBuilder, validate a model by generating a web user interface.
This tutorial will show you how creating an attractive web user interface for CRUD applications from a data model can be done in a few clicks. ERBuilder generates lists, details, insert, and update pages. Before generating the web interface, it is possible to specify the look and feel of each table fields (HTML component type, pick list values, min/max values, read-only, pattern ...).
This allows data modelers to verify, through the generated user interface, whether the entities, fields, and relationships support the requirements.
1- First, open the “Table” form by double-clicking on the table graphic. In this interface, go to the “Field User Interface” tab. In this tab, you need to specify the following:
|Textfield||Defines a one-line text input field.|
|Textarea||Defines a multi-line text input field.|
|Checkbox||Lets the user select ZERO OR MORE options from a limited number of choices.|
|Radio||Lets the user select ONLY ONE of a limited number of choices.|
|Defines an input field that should contain an email address.|
|Select||Creates a drop-down list. Define the available options in the list value, separated by line breaks.|
|List||Defines an editable list.|
|File||Defines a file-select field and creates a “Browse” button for file uploads.|
|Image||Lets the user upload an image file.|
|Date||Defines an input field that should be a date.|
|Datetime||Defines an input field that should include the year, month, day, and time.|
|Time||Defines an input field that should be a time.|
|Number||Defines a numeric input field.|
2- Navigate to “Tools” > “Generate User Interface”.
3- Once the “Generate User Interface” window is displayed, you can choose between a dark theme and a white theme. You can also specify the output folder. By default, the output folder will be your current project folder.
4- Open the generated user interface with a web browser.
ERBuilder is a GUI data modeling tool that allows you to visualize, design and model databases by using entity relationship diagrams and automatically generates the most popular SQL databases. Generate and share the data Model documentation with your team. Optimize your data model by using advanced features such as test data generation, schema compare and schema synchronization. Try now ERBuilder for 15 days FREE