SQL Based Relational Database Application

SQL Based Relational Database Application

1. End-User Interface

   • End Users can interact with the data

2. Collection of tables stored in the database

   • Each table is independent
   • Rows in different tables are related based on common values in common attributes

3. SQL Engine

   • Executes all queries

4. Models

   • Entity Relationship Model
     • Graphical Representation of entities and their rxn's in a database structure
     • Entity Relationship Diagram (ERD)
     • Entity instance or entity occurrence
     • Connectivity