Databases Reference
In-Depth Information
CUSTOMER
Customer Number
Customer Name
Street
City
State
Country
0..*
SALE
CREATION
Date
Price
Quantity
Percent of
Responsibility
1..*
PRODUCING
COMPANY
Company Name
Company Type
City
Country
Telephone
Year Founded
PRODUCT
Product Number
Product Name
Year Created
CREATOR
Creator Number
Creator Type
Creator Name
Year Born
Year Died
1
0..*
1..*
1..*
BOOK
PERIODICAL
Volume
Number
Pages
CD
Number of Tracks
Length
Chart Rating
VIDEO/DVD
Length
Pages
Add Book
Remove from Shelves
Update Chart Ratings
1
1
1..*
1..*
ARTICLE
SONG
Title
Author
Length
Writer
Year Written
FIGURE9.6
Good Reading Bookstores class diagram
new BOOK instances, i.e. BOOK objects, as new books are published and added to
the store's inventory. PERIODICAL has a query-type operation associated with it
that calculates the date when each periodical is to be removed from the store shelves
if it has not been purchased by then. CD has an update-type operation associated
with it that changes the value of a CD's Chart Rating attribute on a weekly basis as
new industry-wide popularity charts come out.
Notice that the PERIODICAL class, and only this class, is associated with the
ARTICLE class. Similarly, the CD class, and only this class, is associated with the
Search WWH ::
Custom Search