Assignment

Here is a schema for POP:

JOURNALS(j_num, j_name, j_subject_area, chief_editor_r_ssn[1])

chief_editor_rssn FK REF Researchers

ISSUES(j_num, i_num, i_date, i_num_pages)

j_num FK REF journals

RESEARCHERS(r_ssn, r_name, r_address, r_phone, r_institution)

ARTICLES(art_num, art_title, art_area_topic, art_abstract, j_num_submitted,date_submitted,

j_num_published, i_num_published)

j_num_submitted FK REF journals

(j_num_published,i_num) FK REF issues

AREA_EDITS(j_num, r_ssn)

j_num FK REF journals

r_ssn FK REF researchers

WRITES(r_ssn, art_num)

r_ssn FK REF researchers

art_num FK REF articles

REVIEWS(r_ssn, art_num)

r_ssn FK REF researchers

art_num FK REF articles

RESEARCH_SPECIALTIES(r_spec_name)

RRS(r_ssn, r_spec_name)

r_ssn FK REF researchers

spec_name FK REF research_specialties

Please formulate the following queries in SQL:

The names of all researchers from TU.

The names of all researchers from TU with an MIS specialty.

The names and addresses of all researchers who are chief editors.

The names of all journals with subject area = MIS.

The names and addresses of all researchers who have written or reviewed an article.

The titles of all articles published in MIS Quarterly.

The names and addresses of the area editors for Architectural Quarterly.

Note: We dont have to run these in MYSQL . We should use the standard SQL conventions that we learnt in class. Please turn in on a neatly written/printed sheet of paper. The idea is to learn how to formulate queries in our heads first, without using feedback from any particular system.

[1] The chief_editor_r_ssn is the r_ssn of the researcher who is chief editor for the journal.