"Database" ~ Wikipedia
Talk about taking things for granted! I work with a database everyday and I never think about the complexity of the concept. I found this article to be very interesting. One of the most interesting ideas was that terms such as query languages, DDL and DML can be viewed as "special - purpose programming languages, tailored specifically to manipulate databases". When I build a query, I generally do not think of it being a special purpose language. Perhaps I will in the future.
"Entity relationship model in database" ~Wikipedia
Seeing an entity as a noun, an entity type as a category and a relationship as a verb really helped me to visualize the concept. Chen's examples of relationships such as marriage relationship with husband and wife and song and performer relationships were concrete and helped me to relate the idea to how the relationships work.
"Database normalization process"
This tutorial was, in my opinion, well written and presented. the use of pictures and diagrams help me to understand the information. It is very interesting that it actually requires work to de- moralize a database. I am not sure I could sit down and construct a database after this tutorial but i do feel like I understand the relationship between the data better. Also having the text- text connections from the two previous articles helped to make this article clearer.
No comments:
Post a Comment