My CS Online Journey

I have learned several objectives throughout this course. I have learned the importance of a database and how it can positively affect applications. It can do so by improving the performance of the application as well as its reliability. I have also learned how to write SQL commands and the several ways we can utilize a table. I learned the many basic data types and constraints I had to use during the labs and homework. Another objective I struggled with but I learned was joining different tables. There are a few ways we can join them. I also learned how to design effective databases and by doing so I acknowledge the importance of many-many, many-one, one-one relationships. Another thing that I have learned is indexes.  Questions I still have:  What is a cluster key? How are multi-column indexes beneficial? What is a transaction in regards to a database operation?

 1. An SQL view is based on a stored query. It shows what the query has saved and it is similar to a table. The similarities they have are the structures of columns, and they can be queried in similar ways. The differences they have is that a table cannot store data, and there are no indexes which in result means there are no primary keys. Having no indexes can also affect the performance especially when doing operations like insert, update, and delete. 2. The features that are similar to Java and SQL and the one I noticed right away from starting this class is the if statements being similar to the where clauses. SQL has been a bit easier for me to code and it has been enjoyable to acknowledge all the similarities that SQL and other programming languages have. There are also many functions that are similar as well as how we comment a line. A difference between SQL and Java is how they control the data. Java manages files and SQL manages data in relational databases. Another differ...

1. Relational database tables and spreadsheets are similar but also have differences. Spreadsheet data is stored in a single sheet with no relationships between the different sheets. The relationships have to be inferred or created manually. In contrast, data in relational database tables is stored in tables that can be linked through relationships with each other. In these tables, there are primary keys and foreign keys. 2. Some important reasons that make a database a useful investment of time are the integrity of the data and consistency as well as the performance of the data. It is important to maintain the integrity of the data by using the primary keys to help prevent any duplicates and also by using foreign keys to ensure the consistency of the data. This helps us make fewer errors when dealing with the database. The performance can also be a useful investment because there are several times there is a large amount of data in a database and the databases are designed for that la...