Relational Database Notation
Relational Database Notation focuses on the physical modeling of a relational database.
The answer is that for some students relational notation will seem quite natural; for others it will take some getting used to. I'll continue to represent entities using both styles, so if you prefer graphics to relational notation you will have a visual reference to make the explanations more understandable. All I ask is that you learn how to read relational notation. Doing so will allow you to study beyond this course and take advantage of resources that use relational notation to present their material.
The answer is that for some students relational notation will seem quite natural; for others it will take some getting used to. I'll continue to represent entities using both styles, so if you prefer graphics to relational notation you will have a visual reference to make the explanations more understandable. All I ask is that you learn how to read relational notation. Doing so will allow you to study beyond this course and take advantage of resources that use relational notation to present their material.
- Domain :Determines the type of data values that are permitted for that attribute.
- Primary key: A field (or combination of fields) that uniquely identifies a record in a table.
- Foreign key:A field (or combination of fields) used to link tables; a corresponding primary key field occurs in the same database.
- Data redundancy: Duplication of data in a database.
