DBMS Development Tools

There are four major Components of Development (Database Creation) Tools:
 

1. Database Definition Language (DDL).  This refers to:
   
   A.    How the data is physically stored
   B .   Specification of integrity constraints. What types of data we will allow (More on this later)
   C.    Associating Privileges.  Who can do what. (More on this later also)
    
2. Data Dictionaries (DD). This is the storing of Metadata (data about data)
   
   Information stored includes field names, data types, primary keys (to be discussed later)
   and relationships between tables (also to be discussed later)
    
3. Data Storage Maintenance.
   
   This includes information about physical storage of data, forms, data validation, and others
   (also to be discussed in more detail later)
    
4. Data Transformation.
   
   How the data is stored and how it is used and displayed are two different issues.
   This is where that information is stored.