Exercise: Monthly Publication Usage

A large task for computer manufacturers is to keep track of their online publications: product specification sheets, marketing brochures, user manuals, and so on.

One major manufacturer had developed a spreadsheet to record the monthly usage of each publication (that is, how many copies of the publication were downloaded each month).

Then they decided to export the spreadsheet into a database.

The export program naturally converted each column of the spreadsheet into a database table attribute, so the result looked something like this:

--------------------

publication

--------------------

pubTile

lastRev:date

jan02USE

FEB02USE

MAR02USE

.

.

.

DEC02USE

-------------------

Revise the class diagram to correct any problems that you find in this design.

Then draw the relation scheme for your corrected model.