Category: Modeling
ERD - Basic Constructs
![[mail]](img/envelope.gif){kind=small}
Looking at the stats of Yackity Blog Blog, I noticed that First 3 Rules of Data Normalization for Newbies gets a lot of hits. So, I thought today I would write about a very basic concept - the Basic Constructs of Entity Relationship Diagrams (ERD).
Th… more »
Technique to Map Business Process to Data Model
Getting input from the users increases the quality of a data model. Joint Application Development (JAD) sessions facilitate and accelerate the modeling process. During the JAD sessions, subject matter experts validate the model with respect to supported… more »
First 3 Rules of Data Normalization for Newbies - Part 3
This is the last of the series on the 3 Rules of Normalization for Newbies. If you have forgotten the first 2 rules, review the 2 previous blogs because inherent to the 3NF Rule is compliance with the first two.
The 3NF Rule states: "No non-UID can… more »
First 3 Rules of Data Normalization for Newbies - Part 2
In yesterday's blog, I discussed 1NF. Today, as promised, is the blog about 2NF.
The 2NF Rule states: "An attribute must depend upon its entity's entire UID". This basically means that every one of the attributes is functionally dependent on the whole… more »
First 3 Rules of Data Normalization for Newbies - Part 1
The First Normal Form States: "All attributes are not repeated or must be single-valued"
In identifying whether a table is in its 1NF, consider this 3-points checklist:
1. Does a Primary Key exist?
2. Have you ensured that each attribute is in its b… more »
XML Feeds