Syllabus notes
Relational tables contain rows (tuples) and columns (attributes). A primary key uniquely identifies a row. CREATE/ALTER define structures; SELECT retrieves; INSERT/UPDATE/DELETE change records. Use WHERE to restrict updates and deletes.
Practice
- Explain the concept in your own words with a relevant example.
- Check input assumptions and test boundary cases.
- For a technology choice, identify one benefit and one risk.