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?”
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.