Final Learning Journal Entry - CST363-30-2253

Flavio Cervantes

June 19, 2025


Briefly summarize the what you consider to be the three (3) most important things you learned in this course.


    One of the most valuable knowledge areas that I gained via CST 363-30-2253 is "Database Architecture", I learned the importance of understanding what each database is designed for and the benefits of using it for that purpose in order to use built-in libraries or code to efficiently. For example, if one needs to run analytic scripts again data, then a Data Warehouse design is best for this. MySQL is best designed for processing queries and connection handling. I learned the difference between replicated data and distributed data; this is important because depending on the application one can design the database to have an offsite replication or distribute the data stored in different physical locations. 

    Another important concept that I learned in this class is "DB Design", I was able to learn the various approach to design a database. These factors include entities, relationships, attributes, strong and weak entities, and foreign keys to relate entities from different tables to communicate with another entity. This is useful for complex queries, where one joins queries from one table to the other. I learned that strong entities don't rely on any other value, where weak entities do rely on another. The task discovery phase is also important, this is the ability to understand a business request and to be able to correlate it onto the respective DB language needed. 

    Last but not least, I learned how MongoDB works, this is also known as a NoSQL DB's, they are good for java style databases, can be used for housing "document" style applications such as a HealthCare application where one can register as a patient or doctor, then that doctor can assign the patient a prescription as long as that value is inserted into the database via a .\mongosh file.js command. Finally, one can use .html files, controller, views, repo's, MongoDB, and other java classes or interfaces to obtain a fully web browser-based application. 


Comments

Popular posts from this blog

Learning Journal - CSUMB - January 6, 2025

Learning Journal - Week IV

Learning Journal - CSUMB - January 15, 2025