After graduating from GW, you decide to run an e-commerce website through which you sell some cool products to consumers. To get started, you build an awesome website
based on the knowledge you’ve learned from our Web Design lab. Next, you start thinking what data your database should store.
Requirements: Draw an ERD to capture the data requirements of running a small business mentioned above. Think from a business owner’s perspective. Use common sense to
determine cardinality. Clearly, the most important information you want to keep track of is:
“Consumers can place orders.”
“From each order, we know who purchases what products for how many units.”
You can make some realistic assumptions if they help. Follow the rules below:
a.Use one-to-many relationships only, and
b.Have at least 3 attributes for each entity you defined.
Sample Solution