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

1.      Relational Database model

a.      E.F. Codd

i.           Predicate Logic

ii.           Set Theory

iii.           Components

1.      Logical data structure represented by relations

2.      Set of integrity rules

3.      Set of operations that define data manipulation

b.      Logical view

i.           Logical vs Physical

ii.           Tables/Relations

1.      Entity occurrences

2.      Entity set

3.      Tuple

4.      Data types

a.      Numeric

b.      Character

c.      Date

d.      Logical

5.      Domain

c.      Keys

i.           Key definition - one or more attributes that determine other characteristics

ii.           Primary Key

iii.           Determination

1.      Functional dependence

a.      Determinant/key

b.      Dependent

c.      Full functional dependence

iv.           Types of keys

1.      Composite

a.      Key attribute

2.      Superkey

a.      Trivial

b.      Candidate/Minimal

3.      Primary Key Entity Integrity

a.      Primary Key requirements

i.           Must be unique

ii.           Cannot be Null

1.      Nulls

4.      Foreign Key

a.      Referential integrity

5.      Secondary Key

d.      Integrity Rules

i.           Entity

ii.           Referential

iii.           Flags

iv.           Others

1.      Not Null

2.      Unique

2.      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

Attached Files: | - KVCC BUS210_DatabaseDesignMgt_Outline 8.pdf