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

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

xii.           Recursive Relationships

xiii.           Associative/Composite Entities

xiv.           Developing an ER Diagram

i.           Iterative Process

1.      Create a detailed narrative of the organizations description of operations

2.      Identify the business rules based on the description of operations

3.      Identify the main entities and relationships from the business rules

4.      Develop the initial ERD

5.      Identify the attributes and the primary keys that adequately describe the entities

6.      Revise and review the ERD

ii.           1TO1 relationship sidebar

xv.           Database Design Challenges - Conflicting Goals

i.           Design Standards

ii.           Processing speed

iii.           Information requirements

iv.           Example

Attached Files: | - KVCC BUS210_DatabaseDesignMgt_Outline 12.pdf