(a) How many copies of the book titled "The Lost Tribe" are owned by the library branch whose name is "Sharpstown"? (b) How many copies of the book titled "The Lost Tribe" are owned by each library branch? (c) Retrieve the names of all borrowers who do not have any books checked out. (d) For each book that is loaned out from the Sharpstown branch and whose DueDate is prior to "September 1, 2018", retrieve the book title, the borrower’s name, and the borrower’s address. (e) For each book authored (or coauthored) by Stephen King, retrieve the title and the number of copies owned by the library branch whose name is "Central". (f) Retrieve all book titles that are available in "Sharpstown" branch but not in "Morristown" branch. (g) Retrieve book titles that are available in all library branches in the database.

Answers

Answer 1

Answer:

a) SELECT No_of_copies

FROM ((book JOIN book_copies) JOIN library_branch)

WHERE title = 'The Lost Tribe' AND branchname = 'Sharpstown';

b) SELECT branchname, No_of_copies

FROM ((book JOIN book_copies) JOIN library_branch)

WHERE title = 'The Lost Tribe'

GROUP BY branchname;

c) SELECT Name

FROM borrowers B

WHERE cardno NOT IN ( SELECT cardno FROM book_loan)

d) SELECT title, name, B.address

FROM (((book JOIN book_loan) JOIN library_branch) JOIN borrowers B)

WHERE duedate = '09/01/2018' AND branchname = 'Sharpstown';

e) SELECT title, No_of_copies

FROM (((book JOIN book_authors) JOIN book_copies) JOIN library_branch)

WHERE authorname = 'Stephen King' AND branchname = 'Central';

g) SELECT DISTINCT title

FROM ((book JOIN book_copies) JOIN library_branch)

Explanation:

The SQL statements query's a book store database of seven relations using joins and subqueries to return results.


Related Questions

which memory can be removed from motherboard? RAM OR ROM?​

Answers

Answer:

RAM is random-access memory and it can be removed from the motherboard.

Feel free to mark as brainliest :D

This Is for game design

Imagine you are the human resource director for a small video game company that employs around 20 coders, managers, artists, etc. You’re in charge of writing the safety rules and regulations for the company. Provide at least four discrete rules you would implement

Answers

1. Don’t give out any company information to someone who doesn’t work for the company.
2. Credit sources found from others games or anything that has a copyright claim.
3. Don’t abuse your power such as exploiting the games or hacking it to help yourself or friends.
4. Treat everyone with upmost respect

What is the output of the sum of 1001011 and 100011 displayed in hexadecimal?

Answers

Answer:

[tex]1001011_2[/tex]    [tex]+[/tex]   [tex]100011_2[/tex]   [tex]=[/tex]    [tex]6E_{hex}[/tex]

Explanation:

Required

[tex]1001011_2 + 100011_2 = []_{16}[/tex]

First, carry out the addition in binary

[tex]1001011_2[/tex]    [tex]+[/tex]   [tex]100011_2[/tex]   [tex]=[/tex]    [tex]1101110_2[/tex]

The step is as follows (start adding from right to left):

[tex]1 + 1 = 10[/tex] --- Write 0 carry 1

[tex]1 + 1 + 1(carry) = 11[/tex] ---- Write 1 carry 1

[tex]0 + 0 + 1(carry) = 1[/tex] ---- Write 1

[tex]1 + 0 = 1[/tex] --- Write 1

[tex]0 + 0 = 0[/tex] ---- Write 0

[tex]0 + 0 = 0[/tex] ---- Write 0

[tex]1 + 1 = 10[/tex] --- Write 0 carry 1

No other number to add ; So, write 1 (the last carry)

So, we have:

[tex]1001011_2[/tex]    [tex]+[/tex]   [tex]100011_2[/tex]   [tex]=[/tex]    [tex]1101110_2[/tex]

Next, convert [tex]1101110_2[/tex] to base 10 using product rule

[tex]1101110_2 = 1 * 2^6 +1 * 2^5 + 0 * 2^4 + 1 * 2^3 + 1 * 2^2 + 1 * 2^1 + 0 * 2^0[/tex]

[tex]1101110_2 = 64 +32 + 0 + 8 + 4 + 2 + 0[/tex]

[tex]1101110_2 = 110_{10}[/tex]

Lastly, convert [tex]110_{10}[/tex] to hexadecimal using division and remainder rule

[tex]110/16 \to 6\ R\ 14[/tex]

