Happy Books is a brick and mortar store that sells books. For each book in their database, the store wants to keep the ISBN, book name, author, publisher, genre, and a description. Each genre has its own section in the store along with a description. Happy's remains competitive by frequently offering discounts. Each discount has a numeric identifier, a name (e.g. The Mystery Deal), the percentage savings, and optionally a genre to which the deal is restricted. Each deal should have a start and end date. Happy's also wants to keep track of each book sold. This should include the date, name of the employee who sold it, and the book that was sold. There should also be a field to store the discount identifier if one was used. Only one discount may be applied per transaction. A list of employees should be maintained, including an id, name, role, and hourly wage.

Assignment: Create an ERD and schema based on the description above. Be sure identify clearly Primary Keys (PK), Candidate Keys (CK), and Foreign Keys (FK).