Individual Assignment 6

In this assignment (IA6) I learned a lot about how relationships between relational databases versus spreadsheets. In a relational database the different information is separated into separate charts, but are still connected by one-to-many relationships or one-to-one relationship. This assignment only contained one-to-many relationships, but we also learned that many-to-many relationships should not exist and that they are bad. Finding relationships between relational spreadsheets is more difficult because the way spreadsheets are presented does not allow the user to easily connect them.

      Keys are the columns that identify unique row in a table. We need them in queries to make the process of identifying something in relation to something else easier. Queries are the requests from databases for data. We need this to be able to find information. Forms are used to read, insert, modify, and delete database data. These key concepts in relational databases could be useful to future personal and professional projects because it ensure that whatever we are trying to record is detailed and well organized.