That's database system! thanks for help

COMS 322-Database Systems - Spring 2020 Homework #2-DUE Friday, January 31 Name: For all the questions on this assignment you can either write your answers in the space provided or put them in a Word or other text document and upload them to the assignment page on MyBLC. 1. Using the Biblio database, write a SQL query that returns the Au ID and Author name of the authors whose first name is Jennifer. Sort the results by the authors' names. Your result should look like this: Au ID Author 15188 Digiovana, Jennifer Holt 13723 Flynn, Jennifer 2223 Hamilton, Jennifer 10037 Meyer, Jennifer 3131 Trant, Jennifer 3884 Widom, Jennifer Write your SQL here or upload it to the assignment on MyBLC. 2. Using the Biblio database, write a SQL query that returns the Name and Publp from the Publisher table where the publisher is located in Minnesota Your result should look like this: PubID 27 54 Nane South-Western Educational West West PUB GROUP WEST WESTVIEW SOUTH-WESTERN South-Western Educational PUB GROUP WEST WEST VIRGINIA UNIV EAST-WEST CENTER GOLDEN WEST PRODUCTS 155 191 316 485 484 Write your SQL on the following page or upload it to the assignment on MyBLC. Page 1 of 3 COMS 322 - Database Systems - Spring 2020 Homework N2-DUE Friday, January 31 Write the SQL for question #2 here or upload it to the assignment on MyBLC. 3. Using the Biblio database, write a SQL query that returns the TOP 5 publisher Name, ISBN, and Title from the Publisher table INNER JOIN the Title table where the publisher is located in Minnesota. Sort the results by ISBN Your result should look like this: Name ISBN West -3140981-6- West 6-3140100-3-3 West -3140104-0-8 Title C for Engineers and Scientists : An Introduction to Programming With ANSIC PC Assembly Language : An Introduction to Computer Systems Introduction to Programming in Assembly Language (IBM PC A First Book of ANSI C : Fundamentals of C Programming/Book and Disk Understanding and using Paradox 3.5 (The Microcomputing Series West 0-3140108-6-6 West 0-3140122-4-9 Write your SQL here or upload it to the assignment on MyBLC. 4. Using a LEFT JOIN between the Author and Title Author tables, find the list of Authors who do not have matching records in the Title Author table. The sort order does not matter. Your result should look like this: Author Bruey, Alfred J. Bontempo, Charles J. St. Valentine, Chris Besser, Howard Lipscomb, Carolyn E. Rosin, R. David Arregui, Maurice E. Write your SQL here or upload it to the assignment on MyBLC. Author Title Author AUD ISBN 5. Does the fact that there can be records in the Author table which don't have matching records in the Title Author table cause any data integrity issues within the database? Explain your answer. Author Year Bom AULID