In-class notes for 04/17/2020

CS 284 (MCA), Spring 2020

• Quotes in SQL commands

  • Type in SQL code yourself to get familiar with the language (and avoid this kind of error)

• Modified Daily plan

  • Move HW10 and Quiz 5 each one day later

  • Drop HW11

• HW9 parts C and D, building from readings

  • Constraints in CREATE TABLE

    • Such as primary key, unique, not null

    • person example: foreign key, check

      

    • Postgres regular expressions phone ~ '[0-9][0-9][0-9][0-9]'

    With constraints, can enforce data integrity and avoid relationshiops that shouldn't be permitted

    • You don't need to memorize all of this, but if you know it exists, you can look for it (in manuals, google search, etc.) and build into a project

  • Databases vs file systems

• Worksheet 16

< >