solution
Draw an ERD for each of the following:
a. A sale can include many items and an item can be included on many sales.
b. A customer can place an order for different products sold by a retailer. A product may be sold on multiple orders and an order may be for many products.
c. An academic department at Texas A&M Commerce University offers multiple curricula and a curriculum is offered by one academic department. d. A building in Texas A&M Commerce University has multiple rooms and a room is located in a specific building.
e. The Marketing and Business Analytics Department at Texas A&M Commerce University offers courses that may have several prerequisites. Some of these courses may be a prerequisite to other courses.
f. An employee at Texas A&M Commerce University may work on different projects that may be run at multiple locations.
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
