3. Provide an ER diagram for the following situation.

You run an advertising firm, and you want to implement a database that represents the following description of your business.

You sell advertisements. An advertisements has an id, name and price.

Advertisements have different types. Each advertisements type has id, media type and target audience.

An advertisement belongs to exactly one advertisement type. An advertisement type can host many different advertisements.

An advertisement can be show on many different media providers. A media provider show zero or more advertisements.

A media providers can own other media providers. For example, Disney and abc are both media providers, but Disney owns abc.

Each media provider has an ID and audience size. There are customers and purchases. Each customer has an id, name, and state.

Each purchase has id, date and total cost. A customer makes at least one purchase. A purchase is made by exactly one customer.

A purchase consists of one or more advertisements. An advertisement can be in zero or more purchases.

The number of times an advertisement will run is stored with each purchase.