Question: Consider the following relational * 15 points database schema and answer the questions below: BOOK(ISBN, TITLE, PNAME, YEAR) AUTHER(ANO, NAME, Email) PUBLISHER(PNAME,ADDRESS) WROTE(ISBNANO) a) (5points)

 Consider the following relational * 15 points database schema and answer

Consider the following relational * 15 points database schema and answer the questions below: BOOK(ISBN, TITLE, PNAME, YEAR) AUTHER(ANO, NAME, Email) PUBLISHER(PNAME,ADDRESS) WROTE(ISBNANO) a) (5points) Write SQL DDL statements to create BOOK and WROTE relations. Use appropriate data types for the attributes. Make sure to create primary and foreign keys. b) Write the following queries/statements in SQL. 1. (2 points) Retrieve the name of the author who wrote the book whose ISBN=123456. 2. (2 points) List the names of publishers who has published more than 100 books. 3. (2 points) Find names of authors that start with "A". 4. ( 2 points) List books arranged in descending order of year. 5. (2 points) Write a statement to add yourself to AUTHOR table

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!