Question: T-Mobile Wi-Fi * 49% 10:33 instructure-uploads.s3.amazonaws.com Background: You will place all your answers within the remainder of this document. It is to your advantage to

 T-Mobile Wi-Fi * 49% 10:33 instructure-uploads.s3.amazonaws.com Background: You will place all
your answers within the remainder of this document. It is to your

T-Mobile Wi-Fi * 49% 10:33 instructure-uploads.s3.amazonaws.com Background: You will place all your answers within the remainder of this document. It is to your advantage to copy your SQL commands and paste them into this document. Simply capturing your commands as an image will not allow you to run them over again if it becomes necessary. SQL Results, however, should be captured as an image using, for example, the Snipping Tool. As you prepare to respond to the final questions from the Amy Miles, the CEO of Regal Theaters, review the MOVIE ERD (Entity Relationship Diagram) that you generated in fulfillment of Assessment 1. The MOVIE ERD is shown below Movie Database Entity Diagram (ERD) DATE Task 1.(15 pts) Regal Theaters also wants to be able to search for a movie title without worrying about case sensitivity. For example the query "SELECT FROM MOVIE WHERE TITLE JAWS" returns "no data found" since the title of the movie is stored in the database as 'Jaws', not JAWS Use the UPPER function (reference section "Character Functions" in your eBook, page 229) in order to demonstrate your solution to not worring about case sensitivity in the WHERE clause. Although Figure 8-1 is a good example of using the UPPER function in the SELECT clause, you will need to use the UPPER function in the WHERE clause. Your specific task is to list all the attributes of the Jaws movie assuring that it is not case sensitive. Your SCL command will be of the for SELECT FROM MOVIE WHERE 22222(222221JAKS Note that your results for MOVIE ID and DIRECTOR ID could be difierent

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!