[tex]6/16 \to 0\ R\ 6[/tex]

Write the remainder from bottom to top;

[tex]110_{10} = 6(14)_{hex}[/tex]

In hexadecimal

[tex]14 \to E[/tex]

So, we have:

[tex]110_{10} = 6E_{hex}[/tex]

Hence:

[tex]1001011_2[/tex]    [tex]+[/tex]   [tex]100011_2[/tex]   [tex]=[/tex]    [tex]6E_{hex}[/tex]

We can draw crescent using ?

Answers

Answer:

I think it's B

hope this helps

have a good day :)

Explanation:

How can you make a search phrase more effective?
O A. by framing it as a question
O B. by using more specific search terms
C. by using a different search engine
OD. by using all the search terms you can think of

Answers

Let's solve this together.

To make a search term more accurate, you must keep it simple and you must be able to use more specific terms. The more specific you are with what you are asking the engine about, the more friendlier it will respond.

The answer is Option B. I hope this answer helped you!

1. __ and ___ were used in first generation computers

Answers

Answer:

Explanation:

vacuum tubes  and punched cards were used in first generation computers.

I needed help with this answer thanks for your help.

In the table below, identify the data type that would be most suitable for the second field.

Name Age Gender
Mary 22 female
Joe 24 male
Kate 21 female
Frank 20 male
A.
binary
B.
Boolean
C.
autonumber
D.
text
E.
number

Answers

Answer:

e num

Explanation:

Answer:

A

Explanation:

cuales son los signos de exel

Answers

Answer

explanation

Operador de comparaciónSignificadoEjemplo< (signo menor que)Menor que=A1<B1>= (signo mayor o igual que)Mayor o igual que=A1>=B1<= (signo menor o igual que)Menor o igual que=A1<=B1<> (signo distinto de)No es igual a=A1<>B1

Answer:

¿Qué quieres decir?

Explanation:

*****HELP******
Most Favored Nation (MFN) status and national treatment are also included in the Agreement on Trade-Related Aspects of Intellectual Property Rights (TRIPS). True or False

Answers

Answer:

True

Explanation:

The Most Favored Nation (MFN) status and national treatment are provided for in article 4 of the Trade Related Aspects of Intellectual Property Rights (TRIPS) Agreement and it is stated that when a member grants favor, advantage, immunity , or privilege to citizens of a country, the country shall grant similar favor, privileges and advantages to the citizens of the other members

Therefore;

True Most Favored Nation (MFN) status and national treatment are also included in the Agreement on Trade-Related Aspects of intellectual Property Rights (TRIPS).

Identify the tips to create a well-designed digital portfolio.
Felicity consulted her professor at her university for help in creating a digital portfolio. Her professor told her about the importance of creating a well-designed digital portfolio. She finally began work on the same.

A. She accessed a computer to build a digital portfolio.
B. She created a personal website with a unique URL for her online portfolio.
C. She took out the text that described her images from her portfolio.
D. She accessed a printer with could print high resolution images.

Answers

Answer:

B. She created a person website with a unique URL for her online portfolio

Explanation:

please answer this question​

Answers

Answer:

The answer for this question is Kry+Ptography

Suppose you are developing a data visualization application DataViz which calls some functions from a statistics library class SuperStats. You recently heard about another statistics library UberStats with supposedly significantly better performance than SuperStats. Explain how you would redesign the DataViz class using the Adapter pattern so that DataViz can be configured at runtime to use either SuperStats or UberStats. Does your design use dependency inversion and/or dependency injection? Explain

Answers

Answer:

By using dependency injection, create the adapter to adapt both the DataViz and the UberStats interface as expected.

Explanation:

Adapters are used in Objected-oriented programming to run or convert the output of one class object to another. The DataViz class currently uses the SuperStats class as an adaptee to get and output statistical results.

Write a new code from the scratch is tedious, so, the UberStats class dependencies are injected in the adapter and the DataViz and UberStats class functionalities can be experimented with.

What special signal is issued periodically from an Access Point and contains the network transmission rate and service set identifier (SSID), as well as other information needed for a computer to associate with the AP

Answers

Answer:

beacon frame  

Explanation:

Beacon frame is a management frame In computer networks, known to be in IEEE 802.11 based WLANs. These frames are transmitted periodically and they contain all the  information a station will require before it can rightly transmit a frame.  

When it comes to announcing the presence of devices in a wireless computer network (WLAN), Beacon frames are used, and they can also be used in the synchronization of the devices and services

