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