Database Design

Database Design

1. Unified Modeling Language (UML)

   • Class
     • Instance of Class = Object
     • Descriptive Attributes
     • Associations
       • Represented by connecting line
       • Multiplicity (ex: one or many or one and only one)
       • One-to-many
       • Verb phrase to describe

2. Structured Query Language (SQL)

   • Implementation of Relational Algebra and Set Theory
     • Sets
       • A collection of single valued entries
       • No duplicate entries
     • Relational Algebra
   • Data Definition Language
     • used to build and modify the structures of tables and other objects in the database
     • Tables
       • Implementation of Relational Model
         • Scheme
           • A set of attributes over which a relation is built
           • Each instance of the scheme is a tuple built over the scheme
   • Data Manipulation Language
     • used to create and modify the data in the tables