A brief introduction to databases
There are different types of databases. For one, there are transactional databases, where all the information is stored in rows. So, for example, if you have a product in a table, then everything about that one product will be in one row. Transactional databases are normally built for Create, Retrieve, Update, Delete (CRUD) row operations. In these types of databases, there is typically a primary key so that if a product category name needs to be changed at any point, you can change one record that will automatically update all the products related to this. This sometimes happens in data warehousing, where one product is replaced with another product as the initial product is no longer available or has been discontinued. These databases customarily have systems and operators that do data entry and modifications. One of the biggest problems with this type of database is that there are numerous different relationships between the tables, so when you...