In 2007, DoubleClick (purchased by Google for $3.1 billion) worked with over 4,4

Question

In 2007, DoubleClick (purchased by Google for $3.1 billion) worked with over 4,400 advertisers and delivered over 30 billion advertising banners every month. An advertiser, such as Toyota, contracts with DoubleClick to direct new car seekers to the Toyota site for more information. DoubleClick then uses its network of affiliated websites such as AltaVista or Kelly Blue Book to deliver Toyota ads to targeted demographics. For example, DoubleClick would display Toyota banners on AltaVista whenever a user searches for car information (i.e., with automotive-specific keywords). Each time DoubleClick delivers an ad to a PC, it keeps track of that fact in its growing database. (DoubleClick identifies a PC by having stored a "cookie” file on that PC.)

Consider DoubleClick's database needs. Each advertising banner is given a unique identifier (AID) and they need to record the client company (e.g., TOYOTA, OU, etc.) to which the ad
belongs and the start-date and the end-date for the ad's use. Each marketing interest category (demographic) is identified by a DID and a description of the category (e.g., EDUCATION, CARS, GAMING, TEEN HEALTH, STOCK MARKET, etc.) is also stored. Client companies tell DoubleClick which target demographics are intended for each of their ads. Each web surfer (or PC) is identified by a DoubleClick assigned cookie id. The initial date that the cookie was set is kept track of. In addition, each time DoubleClick is asked to send an advertising banner to a surfer, it records the demographics of the page requested by the surfer as areas of interest for the surfer. By matching the demographics of interest to the surfer and ads targeting those areas of interest, DoubleClick chooses an ad and sends that to the surfer. Moreover, it records the date/time an ad has been sent to the user and whether or not the user clicks on the ad (at which point, DoubleClick redirects the user to the home page associated with the advertising banner).

Discussion Assignment. Give the ERD for the database needed to support the above targeted advertisement delivery.

Specifically, attach the ERDPlus file for your solution to your post namedLastName's Solution. Please make sure to include a text label on the diagram indicating your name.

Also, post the graphic image of the ERD so that others can see your suggested solution.

Feel free to comment on others' solutions so that as a team you can arrive at a correct solution.

Explanation / Answer

ER diagram:

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.