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

1.      Review

2.      Inheritance

3.      Subtype Discriminator

4.      Disjoint and overlapping constraints

i.           Disjoint/nonoverlapping

ii.           Overlapping

5.      Completeness Constraint

i.           Partial

ii.           Total

6.      Specialization vs Generalization

7.      Entity clustering

8.      Selecting Primary keys

i.           Natural key/identifier

ii.           Primary key guidelines

iii.           Composite Primary Keys

iv.           Surrogate key

9.      Design Cases

i.           Implementing 1:1 Relationships

ii.           Maintaining History of time-variant data

iii.           Fan traps

iv.           Redundant Relationships

Chapter 6

1.      Normalization Introduction

Attached Files: | - KVCC BUS210_DatabaseDesignMgt_Outline 14.pdf