Consider the relations, containing information on names of authors, and who is authoring which papers, respectively: Aut
Posted: Fri Jul 01, 2022 5:46 am
Consider the relations, containing information on names ofauthors, and who is authoring which papers, respectively:
Authors(auID,name)and Authoring(articleID,authorID)
1 List the articles authored by John Smith
2 List the co-authors of John Smith (authors who co-authored anarticle with John Smith)
3 List the authors that have written no paper with JohnSmith
4. List the authors who have all their papers co-authored withJohn 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 atleast one common paper
Need work asap and explanation. Thanks
Authors(auID,name)and Authoring(articleID,authorID)
1 List the articles authored by John Smith
2 List the co-authors of John Smith (authors who co-authored anarticle with John Smith)
3 List the authors that have written no paper with JohnSmith
4. List the authors who have all their papers co-authored withJohn 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 atleast one common paper
Need work asap and explanation. Thanks