Databases
Databases Before I started this class I believed that a database was the same as a spreadsheet. Like many people I used the term interchangeably. Spreadsheet is data stored in a cells, so technically it is an organized collection of information. However, they are static documents (excel) while databases can be relational. Databases are flexible and they can contain "relation data" which is data that can be connected across more than one table. At the beginning of this class we learned some functions in excel. We learned functions like if, countif, vlookup, named ranges; also, we learned to used for multiple worksheets in one workbook. From there, we moved on to learn how r elational databases and how they differ from spreadsheets. We learned about attributes and primary keys. From there, we started working in our ER diagram. We obtain our clean data from a website called CORGIS. We had to find the entities, attributes, primary keys and relationships. The last part of the