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

1.      Importance of data models

a.      I created this business, I worked with this business for years, and this is the first time I’ve really understood how all the pieces really fit together.

b.      Perception/needs

i.           Blind man and the elephant

2.      Data model building blocks

a.      Entity

b.      Attribute

c.      Relationship

i.           One to Many - 1:M 1..*

ii.           Many to Many - M:N *..*

iii.           One to One - 1:1 1..1

d.      Constraints

3.      Business Rules

4.      Obtaining business rules

a.      Importance

i.           Standardize company's view of data

ii.           Communication tool between users and designers

iii.           Designer can understand the nature, role, and scope of the data

iv.           Designer can understand business processes

v.           Designer can develop correct relationship participation rules and their constraints

5.      Translating business rules into data models

a.      Noun - entity

b.      Verb - relationship between

6.      Naming Conventions

7.      The evolution of data models

a.      The hierarchical model

i.           Upside down tree

ii.           Segments

iii.           Parent

iv.           Child

v.           One to Many

b.      The network model

i.           More than one parent

ii.           Terminology

i.           Schema

ii.           Subschema

iii.           Data manipulation language DML

iv.           Data definition language DDL

c.      The Relational Model

i.           Relation/table

ii.           Row/Tuple/Record

iii.           Columns - attributes

iv.           RDBMS

v.           Relational diagram

vi.           Query Language

i.           SQL

1.      The end-user interface

2.      A collection of tables

3.      SQL engine

d.      Entity Relationship Model

i.           ERD

ii.           ER Model

i.           Entity

1.      Instance/occurrence

2.      Set

ii.           Attributes

iii.           Relationships

iii.           Notations

i.           Chen

ii.           Crow's Foot

iii.           Class diagram/UML

e.      Object Oriented Model

i.           Objects

ii.           Semantic data model

iii.           Classes

iv.           Methods

v.           Class hierarchy

vi.           Inheritance

vii.           UML

f.       Object/Relational and XML

i.           ERDM extended relational data model

ii.           XML

Attached Files: | - KVCC BUS210_DatabaseDesignMgt_Outline 6.pdf