1) Install SQL Express Management Studio 2014 from the following link:
https://www.microsoft.com/en-us/download/details.aspx?id=42299
2) Recreate the HistoricalEvents and Movies databases using the files found in the folder “Database backup”.
3) For each exercise listed below, create a separate .sql file with the solution. Compress all .sql in a single .zip archive
Exercises
Historical Events DB
Exercise 3:
Prove that there were 15 events in total which had a relation with Russia OR Germany
Exercise 4:
Create a query to count the number of events per country which took place in the nineties
Movies DB
Exercise 5:
Create a list (Id_actor, Name_actor, Movie, NoOscars) of the top 3 movies based on the number of Oscars won.
Exercise 6:
Choose your favorite actor/actresses and list all the movies in which he/she played and sort them by net profit.
that I have chosen to write and elaborate on is the sequence when Finn is first brought into the Dinsmoor home. In this sequence you see Finn being brought on a tour throughout the extremely large home. Estella is leading Finn through the house, showing him all the nooks of the house, without leaving anything out. You can see that Finn almost looks inferior to Miss Dinsmoor and Estella. This sets up the consistent theme of money and wealth throughout the movie. It shows the first example of Estella thinking that she is worth more than Finn and his family as a whole. Throughout this sequence, themes of money and wealth are extremely prominent through cinematic elements of the position of the actors, the camera angle, the dialogue, and the color scheme.
The first cinematic element I decided to analyze in the film adaptation is the position of the actors. In this sequence of scenes, the actors are set up strategically as they walk through the house to exemplify the underlying idea that they think they are better than Finn and his family. While the two characters are walking throughout the house on the tour, the viewer can see that Estella walks ahead of Finn. The positioning of them ahead of Finn shows the unspoken idea that she is more important than him due to her wealth and socioeconomic status. The theme of wealth and socioeconomic status is set during this scene and then carried out throughout the rest of the film. It is visible that Estella walks around the home at a quick speed, not really giving Finn time to catch up. He is busy looking around at everything in the home and all the details, and Estella does not give Finn time to catch up to her. This feeling of being an inadequate, poor child portrays how Finn will feel until he makes his character development into a gentleman. These feelings of being poor and inadequate are what really motivate Finn to make his character transition. Finn also walks around and he seems confused while he is wandering through the Dinsmoor mansion. You can tell that this setting is so much different than what he is used to in his daily life. His home is basically nothing compared to Estella’s home. The position of his body as he follows hesitantly behind Estella shows his uncertainty and his feelings of inadequacy.