Problem: Suppose your company takes orders for its products, which are supplied to your company by vendors. You want to create a relational database of this information. Discuss the relationship between orders and products and between products and vendors. What tables would you create for this database and what would you include in these tables?
Write responses in detail with examples. Be sure to identify the source of example in your posting.