Database management systems notes
Creating Tables
Data types, constraints, and getting the shape right before any data arrives. Every section is a drawn page beside a clear written explanation, about 19 minutes in all.
- Chapter 7 of 34
- About 19 minutes
- 8 sections
Sign in with Google or GitHub and you land straight on this page. DSA comes with the all labs plan and every ChaiCode batch.
In this chapter
- Choosing a data type
- NOT NULL and DEFAULT
- PRIMARY KEY and UNIQUE
- CHECK: rules the data must obey
- FOREIGN KEY and referential actions
- Generated identifiers
- Changing a table that already has data
- The college schema, fully constrained
Next chapters
Read the whole chapter
Sign in and the chapter opens with every drawn page, and all 35 database management systems chapters beside it.
DSA comes with the all labs plan and every ChaiCode batch.