CST 363 Weekly Journal #1

 

1. Relational database tables and spreadsheets look similar with both having rows and columns.  What are some important differences between the two?

- Relational databases enforce data integrity through features such as primary keys which ensure that data remains consistent and accurate while spreadsheets lack built-in structures for data integrity, which makes them more prone to errors such as inconsistent formatting.

2. Installing and configuring a database and learning how to use it is more complicated than just reading and writing data to a file.  What are some important reasons that make a database a useful investment of time? 

- Databases offer some security features, for example, encryption, which protects sensitive data from unauthorized access, and theft. They also allow administrators to define access controls and permissions to restrict access to sensitive information.

3. What do you want to learn in this course that you think will be useful in your future career? 

- I want to learn everything about SQL and master it so that I'm able to remember all the shortcuts with SQL and use it within my job career.