Overview of Databases

Aspects of DBs

• DBs should be:
  • Organized
  • Secure
  • Reliable
  • Consistent
  • Efficient
  • Standardized
  • Language independent
• They have:
  • Rows
  • Tables
  • Relations
  • Keys
  • Columns
  • Indexes
• They're handled with: DMLs and DDL
• Each table has a name that starts with a capital letter
• Attribute names start with lowercase letters
• Each attribute has a domain
• We write primary keys with
  • nameOfTable_id
    • Note that table names are lowercase in primary keys
  • Table name should be lowercase
• Rows ought to be unique
• With foreign keys (the primary key of another table), use the same ID
• CRUD: Create, Read, Update, Delete
  • Operations for a persistent storage application