Drinker (Patron) page

Bar page

Beer page

SQL query box

Modification page

• Foreign keys for Frequents, Likes, and Sells each of the three tables – frequents, likes and sells.
• Key constraint for Sells (bar, beer -> price)
• Assertions for three patterns (do not allow update, and display error message explaining violation of assertion)

Link to webapp