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

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

ii.           Database Design Challenges - Conflicting Goals

i.           Design Standards

ii.           Processing speed

iii.           Information requirements

iv.           Example

Chapter 5

1.      Extended Entity relationship

i.           EERD

2.      Supertypes and Subtypes

i.           Why use types

1.      Unnecessary nulls

2.      Unique relationships

ii.           Example

iii.           Supertype

iv.           Subtype

3.      Specialization hierarchy

i.           Is-a relationship

1.      Support attribute inheritance

2.      Define a special supertype attribute known as subtype discriminator

3.      Define disjoint/overlapping constraints and complete/partial constraints

4.      Inheritance

5.      Subtype Discriminator

6.      Disjoint and overlapping constraints

i.           Disjoint/nonoverlapping

ii.           Overlapping

7.      Completeness Constraint

i.           Partial

ii.           Total

8.      Specialization vs Generalization

9.      Entity clustering

10.  Selecting Primary keys

i.           Natural key/identifier

ii.           Primary key guidelines

iii.           Composite Primary Keys

iv.           Surrogate key

11.  Design Cases

i.           Implementing 1:1 Relationships

ii.           Maintaining History of time-variant data

iii.           Fan traps

iv.           Redundant Relationships

Attached Files: | - KVCC BUS210_DatabaseDesignMgt_Outline 13.pdf