CST 363 - Introduction to Database - Week 1
Relational database tables and spreadsheets look similar with both having rows and columns. Whare are some important differences between the two? Some important differences between the two are: scalability and data structure. Relational databases are designed to handle complex relationships between multiple data tables through the use of foreign keys and primary keys. Also, databases are built to scale efficiently with very large datasets, supporting millions of rows without significant performance degradation. On the other hand, spreadsheets primarily handle flat data that is not necessary related to other datasets and have a threshold for how much data they can handle effectively. Performance may degrade significantly when dealing with large datasets. Installing and configuration a database and learning how to use it is more complicated that just reading and writing data to a file. What are some important reasons that makes a database a useful investment of time? I thin...