Answered step by step
Verified Expert Solution
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
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
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