In this lab, you will familiarize yourself with the process of creating Entity Relationship diagrams and data models.
An auction website has items for sale that are provided by sellers. Each item has an opening price, a description, and an ending time. Customers submit bids. The highest, earliest bid submitted before the ending time is the winning bid and the item is sold to the bidder. Each seller must pay the auction company 5% of the winning bid. The auction company wants to be able to analyze the sales behavior of its customers and sellers and so must keep track of all bids and sales.
Draw an Entity-Relationship Diagram in Draw.io for the entities and relationships present in the above description. Your diagram needs to have at least three distinct entities involved in relationships, fully connected with the proper cardinality using the crows-feet Information Engineering style relationships noted above. Each entity should have attributes.
Sketch the above entities and relationships as an SQL Schema in Vertabelo, denoting all primary and foreign key relations. Export your schema as a PNG.
Write a post on your Jekyll Github blog that discusses the assumptions you made to convert your scenario into this data modeling framework. Include with your post a discussion of the PNG exports of your Draw.io ER diagram and Vertabelo schema. Are you satisfied with your resulting data representation?
