This tutorial discusses the design of a database that tracks customer orders.  Here is a link to a document that discusses the design of the database (click to view).  See the attachments for a copy of the access database created in this tutorial and a LibreOffice version of the database.