Question: author ( author , id , first _ name, last,name ) author pub ( author , id , pub _ id , author position )
authorauthor id firstname, last,name
author pubauthor id pubid author position
bookbookaid, booktitle, month, year, editor
pubpubid title, bookjid
author id in author pub is a foreign lary referencing author
pubjid in author pub is a foreign loey referencing pub
booktid in pub is a foreign loey referencing book:
editor in book is a foreign bry referencing authorawthorid
Primary brys are urslerlined
Pubs Database State
What question does the following expression answer?
author book
a The number of authors that have both authored and edited books.
b How many authors are not book editors.
c The total number of authors and editors across all books.
d Returns the names of all authors who have at least one publication in the database.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
