Database

What is a database?
A database collects data in a structured format. This happens so that the information can be easily found, stored and managed.
Used by businesses and even the internet for this program.

What are the different types of databases?
Customer list
Product informaation
mailing list
reservation system
phonebook
gps

2 different types of data bases:
flat file(excel spreadsheet)
relational databases (access, this can contain many different areas of information)
Table: within a table there are
Every column in a table is known as a field
Every row in a table is known as a record.
ID: If we know the id, is all we need to find info (ID is King)

different ways to set up but the general principal:
Primary key - only one, therefore makes info easier to find.