Week 2 Designing

Watch the lecture

Video: https://www.youtube.com/watch?v=WXk7yDqsKxs

Week 2 Designing

Schemas. Normalizing. Data Types. Storage Classes. Type Affinities. Table Constraints: PRIMARY KEY, FOREIGN KEY. Column Constraints: CHECK, DEFAULT, NOT NULL, UNIQUE. Altering Tables: DROP TABLE, ALTER TABLE, ADD COLUMN, RENAME COLUMN, DROP COLUMN. Charlie.

How to download lecture source code into Visual Studio Code

  1. Log into cs50.dev.

  2. In your terminal window, type

    wget https://cdn.cs50.net/sql/2023/x/lectures/2/src2.zip

    followed by Enter in order to download a Zip file of lecture’s source code into your codespace.

  3. In your terminal window, type

    unzip src2.zip

    followed by Enter to unzip (i.e., decompress) that Zip file.

  4. In your terminal window, type

    cd src2

    followed by Enter in order to “change directory” into that src2 directory (i.e., folder).

  5. In your terminal window, type, e.g.,

    ls

    followed by Enter in order to see the files.