CST 363 Week 1 Learning Journal
Part 1: Relational Database Table and Spreadsheet Spreadsheets and relational databases allow the user to manage data in different ways. A spreadsheet provides easy access to data in cells and allows the user to manage information in a table. The user can easily add, delete, update, and sort rows and columns of information regardless of how the information is connected. Changes can be made directly in the cell, and the user can see all information. Information does not need to be a certain type unless a formula is applied to a certain cell. Relational Databases hold their information in tables that the user does not have access to unless certain queries are called to access and manage the information. Queries involve the use of keywords such as "SELECT," "DELETE," and "INSERT." Data in relational databases have a more secure way of managing data as there are certain rules that need to be followed so that information can be updated. In relational database...