ERD DIAGRAM

Company Introduction: Henry Books Ray Henry is the owner of a bookstore chain named Henry Books He has been keeping information about his company, but has decided it is time to store his data in a database. He has made this decision because he wants his data to be current and accurate. His spreadsheets are also becoming more complex with redundant data that is difficult to sort and search. He wants to be able to create forms and reports from his data. He also wants his data to answer questions for him about his company. Kay wants to tracK: Branches: . Name Location Number of employees Titles of books they stock and how many are in stock at each branch * Publishers . Name . Books they publish Authors Name Books they wrote Books * Reference information (title, author, publisher, date, subjects) . Price Quantity of each book at each branch Henry Books Business Process (how they will use the database): Customer calls to find out all books the store branches have by a specific author Customer comes into store looking for a book (or calls on phone) * Employee checks to see if that book is currently in that branch, or at a different branch