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

1.      Assignment 2

2.      Career overview

3.      Database design - Focus on how will be used

a.      Database modeling

i.           Data model

1.      A description of the data structure that will store the end user data

2.      A set of enforceable rules to guarantee integrity

3.      A data manipulation methodology to support real world data transformations

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

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

6.      Business Rules

7.      Obtaining business rules

a.      Importance

i.           Standardize company's view if 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

8.      Translating business rules into data models

a.      Noun - entity

b.      Verb - relationship between

9.      Naming Conventions

Attached Files: | - KVCC BUS210_DatabaseDesignMgt_Outline 5.pdf