IST $210-$Lab $4$ Normalization

Introduction $-$ In order to complete this lab, we will be using the database created in Lab $2$ to create a new, normalized, set of tables. The following is an ER Diagram showing the content of our Book database, presently there is only one table:

The Book database's ERD

In this lab we want our database to have the normalized version of the data in our book$\_$basic table. This will help reduce data redundancy and increase data integrity. At the end of this lab, you will end up with six new tables $($seven tables overall including the original book$\_$basic table$).$ Our new tables will contain very similar data as we have seen in book$\_$basic. Your book database at the end of this lab should look like the following ER Diagram:

Ex$.9\mathrm{.}3$ More Practice with Subqueries

Purpose: To practice writing complex queries Mysol Requirements: moviesfull database zyBooks: $3\mathrm{.}6$

Required Screenshots

Every Question $\%1\mathrm{.}7$

Complete the problems, take a screenshot of every probliem, add it to a word document, and submit the document containing all screenshots.

Write a query that finds the years that have had a Japanese movie released. Show only the years.

$\backslash$table$[[,$mov$\_$year$],[+,1997],[,1954],[,2001]]$

Write a query that shows all of the movies that were released in the same year as a Japanese movie. Use the IN operator and your query from #$1$ as the subquery. $($Hint: Your query from #$1$ returns a list of valid years$)$

Ex$.9\mathrm{.}3$ More Practice with Subqueries

Purpose: To practice writing complex queries

MySQL Requirements: moviesFull database

zyBooks: $3\mathrm{.}6$

Required Screenshots

Every Question #$1-7$

Complete the problems, take a screenshot of every problem, add it to a word document, and submit the document containing all screenshots.

Write a query that finds the years that have had a Japanese movie released. Show only the years.

$\backslash$table$[[,$mov$\_$year$],[.,1997],[,1954],[,2001]]$

Write a query that shows all of the movies that were released in the same year as a Japanese movie, Use the IN operator and your query from #$1$ as the subquery. $($Hints; Your query from $11$ returns a list of valid years$)$