Consider the relations, containing information on names of authors, and who is authoring which papers, respectively:

Authors(auID,name)and Authoring(articleID,authorID), the answer can be expressed in either SQL or algebra.

1 List the articles authored by John Smith

2 List the co-authors of John Smith (authors who co-authored an article with John Smith)

3 List the authors that have written no paper with John Smith

4.List the authors who have all their papers co-authored with John Smith

5.List the papers authored by only one author

6.which author co-authored at least 1 paper with every author (without aggregate functions)

7 List pairs (authorID and Name) of authors who have written at least one common paper