Title: Class Outline 9
Course: KVCC BUS210 > Section: Class Outlines

1.      Relational Algebra

a.      Relvar

b.      Operations

i.           Select/Restrict

ii.           Project

iii.           Union

iv.           Intersect

v.           Difference

vi.           Product

vii.           Join

1.      Natural Join

2.      Equijoin

3.      Theta Join

4.      Left outer join

5.      Right outer join

viii.           Divide

2.      The data dictionary

a.      System Catalog

b.      Homonyms

c.      Synonym

3.      Relationships

a.      1:M

b.      1:1

c.      M:N

i.           Linking Table

4.      Data Redundancy

a.      Controlled

b.      Historical Accuracy

5.      Indexes

a.      Index Key

b.      Unique Index

6.      Codd's Rules

Attached Files: | - KVCC BUS210_DatabaseDesignMgt_Outline 9.pdf