Interactive Smart Quiz Website

I need a lightweight yet engaging “Smart Quiz Game” built with pure HTML, CSS, JavaScript and an SQL-backed database. The site is aimed at high-school students, so the interface must feel colorful and playful rather than corporate.

Here’s the game flow I have in mind: a student lands on the page, types in their name and course, then chooses a quiz pack. Each pack will mix multiple-choice and true/false questions that you’ll pull from the database. After the last question, the site instantly shows the score, highlights the correct answers, and offers a quick button to jump into another pack without refreshing the page.

On the back end I just need a straightforward schema that stores questions, options, correct answers, quiz-pack tags and basic user attempt logs. Keep it simple enough for a college submission but cleanly organised so I can extend it later.

Deliverables
• Fully commented HTML, CSS and JavaScript files
• SQL script to create and seed the tables with sample questions
• One colorful, playful theme (no external frameworks; vanilla code is fine)
• Clear instructions for local setup and adding new question sets

I’ll review by running the site locally: if it loads fast, records attempts, grades accurately, and lets me replay or switch packs without glitches, we’re done.