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