Data Relational Model

Get Started. It's Free
or sign up with your email address
Data Relational Model by Mind Map: Data Relational Model

1. Natural Join

1.1. Links tables by selecting rows with common values in common attribute(s)

2. Integrity Rule

2.1. Entity Integrity

2.2. Referential integrity

3. Key

3.1. Super Key

3.2. Candidate Key

3.3. Primary Key

3.4. Foreign Key

4. Relationship

4.1. One-to-Many

4.2. One-To-One

4.3. Many-To-Many

5. Relational Set Operator

5.1. Equijoin

5.1.1. Links tables on the basis of an equality condition that compares specified columns

5.2. Theta Join

5.2.1. Any other comparison operator is used

5.3. Outer Join

5.3.1. Matched pairs are retained, and any unmatched values in other table are left null

6. Characteristic of Relational Table