User Account

All Pages

Find the titles of the records

Assignment Help Programming Languages
Reference no: EM13930373

E. Given the database schema on the relations as follows:

LIBRARY(LNO, LNAME, LOCATION)

AUTHOR(ANO, ANAME)

BOOK(BNO, TITLE, ANO)

COPY(CNO, LNO, BNO)

PATRON(PNO, PNAME, ADDRESS)

LOAN(LOANNO, PNO, CNO)

LNO - Library Number

LNAME - Library Name

ANO - Author Number

BNO - Book Number

CNO - Copy Number

PNO - Patron Number

LOAN - Loan Number

Write the following queries in SQL:

(You are not supposed to use any aggregation functions such as: count(), sum(), etc.)

1. Find all pairs of different book titles that have copies in the same library.

(Your SQL statement should exclude pairs of the form (x, x) from the answer set and to provide one of the pairs (x, y) or (y,

x) when both qualify.)

2. Find all triplets of libraries that are collocated.

(Your SQL statement should include the library name in the form of (a, b, c), exclude the triplets of the form (x, x, x), (x, x,

y), (x, y, x), and (y, x, x) from the answer set, and just list one of the six permutations of (x, y, z) when triplets qualify.)

3. Find the titles of books with copies in all Fort Lauderdale libraries.

4. Find the titles of books with copies in all Fort Lauderdale libraries that features copies of all books written by Maier.


Attachment:- 193572SQL.doc

Reference no: EM13930373

Questions Cloud

What is empirical data and what is a peer-reviewed study : Empirical data gathered from academic, peer-reviewed studies is used to develop effective treatment plans. What is empirical data? What is a peer-reviewed study? Why are these two characteristics so important to the formulation of therapeutic meth..
Compute the required tractive force : If the coefficients of static and kinetic friction between the roll and the vertical barrier of the truck and between the roll and the incline are both 0.40, compute the required tractive force P between the tires of the truck and the horizontal s..
Describe the functional analysis conditions : Identify treatment procedures. Based on the hypothesized results from the functional analysis procedure, use the information on antecedents and consequences of the problem behavior to develop interventions.
List the kinds of factors that create the learning effect : List the kinds of factors that create the learning effect. Explain how changes in a process, once it is under way, can cause scallops in a learning curve. Name some areas in which learning curves are useful.
Find the titles of the records : Find all triplets of libraries that are collocated.
Calculate the current account and financial account balance : Calculate the current account and financial account balance. For full credit, show all steps in your answer.
Determine the maximum force : Determine the maximum force P which can be applied to the block in the direction shown before slipping begins - specify this design minimum value of x to prevent slipping of the jaw.
Explain importance of self-care for psychology professionals : A brief description of at least two of your most pressing personal and professional needs related to professional practice. Then, describe strategies you might use to address these needs.
Retrieve records from database : Which fields have interests shared by academics from the same department?

Reviews

Write a Review

Programming Languages Questions & Answers

  Write down a program that will loop continuously to get

write a program that will loop continuously to get user input of positive numbers and total them out. the loop will

  Defining method dashedline with one parameter

Write a definition of method dashedLine, with one parameter, an int .

  Create class for factory workers are paid certain amount

Create class for Factory workers are paid a certain amount for each unit they make and their total pay is the number of units produced times the pay per unit.

  Write an assembly program that computes factorial

Write an assembly program that computes f(1), f(2), f(3),..., and f(10). Note that n! is defined as follows: or . Also, note that 1! = 0! = 1.

  Write program which exploit string library functions

Write a program which exploit the string library functions to do the following: prompt the user to enter his name (of four parts), count the number of characters in his name (excluding the white spaces).

  Create the logic for a program that accepts an annual salary

Create the logic for a program that accepts an annual salary as input pass the salary to a method that calculate the highest monthly housing payment the user can afford assuming that the year's total payment is no more than 25 percent of the annua..

  Creating application to test class rectangle

Write down application to test class Rectangle.

  Your goal in this program is to write down an address book

your goal in this program is to write an address book. your program should present the user with three menu options1.

  Program to print chains of numbers within a range

Write a program to print the chains for the numbers within a range that the user specifies.

  Write program to clear the screen and locate the cursor

Write a program that clears the screen, locates the cursor near the middle of the screen, prompts the user for two integers, adds the integers.

  Ms word versus other processing program

MS word Versus other processing program

  Dishtinguish antigone and what you know of theban saga

How would you dishtinguish Antigone, and what you know of Theban saga, to Oresteia, and what you know of story of Mycenaean saga?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd