ITEM 8
Use of Management Tools
SESSIONS
Some part of this topic will be worked on individually, which does not mean that you cannot ask your classmates for help (besides the teacher).
S0-I
We will create a database calledFILMAX-our namewith the following tables:
* ACTORS:
Name (text 15)
Surname (text 25)
DNI (text 9 y primary key)
Date of Birth (Long Date)
High Date (Short Date)
Work abroad (Yes/No)
Sinister (Yes/No)
Additional Language (text 15)
* FILMS:
Movie code (text 4 y primary key)
Movie name (text 30)
Budget (currency)
All Public (Yes/No)
Release date (median date)
* WORKS:
Job number (Autonumber y primary key))
Movie (text 4)
Actor-actress (text 9)
Salary (currency)
Duration in days (numeric)
We make the following relations:
-
DNI (from the ACTORS table) with Actor-actress (from the JOBS table)
-
Film code (from the FILMS table) with Film (from the JOBS table)
We fill in the tables in the following order:
ACTORS (6 records) - FILMS (6 records) - WORKS (10 records)
- The budgets of the films must be between €200,000 and €2,000,000.
- The employee registration date must be between 2002 and 2017, and there must be two or three registrations in 2012.
- La date ofbirth of employees must be between 1970 and 2001.
- The duration of the employees' work must be between 10 months and 24 months.
- La fecha de estreno de las películas debe ser entre 2010 y 2018, debiendo haber tres o cuatro entre los years 2015 and 2016.
S1-I
Create the following queries on the database created earlier in class.
-
Query 1.- That shows the name of the films with a budget of less than €500,000.
-
Query 2.- Whate show the name of films for all audiences with a budget of less than €500,000.
-
Query 3.-whate show the name of the films with a budget between €500,000 and €1,000,000.
-
Query 4.-whate show the first and last name of employees who were hired before 2012. (sorted by ascending last name).
-
Query 5.-whate show the name and surname of the employees who were hired in 2012. (ordered by ascending DNI).
-
Query 6.-whate show the first and last name of the employees who were hired in the second quarter of 2013 and who have worked abroad. (sorted by last name descending).
-
Query 7.-whate show the first and last name of the employees who have had an accident.(ordered by ascending ID).
-
Query 8.-whate show the first and last name of employees who have worked on films not suitable for all audiences.
-
Query 9.-whate show the first and last name of employees who have worked on films not suitable for all audiences and with a budget less than €500,000.
-
Query 10.-whate show the first and last name of employees who have worked on films for a duration of more than one year.
-
Query 11.-whate show the first and last name of the employees and the name of the movies that were released in 2018.
-
Query 12.-whate show the first and last name of the employees and the name ofthe movies which were released between 2015 and 2016 (both included). (should be sorted by movie name ascending).
-
Query 13.-whatand show the name ofthe movies in the that someone works who was born before the year 1990.
-
Query 14.-whate show employees first and last name and first name the movies in which employees who earned between 10,000 and 20,000 euros worked..
-
Query 15.-whate display the first and last name of employees who speak any additional_language (sorted by language ascending).
-
Query 16.-whate show the name of the movie where someone has worked employee who speaks an additional language.
--------------------------------------------------- ------- A little more complicated -------------------------------- ----
-
Query 17 .- Showing the employees who speak a certain language.
-
Query 18.-whatand show the name ofthe movies which were released in a certain period.
-
Query 19.-whatand show the name ofl las películas en las que trabajaron empleados que hablaran un determinando idioma y que hubieran_cc781905-5cde-3194- bb3b-136bad5cf58d_born before a date.
-
Query 20.-whate muestre el nombre y apellido de los empleados que se dieron de alta en un determinando año y que trabajaron en películas_cc781905-5cde-3194-bb3b -136bad5cf58d_de un determinate budget..
S1-S8-G
After viewing thenext video, each group should create (using PREZI) a presentation of your film, which will include at least the following contents:
-
Movie title.
-
Synopsis
-
Cast
-
Actress 1
-
Biography
-
filmography
-
Awards/Awards
-
......
-
-
actor 1
-
Biography
-
filmography
-
Awards/Awards
-
......
-
-
.........
-
-
Photo gallery
-
Awards
-
Criticism
-
Media Communication 1
-
Review
-
-
Media Communication 2
-
Review
-
-
...........
-
In classroom you will have the deadlines and the rubric of the task.
