Data to store... Document -------- stock number (unique key,index) doc title (index) doc type (foreign key?) shelf location (index) overflow location last revised last reprinted number in stock reprint threshold bundle size notes Document Types -------------- Booklist Service Brochure External Transaction ----------- transaction number (unique key) transaction type (foreign key?) requested by stock number (foreign key) date/time requested quantity requested authorised by authorisation time/date date/time filled quantity filled filled by notes Transaction Types ----------------- reorder reprint recount throw out