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

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

b.      Relationships

i.           Participants

ii.           Active or Passive Verb

iii.           Bidirectional

iv.           Connectivity

i.           Examples

v.           Cardinality

i.           Examples

vi.           Relation to business rules

vii.           Existence dependence

i.           Example

viii.           Existence independent

i.           Strong/Regular

ii.           Example

ix.           Relationship Strength

i.           Weak/Non identifying

ii.           Strong/identifying

iii.           Weak entity

1.      Existence dependent

2.      Primary key that is partially or totally from parent

x.           Relationship participation

i.           Optional

ii.           Mandatory

iii.           Crows Foot Symbols

iv.           Distinctions/Examples

xi.           Relationship Degree

i.           Unary/Recursive

ii.           Binary

iii.           Ternary

iv.           More

Attached Files: | - KVCC BUS210_DatabaseDesignMgt_Outline 11.pdf