Wise-step method in data modeling

by Stefan S
The article that I found it talks about how relational database can be complex for beginner students. A study was conducted and showed that students have been making poor database designs in the past 10 to 15 years. Poor database designs are resulted from not being able to achieve data independence in the data model. There are four questions that we need to keep in mind to simplified method for identifying grouping and relating the relevant facts. The questions are as follows:
“1. What facts should we store?
2. How should we store them?
3. Where should we store them?
4. How are the facts related?”
(Chilton, 2006)
Students need a process to produce an effective Entity Relationship Design and there are three steps process that we should keep in mind. According to Chilton, theses steps include: “determining the data requirements, grouping the data together to form entities, and relating the entities” (Chilton, 2006). An additional fourth step may be necessary where “verifying that the design reflects the users perceptions of the data requirements” (Chilton, 2006).

This article can relate to the class on the fact that we are often confuse where to relate the entity from the left to right or the right to left, or even from the top to bottom or the bottom to top. So we need to step back and use the three steps that I learned from the journal. I can also learn the method better by determining the data requirements, grouping the data together, and relating the entities. Then we can review all the relationship to see whether the cardinality making any sense to what instructed.

Chilton, C. (2006). A step-wise method. Data Modeling Using Entity Relationship Diagrams, 17(4), 385-394.


2 thoughts on “Wise-step method in data modeling”

  1. That is very informative data to know, it would greatly help us when we started to create our own database in class. Listing the 4 main point make understanding what is important in database design a every effective way.

  2. I agree with Quoc, I can’t wait to start learning how to use these rules properly in our databases. I always wondered where should one place what box where. Should it be from top to bottom or side to side. I am sure it will become more clear to us as we gain more experience in this subject and as we get into our projects.

Comments are closed.