Week 8 learning journal CST 363
Briefly summarize what you consider to be the three most important things you learned in this course.
1. I learned how to design a database using entities, relationships, and attributes. I could apply this to building an ER diagram in mySQL. This helped me to understand structure of databases and how thy connect.
2. I learned how to use SQL to create tables and insert data by using commands like select, join, and group by. Querying data helped me learn that databases are good tools for not only organizing but also analyzing data.
3. I learned that normalization is important. It taught me about constraints like pks, fks, and even how transactions keep the data reliable and accurate.
Comments
Post a Comment