This assignment contains four parts: design; data and queries; derived data; and an evaluation. All parts of the assessment relate to the Forest Films scenario below. Scenario Forest Films is a film production company based in London (UK). The company specialises in making short information films and television advertisements. The company would like you to design and implement a database that meets the requirements for its data. These requirements are specified in this scenario and the examples of paper documents kept by the company shown below. Forest Films organise their data around the concept of a 'production'. A production is specified for a particular client, but note that a client might have more than one production at any time. A production will take place at one or more locations. A production will also use a number of properties. Properties include buildings (an actual property), vehicles costumes and small items. It is important to keep a record of which properties are required at which location. There should also be a record kept of the staff types that are assigned to productions. Please Note: The data shown in the assignment is not necessarily normalised, and that it the candidate's task to organise the data in the most optimal way possible. For example, the paper records shown below will not necessarily map directly to data base tables. The candidate is expected to use these tables as a starting point for their own normalisation and optimisation of the Forest Films data. Please note also that all SQL scripts should be shown along with their results.