CST363.4 Module 4

5 things I've Learned So far in the course:

• Relational Databases is a powerful means of storing data, minimizing redundancy and establishing relationship across separate tables, ensuring that constraints are set properly, allows for update, delete and inserting across multiple tables.
• Gained more familiarity with the querying language, at first it was a bit confusing since the syntax is sort of open, and there's many different methods one can take to pull the same data. however, gaining familiarity with the different forms of join, using aggregate functions in order to summarize data, and using subqueries has been particularly interesting to learn.
• Typically we've learned of different data structures, but being able to see how a relational database incorporates both a linked list and b+ tree in order to maintain indexes is powerful, and exciting to see, as I can see how using both can speed up run time.
• how much thought is put into when building a database. with the whole idea behind normalization is to decrease redundancy ensuring your use of storage is minimal since duplicacy is minimized.
• Entity Relationship Diagrams and the different relationships tables can have between one another.
• one-to-one means only one entity instance is associated to another's entity instance
• one-to-many means one entity instance is associated to many of another's entity instance
• many-to-many means many entity instances on one table is associated to many of another's entity instances.