e. Create a form for the records and name it frmMoviesf. Query the table to look out for movies released in the year 2014 and name it as qryMovies NB: The rest are already solved. Just solve for these two 4) a. Load a database applicationb. Create a database labelled as MOVIE_LIBRARY in the created folder with thefollowing fields:MovieID, Movie Name, Date Released, Movie Category, Quantity Delivered.MovieIDMovie NameDate ReleasedMovieQuantityCategoryDeliveredMV01Transformer 304/02/2021Action52MV02Girl Next Door15/06/2020Horror100MV03Blended12/05/2014Comedy250MV04Fast and Furious 716/10/2018Action300MV05Noah07/08/2021Adventure85MV06Gifted Hands30/09/2015Drama300MV07TheLegendof 15/03/2018Action150HerculesMV08Son of Batman14/12/2019Adventure50MV09RoboCop17/02/2017Action100MV10Frankenstein08/01/2018Horror120c. Save the table as tblMovies.d. Fill tbIMovies with the given data as shown in 2 (b).e. Create a form for the records and name it frmMoviesf. Query the table to look out for movies released in the year2014 and name it as qryMovies

Answered: e. Create a form for the records and…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

e. Create a form for the records and name it frmMovies

f. Query the table to look out for movies released in the year
2014 and name it as qryMovies

NB: The rest are already solved. Just solve for these two

4) a. Load a database application
b. Create a database labelled as MOVIE_LIBRARY in the created folder with the
following fields:
MovieID, Movie Name, Date Released, Movie Category, Quantity Delivered.
MovieID
Movie Name
Date Released
Movie
Quantity
Category
Delivered
MV01
Transformer 3
04/02/2021
Action
52
MV02
Girl Next Door
15/06/2020
Horror
100
MV03
Blended
12/05/2014
Comedy
250
MV04
Fast and Furious 7
16/10/2018
Action
300
MV05
Noah
07/08/2021
Adventure
85
MV06
Gifted Hands
30/09/2015
Drama
300
MV07
The
Legend
of 15/03/2018
Action
150
Hercules
MV08
Son of Batman
14/12/2019
Adventure
50
MV09
RoboCop
17/02/2017
Action
100
MV10
Frankenstein
08/01/2018
Horror
120
c. Save the table as tblMovies.
d. Fill tbIMovies with the given data as shown in 2 (b).
e. Create a form for the records and name it frmMovies
f. Query the table to look out for movies released in the year
2014 and name it as qryMovies

Expert Solution

Step 1

From the following table, write a SQL query to find the name and year of the movies. Return movie title, movie release year.

Sample table: movi

 mov_id |                     mov_title                      | mov_year | mov_time |    mov_lang     | mov_dt_rel | mov_rel_country
--------+----------------------------------------------------+----------+----------+-----------------+------------+-----------------
    901 | Vertigo                                            |     1958 |      128 | English         | 1958-08-24 | UK
    902 | The Innocents                                      |     1961 |      100 | English         | 1962-02-19 | SW
    903 | Lawrence of Arabia                                 |     1962 |      216 | English         | 1962-12-11 | UK
    904 | The Deer Hunter                                    |     1978 |      183 | English         | 1979-03-08 | UK
    905 | Amadeus                                            |     1984 |      160 | English         | 1985-01-07 | UK
    906 | Blade Runner                                       |     1982 |      117 | English         | 1982-09-09 | UK
    907 | Eyes Wide Shut                                     |     1999 |      159 | English         |            | UK
    908 | The Usual Suspects                                 |     1995 |      106 | English         | 1995-08-25 | UK
    909 | Chinatown                                          |     1974 |      130 | English         | 1974-08-09 | UK
    910 | Boogie Nights                                      |     1997 |      155 | English         | 1998-02-16 | UK
    911 | Annie Hall                                         |     1977 |       93 | English         | 1977-04-20 | USA
    912 | Princess Mononoke                                  |     1997 |      134 | Japanese        | 2001-10-19 | UK
    913 | The Shawshank Redemption                           |     1994 |      142 | English         | 1995-02-17 | UK
    914 | American Beauty                                    |     1999 |      122 | English         |            | UK
    915 | Titanic                                            |     1997 |      194 | English         | 1998-01-23 | UK
    916 | Good Will Hunting                                  |     1997 |      126 | English         | 1998-06-03 | UK
    917 | Deliverance                                        |     1972 |      109 | English         | 1982-10-05 | UK
    918 | Trainspotting                                      |     1996 |       94 | English         | 1996-02-23 | UK
    919 | The Prestige                                       |     2006 |      130 | English         | 2006-11-10 | UK
    920 | Donnie Darko                                       |     2001 |      113 | English         |            | UK
    921 | Slumdog Millionaire                                |     2008 |      120 | English         | 2009-01-09 | UK
    922 | Aliens                                             |     1986 |      137 | English         | 1986-08-29 | UK
    923 | Beyond the Sea                                     |     2004 |      118 | English         | 2004-11-26 | UK
    924 | Avatar                                             |     2009 |      162 | English         | 2009-12-17 | UK
    926 | Seven Samurai                                      |     1954 |      207 | Japanese        | 1954-04-26 | JP
    927 | Spirited Away                                      |     2001 |      125 | Japanese        | 2003-09-12 | UK

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

e. Create a form for the records and name it frmMovies f. Query the table to look out for movies released in the year 2014 and name it as qryMovies NB: The rest are already solved. Just solve for these two