The story
The last feature of the course, and you get it the way you'd get it at work: as a description of what users should see. No table names, no columns, no hints about which SQL to use.
Feature: notifications
Users get a notification when someone likes one of their posts, comments on one of their posts, or follows them.
The bell icon shows how many unread notifications a user has.
Opening the dropdown lists their 20 most recent unread notifications, newest first. Each one reads like "bob liked Why I switched to Postgres" or "carla followed you".
Clicking "mark all as read" clears the count.
A user is never notified about their own actions.
If the post, or either account involved, is deleted, the notification disappears.