Model of a t-shirt collection

Here is the t-shirt model introduced in the previous section. Compare its layout with what I said about my view of t-shirts. I have used spaces only (no tabs) for indentation.
?TShirt  Characteristics  Color Background Red
                                           Green
                                           Purple
                                           Grey
                                           Blue
                                Faded
                                Blotched
                          Size UNIQUE Int
                          Graphics Front UNIQUE Text
                                   Back UNIQUE Text
                                   Sleeves UNIQUE Text
                          Composition ?Country #Components
                          Resembles ?TShirt
         History  Price Float
                  Purchased Year Int
                            Source Store UNIQUE ?Store
                                   Manufacturer UNIQUE ?Manufacturer
                  Borrowed_by ?Person XREF Shirt
                  Damage Text Text //description and date
                  Disposal UNIQUE Int UNIQUE Text
//should I move Remarks up to next level? 
                  Remarks Text
         Wear_on_days Int REPEAT //days of months to be worn
What follows is a detailed look at the components of the model along with valid (and invalid) variations. I will also introduce other models that help support this one.

Back to Table of Contents