Select the correct answer from each drop-down menu.
Kawika is a math teacher. His students recently took a test. He has recorded their scores in a spreadsheet, using functions to analyze the scores. Which functions should he use to determine the top and mean scores?

Kawika can use the ____ function to find the top score and the ____ function to find the mean score.

First blank:
1. MIN
2. COUNT
3. MAX

Second blank:
1. AVERAGE
2. ROUND
3. SUM

Answers

Answer:

First blank:  MAX

Second blank:  AVERAGE

Explanation:

Required

Complete the blanks

The first blank is to be filled with a function that calculates the highest score from a given range of scores (cells).

To do this, we make use of the MAX function, and the syntax is:

=MAX(cell_range)

The second blank is to be filled with a function that calculates the mean score from a given range of scores (cells).

To do this, we make use of the AVERAGE function, and the syntax is:

=AVERAGE(cell_range)

Answer:

MAX

AVERAGE

Explanation:

I got it right on the Edmentum test.

The _______ is used to change the date Auto Fill option.
A. Fill Tag
B. Tag
C. Smart Fill
D. Smart Tag

Answers

I assume you are talking about Excel?. You first--enter your initial date on the first cell and click the cell with the first date to select it, then drag the fill handle.

brain of the computer system is called​

Answers

Answer:

central processing unit in short form CPU :)

Answer:

The Central Processing Unit(CPU)

Explanation:

The CPU is the brain of a computer, containing all the circuitry needed to process input, store data, and output results.

What is a worm?
the process of using e-mail to trick a user to share personal information
a type of virus that targets programs and files, and duplicates itself like a biological virus
O a type of software designed to secretly capture personal information and track online activities
O a type of virus that spreads from computer to computer through a network connection

Answers

Answer:

Answer is a type of virus that spread from computer to computer through a network connection

Explanation:

How can data be calculated?

Answers

Answer:

Data can be calculated by solving an equation

Explanation:

Select the three careers in the creative side of digital media.

broadcasting
web designer
animators
filmmaker
project management

Answers

Answer:

I would pick A B and D to be my answer

Answer:

web designer, animators, and filmmaker.

In which of the following phases of filmmaking would a production team be focused on the process of casting?
(Select all that apply).
pre-production

post-production

development

distribution

Answers

Explanation:

There are five phases of film production and they include development, pre-production, production, post-production and distribution.

Answer:

pre-production

Explanation:

edg2021

Once the film concept has been developed, the film company transitions to the production phases: pre-production, production, and post-production. In pre-production, the technical details are worked out, a schedule is set, and the resources to produce the film are assembled. This includes casting the film, filling the technical positions, and scheduling the production. The actual filming takes place during the production phase, followed by a post-production phase in which the footage is edited and the final film emerges.

COMP
Mention six characteristics of modern computers.
i.
ii.
iv.​

Answers

Answer:

speed

storage capacity

reliability

accuracy

diligence

multitasking

who invented the Bluetooth device​

Answers

Answer:

The Bluetooth standard was originally conceived by Dr. Jaap Haartsen at Ericsson back in 1994.

Explanation:

according to this website www.androidauthority.com/history-bluetooth-explained-846345/

Answer:

alexander - edg 2022

Explanation:

Windows 1.0 was not considered to be a "true" operating system but rather an operating environment because _____.

it crashed a lot
it could only run one application at a time
it didn't use a pointing device
it provided a shell for MS-DOS

Answers

Answer:

it providrd a shell for MS-DOS

Explanation:

It basically was a shell to make MS-DOS different. MS-DOS was still the underlying operating system.

what is the behavior of an element with static positioning in regard to the page layout?

Answers

Answer:

The element is positioned according to the normal flow of the document.

The top, right, bottom, left, and z-index properties have no effect. This is the default value.

The behavior of an element with static positioning in regard to the page layout is that it implies that one put the element in its original position in the aspect of document flow.

What does Static positioning implies?

Static positioning is known to be the normal way that all element have or gets. It implies that one should "put the element into its original place in the document flow as there is nothing special that one needs to see here."

Hence,  the behavior of an element with static positioning is known to be the same and thus If a person do save and refresh, there will be no changes except when there is an updated background color.

Learn more about page layout from

https://brainly.com/question/988590

Match each code snippet to its appropriate markup language name

Answers

Answer:

Please find the complete solution in the attached file.

