due after 2 hours

MGMT Assignment 5 Relational Database Design Complete the following assignment digitally. Turn in a printed copy AND submit the digital file to

Blackboard no later than Tuesday, October 28th at 2:00 p.m.

Create a simple entity relationship model to record the purchases of books and the customers who bought them. (Use the sample reports needed as a guide.) The database design should contain all entities and attributes needed to allow you to create the sample reports listed below. Indicate primary (#) keys with the numeral sign. Foreign keys may be indicated using the asterisk (*). Reports to be created: 1. List of all books purchased during any specific range of dates, including the title of the book, the first and last name of the customer and the price of the book. 2. A list of all customers who purchased a book with a price over ten dollars, including the customer name, book price and publisher. 3. A list of all customers (first and last name) who purchased a book by one specific author. TIPS: This is a many-to-many relationship (many different customers may buy the same book and many

books may be bought by the same customer.) Keep in mind this assignment is to create a simple

database design. Do not include attributes (columns) that are not needed to produce the lists indicated.

To help get you started in this assignment – below is a sample list of books that could be used in your

database if you choose to.

ISBN Title Price Publisher

901 My Book 8 Que

902 This Book 14 McGraw

903 A Book 7 Pearson

904 Good Book 13 McGraw

905 Short Book 4 McGraw

906 Long Book 63 Pearson

907 Textbook 41 McGraw

801 Resource Book 9 McGraw

802 Best Book 14 Que

803 Book 52 Pearson