Blog

Instructions: Create an EERD model for each scenario using M…

Instructions: Create an EERD model for each scenario using MySQL Workbench.  Identify tables, primary keys, foreign keys, relationships, and cardinality (crows feet).  Submit a .mwb file for each scenario on Canvas. You need to design a database for a bookstore chain. The database should capture all the information that bookstores need to maintain. Bookstores keep records of authors, including each author’s unique name, birthplace, age, and primary genre. For each book, the database must store details about the author, the year of publication, the book’s unique title, its genre (e.g., fiction, non-fiction, mystery, biography), and its price. Books may also belong to one or more categories, such as bestsellers, classics, new arrivals, or award-winning books. Each category is identified by a unique category ID and a category name that describes the grouping (for example, “Science Fiction Classics” or “Mystery Bestsellers”). The bookstore also tracks information about customers. For each customer, it keeps the person’s unique name, address, total amount spent at the bookstore, and the authors and categories of books that the customer prefers. Design your database to manage these records efficiently, capturing the relationships among authors, books, categories, and customers.