(Solved) : 3 Given Relational Schema Provide Sql Perform Following Queries Schema Cannot Provide Answ Q32520693 . . . .

3. Given your relational schema, provide the SQL to perform thefollowing queries. If your schema cannot provide

answers to these queries, revise your ER Model and yourrelational schema to contain the appropriate

information for these queries. These queries should be providedin a plain text file named

“WorksheetTwoSimpleQueries.txt”:

a.

Find the titles of all tracks by ARTIST released before YEAR

b. Give all the movies and their date of their checkout from asingle patron (you choose how to designate

the patron)

c.

List all the albums and their unique identifiers with less than2 copies held by the library.

d. Give all the patrons who checked out a movie by ACTOR and