Learning about data modeling and how to create an Entity Relationship Diagram was very appealing to me. As one of the readings mentioned, my initial thought is to use an excel spreadsheet but in the examples and readings I see the benefits of using a relational database management system (RDBMS) such as Microsoft Access when wanting to extract complicated information from a collection of data. However, in order to understand RDBMS, one must understand how ERD’s work. I found the blog regarding ERD’s on the Rapid Application Development website to be helpful in explaining the notations (crow’s feet, dash and 0) and the relationships between the entities. My understanding is that many-to-many relationship are not possible in databases and the solution is to do a link/bridge. The linking concept is still unclear but I’m sure I will grasp this concept after I see more examples. The Three Normal Forms tutorial was also helpful as it provided an example with step-by-step instructions on the process. However, more examples with explanations on the process would definitely be helpful.
No comments:
Post a Comment