Talk:Bklein7 Week 6

Lecture on 9/29

• Relational Databases- most common type of database
  • PostgreSQL Tutorial
  • Databases History
    • Prior- Network Databases; ended up getting blown out of the water and unified by the relational database
    • Future- No SQL Databases
  • Structure- series of tables
    • Tables are collections of rows that give specific instances of information that complies with an overall structure. The domain (set of accepted values) for each column is specified. Some possible domain options include marker, number, and text.
      • The table is the standard unit of the relational database.
    • Became popularized due to its strong mathematical foundations.
    • A relational database is a collection of several tables. Coordinated information.
      • The particular plan for a database that describes what's in it and where everything is located is reffered to as a schema.
  • Key- singular value that serves to identify the rest of the data in a particular row (e.g. id column)
    • Primary Key- the chosen value that it is agreed upon for everyone to use as an identifier; typically easy or conveint
    • Foreign Key- storing information in one table using the primary key of another table; primary use of keys is to connect tables
      • foreign keys can link together dozens of tables in unique ways; establish many to many relationships (tables that connect other tables)
• SQL (can use pgAdmin III)
  • 2 Conceptual Parts
    1. Data definition language (DDL)
    2. Data manipulation language (DML)
  • DDL Commands
    • create table
      • table name, column name & data type, column constraint, primary key, references, etc.
  • In class example
    • Create Database
    • create table movie (id int primary key, year int, title varchar)
    • (review)