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.
There are multiple tools that can be used to create an ERD. A popular tool for creating ERD’s is Lucid Chart (https://www.lucidchart.com/) and you can create a Lucid Chart account for free of charge using your school email.
