The Scenario
A publisher needs a database to power their new multi-author blog. They need to track Users, Posts, and Tags. A post can have multiple tags, and a tag can belong to multiple posts.
The Brief
Design the SQL schema (tables, columns, and foreign keys) for the blog. You must correctly implement the many-to-many relationship between Posts and Tags.
Deliverables
- An Entity-Relationship Diagram (ERD) or a set of `CREATE TABLE` SQL statements
- The definition of the junction/join table connecting Posts and Tags
Submission Guidance
Do not forget foreign key constraints. Ensure you define primary keys for all tables.
Submit Your Work
Your submission is graded against the rubric on the right. If you pass, you get a public Badge URL you can share on LinkedIn. There is no draft save, so work offline first and paste your finished response here.