The basic unit of structure of a database is the database Table. Tables can be supported by other objects that improve the facilities and use of the database, such as:
|·||Database Views - these define subsets of the database, each aggregated into a dynamic 'virtual' Table; the information presented by a Database View is not physically replicated, but is automatically derived based on the query that defines the View|
|·||Database Procedures - a feature of some DBMSs, these are subroutines that can contain one or more SQL statements to perform a specific task such as data validation, access control, or to reduce network traffic between clients and the DBMS servers|
|·||Database Functions - a feature that some DBMS products implement to provide a mechanism to extend the functionality of the database server; each is a routine that accepts parameters, performs an action (such as a complex calculation) and returns the result of that action as a value|
|·||Database Sequences - a feature that some DBMS products implement to provide a mechanism to generate unique values - the Sequence ensures that each call to it returns a unique value|
You can quickly create and configure all of these objects in your database modeling with Enterprise Architect.