Data Modelling
18 practice items · needed by 4 roles
Easy 12Medium 3Hard 3
Practice questions
- What a foreign key enforceseasy
- Storing times for global userseasy
- Embed or reference in MongoDBeasy
- Unique email with soft deleteshard
- Purpose of a primary keyeasy
- Third normal formeasy
- What a foreign key enforceseasy
- Data type for moneyeasy
- Gaps in auto-increment IDseasy
- Storing event timeseasy
- Rejecting bad valueseasy
- UNIQUE column with NULLsmedium
- Deleting a customer takes secondsmedium
- Random UUID keys slow down insertshard
- One-to-many relationshipeasy
- The data dictionaryeasy
- Repeated data in a tablemedium
- Students, courses and gradeshard