Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Authors authorlD (in firstName (varchar(32)) lastName (varchar(32)) email (varchar(32)) PapersByAuthor aperID (int Citations paperD (int) citationID (int) Papers paperID (int) title (varchar(100)) year (int) venuelD

image text in transcribed

image text in transcribed

Authors authorlD (in firstName (varchar(32)) lastName (varchar(32)) email (varchar(32)) PapersByAuthor aperID (int Citations paperD (int) citationID (int) Papers paperID (int) title (varchar(100)) year (int) venuelD (int) Venues venueID (int) name (varchar(100)) acronym (varchar(16)) type (char(10)) Figure 1. Schema for the computer science bibliography database 1. (10 points) Write two significantly different SQL queries that list the titles of papers that have never been cited. (The queries must be significantly different, in the sense that one must use some SQL construct that the other does not.) 2. (10 points) Write two significantly different queries that list the names of authors who have never published a paper in a journal. (The queries must be significantly different, in the sense that one must use some SQL construct that the other does not.) 3. (10 points) Write an SQL query that lists the names of authors who have only journal publications 4. (10 points) Consider the following queries which claim to list all authors who have published at least a paper in 2012 and at least a paper in 2013. For each querv, say if it is correct or not. If you think the query is incorrect, then justify your answer in 2-3 sentences. (a) SELECT distinct A.firstname FROM Authors A NATURAL JOIN PapersByAuthor PA NATURAL JOIN Papers P1 NATURAL JOIN PapersByAuthor PA2 NATURAL JOIN Papers P2 WHERE PI . year=2012 AND P2.year=2013 AND P1.pape r IDP2.paper1D

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Sams Teach Yourself Beginning Databases In 24 Hours

Authors: Ryan Stephens, Ron Plew

1st Edition

067232492X, 978-0672324925

More Books

Students also viewed these Databases questions

Question

Why are bond maturity dates important?

Answered: 1 week ago

Question

How does a leader's leadership style influence the workgroup

Answered: 1 week ago

Question

8. Explain the contact hypothesis.

Answered: 1 week ago

Question

2. Define the grand narrative.

Answered: 1 week ago