Explanation:

Which tool allows users to share code and also serves as a social networking
site for programmers?
A. Dropbox
B. Scratch
C. Kezmo
O D. GitHub

Answers

Answer:

D. GitHub

Explanation:

A P E X

The tool that allows users to share code and also serves as a social networking site for programmers is GitHub. Thus, option D is correct.

What is GitHub?

A GitHub is a type of tool that has been used quickly fix an issue or bug in the main branch of a repository.

The main purpose of GitHub is to quickly fix an issue without disrupting the ongoing development work in the main branch. This has been allow for more efficient as well as streamlined workflow, as the main branch can continue to be updated while the hotfix branch has been used to address any urgent issues.

The hotfix branch has been created from the main branch and has used to make necessary changes to the code. Once the changes are made, the hotfix branch then merged back into the main branch to update the code and fix the issue.

Thus, option D is correct.

Learn more about GitHub on:

https://brainly.com/question/29316401

#SPJ7

Express 42 as a product  of its prime factor​

Answers

The only way to write 42 as the product
of primes.

Except to change the order of the factors is
2 × 3 × 7. We call 2 × 3 × 7 the prime factorization of 42.
The only way to write 42 as the product of primes (except to change the order of the factors) is 2 × 3 × 7. We call 2 × 3 × 7 the prime factorization of 42.

PLEASE HELP DUE IN 30 MINUTES NO LINKS PLEASE ​

Answers

Answer:

3

Explanation:

Answer:

Correct answer is C: Format Check

The formula =average(B1:B2) displays the value____(see the picture down)

Answers

9514 1404 393

Answer:

  (a)  10

Explanation:

The formula displays the average of the values 8 and 12. That average is ...

  (8+12)/2 = 10

Select the correct answer from each drop-down menu.
How does a function work?

A function takes values in the form of____, performs a calculation, and returns a ____.

First blank:
1. Keywords
2. Arguments
3. Math operators

Second blank:
1. Result
2. Cell reference
3. Formula

Answers

Answer:

Maths operators

cell reference

Answer:

Arguments

Result

Explanation:

I got it right on the Edmentum test.

Other Questions
A man buys a marker at Rs. 40 and sells it at Rs. 50. What is the profit percentage? If the integral of the product of x squared and e raised to the negative 4 times x power, dx equals the product of negative 1 over 64 times e raised to the negative 4 times x power and the quantity A times x squared plus B times x plus E, plus C , then the value of A B E is Why DEF and STU are similar? Please help fast answer only if you know or gonna report you Someone please help What is the history/or origin of pep band? Which of these statements characterizes an advantage and disadvantage the Confederacy had during the Civil War? (5 points) A.) A larger army, but lower quality weapons B.) More railroads, but longer supply lines C.) Better weapons, but worse generals D.) Higher exports, but fewer factories I don't like doing math help if you know :) s=10 what is the volume of the prism A student began a proof of the law of sines using triangle xyz. His work is shown. The student has ____ started the proof. The next step in the proof is to ____. Then the student should _____. the M.E = K.E + P.E. If the M.E of the football is 150 J and when it's thrown the K.E is 70 J. What is the P.E of the football? 2. Brandon has 4 1/2 cups of oats. He uses 3 1/4 cups to make oats for a camping trip. He saves the rest of the oats to feed to his bird, Coco. If Coco needs of a cup of oats each day, how many days can Brandon feed Coco with the oats he has left? Answer must be a whole number During the previous year, Leveraged Inc. paid $100 million of interest expense, and its average rate of interest for the year was 8%. The company's ROE is 18.4%, and it pays no dividends. Estimate next year's interest expense assuming that interest rates will fall by 34% and the company keeps a constant equity multiplier, Calculate next year's estimated interest expense What is the area of this triangle? hey! ill give brainliest please help What are three types of Greek/Latin word parts that can help you determine the meaning of a word?Language Arts B (6th Grade) Q6..Make t the subject of the formula w = 3t + 11 What happened to science fiction during its "golden age"--the 1940s and 1950s?Science fiction stories began to appear in pulp fiction magazines.Science fiction writers began incorporating robots and aliens as characters.Mary Shelly published the now-classic horror novel, Frankenstein.Serious writers began writing science fiction and popularized the genre. show that the subset is the partial ordering on the power set of S. B Reading Choose the best estimate for the multiplication problem below. 85 x 86 A. 8100 B. 10,400 C. 12,200