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

1.      Relationships

a.      1:M

b.      1:1

c.      M:N

i.           Linking Table

2.      Data Redundancy

a.      Controlled

b.      Historical Accuracy

3.      Indexes

a.      Index Key

b.      Unique Index

4.      Codd's Rules

Chapter 4

1.      Entity relationship model

a.      ERD

i.           Entities/Objects

ii.           Attributes

iii.           Relationships

iv.           Notations

i.           Chen

ii.           Crow's Feet

iii.           UML

b.      Entities

i.           Entity set

ii.           Entity instance/occurrence

c.      Attributes

i.           Required Attribute

ii.           Optional Attribute

iii.           Domains

iv.           Identifiers

i.           Primary Keys

ii.           Relational schema

v.           Composite identifier

vi.           Composite attribute

vii.           Simple Attribute

viii.           Single Valued attributes

ix.           Multi Valued attributes

i.           Implementing

1.      New attributes

2.      New entity

x.           Derived/computed attribute

Attached Files: | - KVCC BUS210_DatabaseDesignMgt_Outline 10.pdf