The Database structure has been designed using a Entity Relationship Diagram (ERD). I used Microsoft Visio to design the structure of how I wanted the database design to be layed out. I have attached an image of the ERD to get feedback on your thoughts.

All table rows haven't been shown only most important, the foreign keys have been shown to display the relationship and flow of the design.

Comments and Feedback welcome