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 Relational Algebra to find the authors name who wrote all Journal type publication in specific subject about Energy & Power.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!