Hello,

I am taking an Intro to Database Management class this semester and we are on our last assignment for the class. The first part is making an ER diagram on ERDPlus and I need help making it. I have attached screenshots of the information needed to construct the diagram.

Thank you so much!

Assignment Details:

Jack Seller and Jill Innovatre are business partners and have decided to create a website to sell automotive products. While they intend to sell some of the products themselves, they will also provide a platform for other sellers to be able to sell their products (new or used). They have decided to hire you to design a database that would be at the back-end of the website. The database will capture the details of a customer such as a username and password, customer name, address (street address, city, state, zip), customer credit card details such as credit card number, name on the credit card, and expiry date. The details of the customers' orders will also need to be stored such that once the customer has selected a number of products to buy, the customers should be shown the products selected, the product description and product price, sales tax applied, and order total before the customer can place an order. The database should keep track of product details such as product description, product price, and product type (new or used). Each product will be sold by a seller (e.g. some products will be sold by website owners Jack Seller and Jill Innovatre under the name J&J while some other products will be sold by other sellers). It would be important to capture the seller details such as seller name, seller official address, seller phone number, seller e-mail address (if customers wish to get in touch with them with inquiries or complaints), and seller bank account details (Routing Number+ Checking Account Number). Customers will be asked to provide product reviews once they buy a product which can be displayed on their website