A handful of entities and relationships will suffice. There is no need to add every feature that might be desirable. The site should allow you select items as you browse the product catalog and add them to the shopping cart. Shopping carts should be able to handle any number of items. Besides the design you used, identify one other way in which this requirement could be modeled in an ER model.
Customers sometimes like to choose different payment forms for different orders.
For this problem, you will write queries using relational algebra to answer questions about the contents of a simplified bug-tracking and sales database for a small software company. String The full email address of the person assigned to fix the bug. String A text description of the bug. String The name of the product. Each customer is assigned a unique integer by the sales group.