ChamplainTechJournals/db-security-sec300/week3.md
2025-04-19 23:42:08 -04:00

12 lines
488 B
Markdown

# Week3
Filtering at the Database
- Create a trigger that will replace numbers entered to the cats name with the character 'X'.
![image](../assets/1ae0ed12-ac5c-4a8a-bb70-cbfbe1b28a3a.png)
- Alter the table cats to add a CHECK that will not allow any cat birthday after 2024-11-23.
![image](../assets/fd5cfed4-9f89-46ea-82e9-e5f8f593a8c2.png)
- Add another CHECK into cats that restricts the cat's name to 12 characters.
![image](../assets/e7adaa35-9aaa-4f0c-8a93-4f4ded361027.png)