Database: Terms & Concepts
- Entities
- Relational Keys: Primary Key, Foreign Key and Unique Key.
- Entities/Tables Relationships (i.e.: 1 to many relationships - A customer can have more than one Bank Account)
- Metadata
- Normalization
- Hierarchies (Deals with Entity-Relationship Diagram, i.e.: Product and Product_Types)
- Inheritance ( that is when 2 or more entities inherit some common attributes. i.e.: Food and Drink have common attribute as products, but both have a Product Name).
- Reference Data ( An example of reference data is Address Types, 1 or more person can have the same address type
- Data modeling
page revision: 1, last edited: 30 Mar 2010 01:19