Entity Relationship Diagram

  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.

https://youtu.be/-fQ-bRllhXc

https://youtu.be/QpdhBUYk7Kk

https://youtu.be/-CuY5ADwn24

https://youtu.be/c0_9Y8QAstg