Entity  Review
Attribute       Review  ReviewID
Attribute       Review  ItemID
Attribute       Review  ReviewNote
Attribute       Review  ReviewDate
Attribute       Review  ReviewBy
Attribute       Review  ReviewType
Entity  Items
Attribute       Items   ItemID
Attribute       Items   Title
Attribute       Items   ItemType
Attribute       Items   ProduceDate
Attribute       Items   ListPrice
Attribute       Items   CurrentPrice
Attribute       Items   description
Attribute       Items   Category
Attribute       Items   Photo
Attribute       Items   Availability
Attribute       Items   Rank
Attribute       Items   Subject
Attribute       Items   Status
Attribute       Items   Price
Entity  Book
Attribute       Book    ISBN
Attribute       Book    Publisher
Attribute       Book    Cover
Attribute       Book    Pages
Attribute       Book    Author
Entity  Member
Attribute       Member  MemberID
Attribute       Member  Passwd
Attribute       Member  FirstName
Attribute       Member  LastName
Attribute       Member  Email
Attribute       Member  Address1
Attribute       Member  Address2
Attribute       Member  City
Attribute       Member  State
Attribute       Member  Zip
Attribute       Member  Country
Attribute       Member  Phone
Attribute       Member  MemberIDno
Attribute       Member  PasswdHint
Attribute       Member  BillingAddress
Attribute       Member  ShippingAddress
Attribute       Member  CreditCardNo
Attribute       Member  ExpirationDate
Attribute       Member  MiddleName
Attribute       Member  Title
Attribute       Member  AddType
Attribute       Member  Address
Attribute       Member  DaytimePhone
Attribute       Member  EveningPhone
Attribute       Member  UserName
Attribute       Member  QuichCheckoutFile
Entity  Transaction
Attribute       Transaction     TransactionID
Attribute       Transaction     MemberID
Attribute       Transaction     PaymentMethod
Attribute       Transaction     CreditCardNo
Attribute       Transaction     ExpirationDate
Attribute       Transaction     CardholderName
Attribute       Transaction     ClaimCode
Attribute       Transaction     TotalCharge
Attribute       Transaction     ShippingTyoe
Attribute       Transaction     ItemID
Attribute       Transaction     ShippingID
Attribute       Transaction     GiftWrapID
Attribute       Transaction     GiftMessage
Attribute       Transaction     ShippingAddress
Attribute       Transaction     BillingAddress
Attribute       Transaction     GiftCertificateID
Entity  Video
Attribute       Video   Rated
Attribute       Video   EditionDetail
Attribute       Video   Type
Attribute       Video   OtherType
Attribute       Video   Staring
Attribute       Video   Starring
Attribute       Video   Director
Attribute       Video   Producer
Entity  GiftCertificate
Attribute       GiftCertificate GiftCertificateID
Attribute       GiftCertificate ByMemberID
Attribute       GiftCertificate ToMemberID
Attribute       GiftCertificate AmountBought
Attribute       GiftCertificate AmountUsed
Attribute       GiftCertificate ValidationNo
Entity  GiftWrap
Attribute       GiftWrap        GiftWrapID
Attribute       GiftWrap        GiftWrapDescription
Attribute       GiftWrap        GiftWrapPhoto
Attribute       GiftWrap        Price
Entity  ShippingOptions
Attribute       ShippingOptions ShippingID
Attribute       ShippingOptions Method
Attribute       ShippingOptions ItemType
Attribute       ShippingOptions PerShipmentCost
Attribute       ShippingOptions PerItemCost
Attribute       ShippingOptions ShippingTime
Entity  Music
Attribute       Music   NoofDisc
Attribute       Music   Company
Attribute       Music   TrackList
Attribute       Music   ListeningSample
Attribute       Music   Format
Attribute       Music   UPC
Attribute       Music   Label
Attribute       Music   Performer
Relationship    Review  GiftWrap        Unused
Relationship    Member  GiftCertificate Unused
Relationship    Book    Video   Unused
Relationship    Book    GiftWrap        Unused
Relationship    Items   Book    Unused
Relationship    Transaction     GiftCertificate Unused
Relationship    Transaction     GiftWrap        Unused
Relationship    GiftWrap        ShippingOptions Unused
Relationship    Video   GiftWrap        Unused
Relationship    Items   GiftWrap        Unused
Relationship    Book    Transaction     Unused
Relationship    GiftWrap        Music   Unused
Relationship    Review  Music   Unused
Relationship    Video   ShippingOptions Unused
Relationship    Items   Music   Unused
Relationship    Transaction     Music   Unused
Relationship    ShippingOptions Music   Unused
Relationship    Book    Music   Unused
Relationship    Book    ShippingOptions Unused
Relationship    Review  Video   Unused
Relationship    Items   Review  Unused
Relationship    Items   Member  Unused
Relationship    Video   Music   Unused
Relationship    Items   Video   Unused
Relationship    Review  Book    Unused
Relationship    Transaction     Member  Unused
Relationship    Review  ShippingOptions Unused
Relationship    Review  Transaction     Unused
Relationship    Transaction     Video   Unused
Relationship    Items   ShippingOptions Unused
Relationship    Transaction     ShippingOptions Unused