CST 363 - Introduction to Database - Week 4

-

 




1. Briefly summarize 5 things what you have learned in the course so far.
  • MySQL Workbench - I have learned how to use MySQL workbench and I think this tool is going to be beneficial in my future career. 
  • SQL - I have learned how to write complicated queries in SQL. I think the fundamentals of SQL are easy to learn but it gets complicated once you start writing queries where you have to join multiple tables. 
  • Database Fundamentals - Learning how a database works using Java is also beneficial for us as students. I think the Java labs are challenging but it helps us learn more about databases. 
  • ER Diagrams - I have learned how to read ER diagrams. Sometimes ER diagrams get so complicated, but I think I have learned the fundamentals to be able to read simple ER diagram. 
  • Relational Data - I have learned the importance of relational databases. Understanding many tables full of data can be challenging, this is where relational databases play a critical role in managing a big amount of data. 
2. List at least 3 questions you still have about databases.
  • First question - Is NoSQL better than SQL? This is because SQL gets really complicated once you are retrieving data from multiple tables. 
  • Second question - How do I choose the right database management system for future applications?
  • Third question - What are the best practices for optimizing database performance?


Comments

Post a Comment

Popular posts from this blog

CST 334 - Operating Systems - Week 6

-
Image
  This week in CST 334, we learned about the concept of semaphores, a fundamental synchronization primitive in operating systems. Semaphores manage access to shared resources using an integer value, which can be incremented or decremented by operations like `sem_post()` and `sem_wait()`. These operations allow semaphores to control resource access, ensuring that threads wait when the resource is unavailable and proceed when it becomes available. A key form of semaphore is the binary semaphore, which functions similarly to a lock by permitting only one thread access at a time, ensuring mutual exclusion.  In addition to basic semaphore usage, we explored various common concurrency problems that semaphores can help solve. For example, in the Producer-Consumer problem, semaphores signal the state of a buffer, preventing data corruption or loss. Similarly, the Reader-Writer problem uses semaphores to manage access, allowing multiple readers or a single writer to use the resource, b...
Read more

CST 363 - Introduction to Database - Week 3

-
Image
  Explain in your words what 3rd normal form is and why it is important. Third normal form, also known as 3NF, is a crucial aspect of database normalization. The third normal form makes sure that the data stored in a relational database is organized to reduce redundancy and improve data integrity. In other words, 3NF is a database schema design approach for relational databases which uses normalizing principles to reduce the duplication of data, avoid data anomalies, ensure referential integrity, and simplify data management. Adhering to 3NF in database design is fundamental for building efficient and reliable database applications. It not only helps maintaining clean data structures but also supports accurate and efficient query responses.  What is an SQL view. How is it similar to a table? In what ways is it different? An SQL view is essentially a virtual table in a database that is not physically stored. Instead, it is defined by a query. A view can contain all rows of a ...
Read more

CST 311 - Intro to Computer Networks - Week 1

-
Image
  This week in CST 311, I learned a lot about the concepts of computer networks, starting with an understanding of the internet's structure and operation. The internet is basically a network of networks, consisting of many connected devices, communication links, and packet switches, all working together with various protocols like TCP, IP, and HTTP. I also learned about the different components of a network, such as the network edge, which includes hosts like clients and servers, and the network core, where packet switching and routing occur. The significance of protocols is so important, as they define the format and order of messages sent and received in the network. Another topic was the concept of delay, loss, and throughput in networks. I learned about the different types of delays such as processing, queuing, transmission, and propagation which affect the overall performance of a network. The introduction to the internet protocol stack is also important, where I learned about...
Read more