Source: http://solr.bccampus.ca:8001/bcc/file/6c163eb2-1396-4035-84da-76288bdeb6e6/1/Database-Design-1375466250.pdf