==  Admin Manages Genres

=== Actor: **Admin**
An admin adds a new genre to the platform or removes an existing one that is no longer needed.

**1.** The admin navigates to the "Manage Genres" section in the admin dashboard.

**2.** The system displays all existing genres and their usage counts.
{{{#!sql
SELECT g.genre_id, g.name, COUNT(hg.story_id) AS stories_using_genre
FROM GENRE g
LEFT JOIN HAS_GENRE hg ON g.genre_id = hg.genre_id
GROUP BY g.genre_id
ORDER BY g.name ASC;
}}}

**3.** The admin selects "Add New Genre" and enters the genre name.

**4.** The system checks if the genre already exists.
{{{#!sql
SELECT * FROM GENRE
WHERE LOWER(name) = LOWER('Science Fiction');
}}}

**5.** The genre does not exist, so the system inserts it.
{{{#!sql
INSERT INTO GENRE (name)
VALUES ('Science Fiction');
}}}

**6.** The admin also decides to delete an unused genre.

**7.** The system checks if any stories are currently using that genre before deleting.
{{{#!sql
SELECT COUNT(*) AS usage_count
FROM HAS_GENRE
WHERE genre_id = 10;
}}}

**8.** Since no stories use it, the system deletes the genre.
{{{#!sql
DELETE FROM GENRE
WHERE genre_id = 10;
}}}

**9.** The system confirms both changes and refreshes the genre list.