Question: Take a look at an example database schema below Publication (pubID, title, year, description, typeID, subjID, staffID) Staff (staffID, first_name, last_name, email_address) Editor (editorID, first_name,
Take a look at an example database schema below
Publication (pubID, title, year, description, typeID, subjID, staffID) Staff (staffID, first_name, last_name, email_address) Editor (editorID, first_name, last_name, email_address) Author (authorID, first_name, last_name, email_address) Type (typeID, type_name, description) Subject (subjID, subject_name, description) AuthorEditor (authorID, editorID) EditorPublication (editorID, pubID) AuthorPublication (authorID, pubID)
Make a Tuple Relational Calculus to Find the names of all editors who works in editing a publication with the title of Children Vaccination which was published in year 2019.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
