Database plans

With the concept for this project firm in my mind I started playing around with the database layout. As for me I knew what I wanted to achieve as an end product (a scaled down version of what I originally wanted the new OJF to be), so it was piecing together all the pieces into a layout for the database. I have refined and refined the layout trying to make it more dynamic and less full of unnecessary information.

There are 2-3 key parts, the first being the list of all the entries, then the categories (genre's) for those films and finally the lists. The lists are exactly as they sound, a list comprised of some of the main entries along with a load of information about the list itself.

Really need to make sure to get all the areas covered that I want and also look into MySQL's stored procedures as well as I want to use those seeing as they are now available to me.