Creating Database Schema

The database schema implements the conceptual schema as a model for storing data in the technical world. The aim is to realize and maintain the structure of the tables in a concrete relational database system.

A database model is used for this. As with the ER model, tables and their referential integrity (foreign keys) are shown as nodes and edges in diagrams. The database can be described fully by the database administrators; this is done by denormalizing tables and creating elements which are typically found in databases, such as indexes, user management, data organization etc.

The diagram editor for database models supports IDEF1X notation, which can also be used for the conceptual model.

As well as the editor for database diagrams, you use table editors for database tables.

This chapter contains the following topics:

Working in Database Diagrams

Working in DB Table Editors

Creating Stored Procedures

Creating DB Users and Roles