Answered step by step
Verified Expert Solution
Question
1 Approved Answer
9. List the number of papers per author (identified by author id) but count each paper in proportion to the number of authors. That is,
9. List the number of papers per author (identified by author id) but count each paper in proportion to the number of authors. That is, if a paper has n authors, split the credit equally among them (1 units of credit). Example: if researcher Ullman has 3 papers, one alone, one with somebody else, and one with two other co-authors, he gets 1, .5 and .3 units of credit respectively, for a total of 1.8 papers. (A.*) wrong syntax
10. List the journals that published more papers in 2019 than in 2018. (j_count answer wrong)
Write the following questions as queries in SQL. Use only the operators discussed in class (in particular, mo outer joins are allowed). Please use renaming consistently! The following database schema is given: RESEARCHER (rid, name, institution, city, country) PAPER(title, journal, volume, number, year) AUTHOR (resid, title) where rid is the identifier (primary key) of RESEARCHER, name is the researcher's name, institution is where the researcher works, and city and country the city and country where the institution is located; title is the paper identifier (primary key) of PAPER, journal is the journal where it was published in volume volume and number number), and year is the year it appeared. Finally, in AUTHOR resid is a foreign key for RESEARCHER and title is a foreign key for PAPER. A researcher may write several papers, and papers may be jointly written by several researchers; this means that the key of Author is (resid, title). Write the following questions as queries in SQL. Use only the operators discussed in class (in particular, mo outer joins are allowed). Please use renaming consistently! The following database schema is given: RESEARCHER (rid, name, institution, city, country) PAPER(title, journal, volume, number, year) AUTHOR (resid, title) where rid is the identifier (primary key) of RESEARCHER, name is the researcher's name, institution is where the researcher works, and city and country the city and country where the institution is located; title is the paper identifier (primary key) of PAPER, journal is the journal where it was published in volume volume and number number), and year is the year it appeared. Finally, in AUTHOR resid is a foreign key for RESEARCHER and title is a foreign key for PAPER. A researcher may write several papers, and papers may be jointly written by several researchers; this means that the key of Author is (resid, title)
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