In: Computer Science
Use following case and create Entity-Relationship Diagrams using the Crow’s Feet method for each. Each ERD should be completed on a separate sheet of paper, if drawn by hand. If additional assumptions are made for any of your 2cases, be sure to document the additional business rules and include them with your ERDs.
Entity-Relationship Diagram : TEXTBOOK REVIEWS Your website would like to add the ability for school BIT students to provide reviews for textbooks they have previously used. Using the following business rules, create an ERD:
Students must enter the ISBN for the book, along with its title, author, publisher, and copyright date.
Users will be asked to select what course the book was used for from a predefined list of courses offered in the BIT division.
Each course will be assigned to a program such as Web Development, Software Development, Computer Support, Photography, etc.
Each book can have more than one author.
Each book can only have one publisher.
Each book could have been used in multiple courses.
Many reviews could be written for a book, but each review can only be about one book.
Reviews may be written anonymously or by a logged in user.