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.