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
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License