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 bash script to copy file from one location to another

Write a bash script called mycopy that copies a file from one location to another. An example of running the script is given below.

  Create application to read customer information from file

You have been tasked to create the application which reads customer information from file to determine in which states you have customers.

  Tic-tac-toe game

You have gathered your information on the AI for the Tic-Tac-Toe game and began to develop your own ways to improve it using C++. Now, it's time to present your findings in a final paper. Remember that your final analysis and recommendations m..

  Write program that asks user for two digit number

Write program which asks user for two digit number and then prints English word for that number. Sample run: Enter a two-digit number: 45

  Create the logic for a program that accepts input values

Create the logic for a program that accepts input values for the projected cost of a vacation and the number of month until vacation. Pass both values to a method that displays the amount you must save per month to achieve your goal.

  Implement the evaluator for the language

Implement the evaluator for the language L discussed in class. You should review the notes from that class. There is also a complete description of the language in this file.

  Demonstrate an understanding of static variables and methods

Goal: The purpose of this lab is to demonstrate an understanding of static variables and methods. Problem: You are working for Plastercard, Inc., a company that specializes in credit cards for handymen

  Write a statement that prints the message recall

Clunker Motors Inc. is recalling all vehicles from model years 1995-1998 and 2004-2006. Given a variable modelYear - Write a statement that prints the message "Recall" to standard output if the value of modelYear falls within those two ranges.

  Write an application that prints out the receipt

Write an application that prints out the receipt details for these shopping baskets...

  Design and draw a ladder diagram circuit

Design and draw a ladder diagram circuit suitable for a PLC which will fulfil the following control requirement and explain briefly the technique of multiplexed switching of analogue signals

  Define procedural or algorithmic programming what is

what is procedural or algorithmic programming? what is object-oriented programming? what is the role of code reuse in

  Explain inheritance structures of galaga

Write a 3-page paper about inheritance structures of Galaga. Recognize the parent and child classes and describe what each class has for events and data.

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