BTEKS ENTITY RELATIONSHIP MODEL EXAMPLE

 

 

 Entity Relationship Models

ER Models provide a visual graphical representation of:

* Relationships between Database Tables with each table known as a "Entity"

* A list of attributes for each Entity and each attributes specifications

* Entity Objects and their specifications (Constraints, Keys, Indexes, Triggers/Rules)

* Optional items as well as specified notes can be added, as well as the SQL code for each ER Model

 

The Below is a screen shot of a ER Model completed by BTEKS for the U.S. Coast Guard in November 2016.

ER Model Designed by Felton M Batiste Jr. for U. S. Coast Guard Elizabeth City, N.C. 11/4/2016

 

 

DATA MODELING

Data modeling is a process used to define and analyze data requirements needed to support the business processes
within the scope of corresponding information systems in organizations. Therefore, the process of data modeling
involves professional data modelers working closely with business stakeholders,
as well as potential users of the information system.

 

 

EXAMPLE ER MODEL DESIGNED WITH TOAD FOR ORACLE

 

Using Toad ER Modeler, the below screen shots walk you thru the different screens that

display the results of a ER Model created with Toad ER Modeler.

There are several capabilities not displayed, but, for the basic ER Model, the screen shots will provide

examples of what is provide for a basic ER Model.

 

Each Entity, when double clicked on, displays a window that provides a list of options that are used to populate the Entity

with a host of information associated with the Entity.

This allows a developer, a dba or an other interested person, to view the specifics of a table and all the

objects associated with a table to include the tables that are referenced to the selected table.

 

Clicking the "Key Tab", displays a window that allows the for the creation of "keys" associated with a specific table column.

 

Selecting the "SQL Preview Tab", provides the SQL Script that is automatically generated as the ER Model is being designed.

 

 

With the ER Models, specific reports are created that allow a user to view the ER Model in Several Formats

ER MODEL REPORT IN HTML FORMAT

The Initial HTML Report Page for users to view

 

FOR THE HTML REPORT

Clicking the ER Diagram Tab provides the below view.

Example of the ER Diagram Tab View

 

 

FOR THE HTML REPORT

Clicking the Entities Tab displays a window that lists the Table Names, and the associating information captured in the ER Model

Example of the Entities Tab View

 

 

FOR THE HTML REPORT

The Attributes Tab displays every attribute associated with every entity for the ER Model

Example of the Attributes Tab View

 

 

FOR THE HTML REPORT

Clicking the "Keys Tab" displays the below information about all the "Keys" listed in the ER Model

Example of the Keys Tab View

 

 

FOR THE HTML REPORT

Clicking the "Relationships Tab" displays the below information associated with relationships between table columns.

Example of the Relationships Tab View

 

 

ER MODEL SQL REPORT FORMAT

 

A Report in the format of the SQL Script generated for the ER MODEL

The below ER Model Report in SQL Format is viewed with UltraEdit Editor, and the report can also be viewed by any sql editor.

 

 

ER MODELS comes with additional stuff, all of which, we can provide as an example.