Two mountainous tablesA table is all about relationshipsAtomic data30 minutes or it’s freeLocation, location, locationAsking atomic questionsMore atomic updatesGet into a normal routineWhat’s normal and 1NF?PRIMARY KEY to successGetting to normalThe CREATE TABLE with a PRIMARY KEY1, 2, 3... automaticallyAdding a PRIMARY KEY to an existing tableALTER TABLE to add a PRIMARY KEYThink outside of the single tableAbby’s database schemaGoing from one table to twoQuerying two tablesConnecting your tablesFOREIGN KEY to successConstraining your foreign keyCREATE a table with a FOREIGN KEYOne-to-oneWhen to use one-to-one tablesOne-to-manyMany-to-manyWe need a junction tableFixing data patternsHow normal can you be?Composite keys use multiple columnsEven superheroes have dependenciesPartial functional dependencyTransitive functional dependencySecond Normal Form (2NF)Third Normal Form (3NF)Your SQL toolbox
