CST 363 Week 1

 This week has been really eventful and insightful, I am loving the structure of this class and the information we will learn. As someone who has been using database for quite a while, this is a great refresher. I have been using Oracle databases at work for the past year but I haven't learnt about it in detail. 

1. The difference between databases and spreadsheets comes in its functionality and structure. Databases enforce strict data types and relationships between tables using constraints like the primary key and foreign key. On the other hand, spreadsheets are more flexible and doesn't have the same enforcement. One other major difference is that using a database allows multiple users to work on it without having to face issues like when working on a single spreadsheet. 


2. Even though installing and configuration a database and learning how to use it is more complicated that just reading and writing data to a file, using a database ensures data integrity by enforcing the rules mentioned in point 1 and allow for effective and efficient data management. It makes it really easy to query for information you need and getting that information in the format that meets your business requirements. Databases are also designed for scalability and can handle a huge volume of data along allowing multiple people to work on that data with no problems. And finally using a database correctly can help you in the case of getting your data deleted where you can get it back if it ever gets corrupted. 


3. For me personally, I am really interested in learning different types of databases and very excited to learn about MongoDB and of course getting a refresher is always a plus. 

Comments

Popular posts from this blog

CST 462S - Learning Journal (service learning)

CST 300 Week 7