Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started