(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

Universal Containers is designing a new community using the Customer Community license type. They would like to have the users complete survey questions through the community interface and store the responses in a Custom Object that has a lookup to the account object. Any internal user who has access to the account should be able to see all survey responses. All Customer Community users should be able to see surveys filled in by other users for their company, but not surveys for other companies. What are the correct security settings to achieve this

Answers

Answer:

The correct option is B. Set all Organization-Wide Default security to be "Private" for both internal and external users and use Sharing Rules to grant the desired access.

Explanation:

Note: This question is not complete as the options are not included. The complete question with the options is therefore provided before answering the question as follows:

Universal Containers is designing a new community using the Customer Community license type. They would like to have the users complete survey questions through the community interface and store the responses in a Custom Object that has a lookup to the account object. Any internal user who has access to the account should be able to see all survey responses. All Customer Community users should be able to see surveys filled in by other users for their company, but not surveys for other companies. What are the correct security settings to achieve this?

A. Set all Organization-Wide Default security to be "Public Read/Write" for internal users and "Private" for external users.

B. Set all Organization-Wide Default security to be "Private" for both internal and external users and use Sharing Rules to grant the desired access

C. Set all Organization-Wide Default settings to be "Public Read/Write" for both internal and external users.

D. Set the custom object to be master-detail to the Account and leave the Organization-Wide Default settings as their default values.

The explanation of the answer is now provided as follows:

Organization Wide Default security refers to settings that provides most restrictive settings that may be opened up by Role Hierarchy and Role hierarchy can be opened by Sharing rules. And the visibility of records at the record level is determined by all of these factors. Private, Public Read, Read/Write, and Read/Write & Transfer are the four permissions available in Sharing Rules.

The rules that are used to offer sharing access to users in public groups, roles, or territories are referred to as sharing rules. By introducing automatic exceptions to your org-wide sharing policies, sharing rules allow certain users more access.

By implication, the correct security settings to achieve the objective stated in the question is to set all Organization-Wide Default security to be "Private" for both internal and external users and use Sharing Rules to grant the desired access.

Therefore, the correct option is B. Set all Organization-Wide Default security to be "Private" for both internal and external users and use Sharing Rules to grant the desired access.

The Visual Basic workspace contains several worksheets. What window does the user use when developing a project?
A)Toolbox
B)Solution Window
C)Properties Window
D)Form Designer Window​

Answers

A) Toolbox i think it is correct i’m not sure tho sorry if it’s incorrect

Select the correct answer.
How are cells in a spreadsheet named?

A.
based on the header of the row they are in
B.
based on the header of the column they are in
C.
based on the row and column they are in
D.
by right-clicking them and giving them a name

Answers

Answer: its C

Explanation:

Answer:

C: Based on the row and column they are in.

Explanation:

Sells have spreadsheet but only one main system of our body. thus. forum of inside to cupture the entire blood to spread and make other resources from our body.

HOPE IT HELPS!

Which avenue may utilize video streaming, audio narration, print designs and animation?

The (blank) may utilize video streaming, audio narration, print designs and animation.

Answers

Answer:

Multimedia avenue.

Explanation:

A file type is the standard used to store data such as pictures, texts, videos, and audios. All file types have unique file extension that determine which program to use to open a particular file and to access its data e.g pictures (jpeg, png), texts (txt, docx, rtf), videos (mp4, 3gp, avi), audios (mp3, acc).

Sometimes, computer users make the mistake of opening files with the wrong software application or program, this often leads to an error due to the incompatibility of the software application with the particular file.

Basically, all software applications are designed and developed for use with specific file extensions or formats and as such, when used to open a file it isn't developed for, it result in an error.

A multimedia avenue refers to a channel that is designed and developed to accept, utilize and combine various file formats such as audio, video, text, animation effects, etc. A common example of a multimedia avenue is Microsoft PowerPoint software.

Hence, the multimedia avenue may utilize video streaming, audio narration, print designs and animation.

What would be the purpose of grouping worksheets in a workbook?
All formatting would be done on all sheets at once.
All header rows would be shared on all sheets at once.
All data entered would be entered on all sheets at once.
All formulas entered would be entered on all sheets at once.

Answers

Answer: A

Explanation:

What will be the results from running the following code?
print("Grades")
print(92)
print(80)
print("Total")
print(92 + 80)

Answers

Answer:

Grades

92

80

Total

172

Explanation:

Python is a very simple language, and has a very straightforward syntax. It encourages programmers to program without boilerplate (prepared) code. The simplest directive in Python is the "print" directive - it simply prints out a line (and also includes a newline, unlike in C).

Answer:

Grades

92

80

Total

172

Explanation:

Using Internet resources, find at least five organizations that offer Software as a Service (SaaS). How do their services benefit their users?

Answers

Answer:

1. Antenna Software

2. Cloud9 Analytics

3. CVM Solutions

4. Exoprise Systems

5. GageIn

Explanation:

1. Antenna Software - It has five gateways to routes and manages all transactions between the mobile applications and backend systems

2. Cloud9 Analytics - manages the warehouse separately from the solutions

3. CVM Solutions - Enables  users to "clean" supplier information and  to centralize and standardize information

4. Exoprise Systems - It avoid use of complex database and Web servers

5. GageIn - It uses Networking and social tools to connect users and facilitate communications

Answer:

1. Antenna Software

2. Cloud9 Analytics

3. CVM Solutions

4. Exoprise Systems

5. GageIn

Explanation:

which of the following is not a storage medium?
a.microphone
b.floppy disk
c.hard disk
d.pen drive

Answers

Answer:

microphone

Explanation:

when you are using a microphone once it stop it done

A microphone is not a storage medium.

which site uses both social bookmarking as well as visual sharing features and is described as a virtual pinboard?

Answers

Answer: Redd-it

Explanation:

The site that make use of both social bookmarking and visual sharing features and is also described as a virtual pinboard is Redd-it.

Reddit refers to a discussion webiste and a web content rating where the members submit their contents like images, links, text posts and videos. These are then either voted up or voted down by the members based on their perception on the post.

The first field of an Internet Control Message Protocol (ICMP) packet specifies the message type. Which choices represent message type examples? Check all that apply.

Answers

Answer: destination unreachable

time exceeded

Explanation:

You didn't give the options to the question but based on a similar question there I got online, the answer will be destination unreachable and time exceeded.

The Internet Control Message Protocol (ICMP) refers to a protocol that is used in the communication of problems with regards to the transmission of data. Based on the information given, the choices that represent message type examples are:

• destination unreachable

• time exceeded

What can you do to help avoid or minimize accident while working at the farm?​

Answers

Answer:

safety first

Explanation:

avoid the narrow materials that cause an accident

Fill _________ skips the Saturday and Sunday dates in a date fill.
A. Weekends
B. Weekdays
C. Skip Weekends
D. Skip Saturday and Sunday

Answers

A. Weekends is the correct answer

The storage device which is not usually used as secondary storage is 1 point a) Semiconductor Memory b) Magnetic Disks c) Magnetic Drums d) Magnetic Tapes

Answers

Answer:

a) Semiconductor Memory

Explanation:

A primary storage device is a medium that holds memory for short periods of time while a computer is running

Semiconductor devices are preferred as primary memory.

ROM, PROM, EPROM, EEPROM, SRAM, DRAM are semiconductor (primary) memories.

Select the correct answer.
Dina created a database related to essential oils and their uses. For every oil, she wants to enter a unique code number. Which data type would be suitable for entering this data?

A.
Boolean
B.
autonumber
C.
BLOb
D.
memo
E.
null

Answers

Answer:

Autonumber

This is because Autonumber is the only option out of the four that accepts random unique code numbers

Feel free to mark as brainliest :D

define micro computer​

Answers

A microcomputer is a complete computer on a small scale, designed for use by one person at a time. An antiquated term, a microcomputer is now primarily called a personal computer (PC), or a device based on a single-chip microprocessor. Common microcomputers include laptops and desktops.

How will future space flights be different for NASA?

Answers

Answer:

Explanation:

NASA's future will continue to be a story of human exploration, technology, and science. NASA will continue to be a global leader in scientific discovery, fostering opportunities to turn new knowledge into things that improve life here on Earth. ... Artist's concept, NASA's gateway in lunar orbit.

Answer:

NASA's future will continue to be a story of human exploration, technology, and ... changes on the global land surface at a scale where we can separate human ... Exploring deep space and three-year missions to Mars pose new challenges: ...

Explanation:

NASA's Artemis program aims to land another man and the first woman on the moon by 2024 and eventually establish sustainable space travel by 2028. The Artemis program is NASA's stepping stone to their ultimate goal of landing on Mars.

____ feet is used when the width of the material is not a factor. (6 letters)

Answers

Answer:

footin dhhdhdn bsbsbdb

Where is shoto from

Answers

Answer:

Shoto Todoroki is from "my hero academia" my dude

Explanation:

RELIGION QUESTION

What is the meaning of prayers of adoration and thanksgiving:

Answers

Answer:

prayer is to give thanks to god for everything he has done for you, so is thanksgiving and adoration

Explanation:

When attaching a file or files in outlook 365 you select the attach command and then select the files location

Answers

Answer:

When you click the attachment button a window pops up allowing you to select the file/s you want to upload

You can also drag and drop file/s this is an alternative method

Explanation:

Microsoft Outlook is a personal information manager software system from Microsoft.

Though primarily an email client, Outlook also includes such functions as calendaring, task managing, contact managing, note-taking, journal logging, and web browsing. Wikipedia

You need to replace a broken monitor on a desktop system. You decide to replace it with a spare monitor that wasn't being used. Even though the monitor is made by a different manufacturer than the desktop computer, it still works with the computer. Which computer design concept makes this possible

Answers

Answer:

standardization

Explanation:

A problem can be defined as an issue or challenge encountered by a person, which typically requires a solution.

Generally, problems are considered to be either simple or complex depending on the individual, parameters, and factors involved.

This ultimately implies that, problems are relative in nature but always require that a solution be proffered.

In this scenario, a broken monitor on a desktop system needs to be replaced. You then decided to replace the monitor with a spare monitor that wasn't being used.

Although, the spare (replacement) monitor was manufactured by a different manufacturer than the desktop computer but it still worked with the computer. Thus, the computer design concept which makes this possible is referred to as standardization.

Standardization can be defined as a design concept which avails users the opportunity to use various components from different manufacturers interchangeably without any defect or compromise of the integrity of a system. The most important criteria to be considered is if the components meet set standards i.e specifications of the system.

brain of the computer system is called​

Answers

Answer:

The CPU (Central Processing Unit) 

python

how do I fix this error I am getting

code:

from tkinter import *
expression = ""

def press(num):
global expression
expression = expression + str(num)
equation.set(expression)

def equalpress():
try:
global expression
total = str(eval(expression))
equation.set(total)
expression = ""

except:
equation.set(" error ")
expression = ""

def clear():
global expression
expression = ""
equation.set("")


equation.set("")

if __name__ == "__main__":
gui = Tk()



gui.geometry("270x150")

equation = StringVar()

expression_field = Entry(gui, textvariable=equation)

expression_field.grid(columnspan=4, ipadx=70)


buttonl = Button(gui, text=' 1', fg='black', bg='white',command=lambda: press(1), height=l, width=7)
buttonl.grid(row=2, column=0)

button2 = Button(gui, text=' 2', fg='black', bg='white',command=lambda: press(2), height=l, width=7)
button2.grid(row=2, column=1)

button3 = Button(gui, text=' 3', fg='black', bg='white',command=lambda: press(2), height=l, width=7)
button3.grid(row=2, column=2)

button4 = Button(gui, text=' 4', fg='black', bg='white',command=lambda: press(2), height=l, width=7)
button4.grid(row=3, column=0)
button5 = Button(gui, text=' 5', fg='black', bg='white',command=lambda: press(2), height=l, width=7)
button5.grid(row=3, column=1)
button6 = Button(gui, text=' 6', fg='black', bg='white',command=lambda: press(2), height=l, width=7)
button6.grid(row=3, column=2)
button7 = Button(gui, text=' 7', fg='black', bg='white',command=lambda: press(2), height=l, width=7)
button7.grid(row=4, column=0)
button8 = Button(gui, text=' 8', fg='black', bg='white',command=lambda: press(2), height=l, width=7)
button8.grid(row=4, column=1)
button9 = Button(gui, text=' 9', fg='black', bg='white',command=lambda: press(2), height=l, width=7)
button9.grid(row=4, column=2)
button0 = Button(gui, text=' 0', fg='black', bg='white',command=lambda: press(2), height=l, width=7)
button0.grid(row=5, column=0)


Add = Button(gui, text=' +', fg='black', bg='white',command=lambda: press("+"), height=l, width=7)
Add.grid(row=2, column=3)

Sub = Button(gui, text=' -', fg='black', bg='white',command=lambda: press(2), height=l, width=7)
Sub.grid(row=3, column=3)

Div = Button(gui, text=' /', fg='black', bg='white',command=lambda: press("/"), height=l, width=7)
Div.grid(row=5, column=3)

Mul = Button(gui, text=' *', fg='black', bg='white',command=lambda: press("*"), height=l, width=7)
Mul.grid(row=4, column=3)

Equal = Button(gui, text=' =', fg='black', bg='white',command=equalpress, height=l, width=7)
Equal.grid(row=5, column=2)

Clear = Button(gui, text=' Clear', fg='black', bg='white',command=clear, height=l, width=7)
Clear.grid(row=5, column=1)

Decimal = Button(gui, text=' .', fg='black', bg='white',command=lambda: press("."), height=l, width=7)
buttonl.grid(row=6, column=0)

gui.mainloop()

Answers

Answer:

from tkinter import *

expression = ""

def press(num):

global expression

expression = expression + str(num)

equation.set(expression)

def equalpress():

try:

 global expression

 total = str(eval(expression))

 equation.set(total)

 expression = ""

except:

 equation.set(" error ")

 expression = ""

def clear():

global expression

expression = ""

equation.set("")

if __name__ == "__main__":

gui = Tk()

 

equation = StringVar(gui, "")

equation.set("")

gui.geometry("270x150")

expression_field = Entry(gui, textvariable=equation)

expression_field.grid(columnspan=4, ipadx=70)

buttonl = Button(gui, text=' 1', fg='black', bg='white',command=lambda: press(1), height=1, width=7)

buttonl.grid(row=2, column=0)

button2 = Button(gui, text=' 2', fg='black', bg='white',command=lambda: press(2), height=1, width=7)

button2.grid(row=2, column=1)

button3 = Button(gui, text=' 3', fg='black', bg='white',command=lambda: press(3), height=1, width=7)

button3.grid(row=2, column=2)

button4 = Button(gui, text=' 4', fg='black', bg='white',command=lambda: press(4), height=1, width=7)

button4.grid(row=3, column=0)

button5 = Button(gui, text=' 5', fg='black', bg='white',command=lambda: press(5), height=1, width=7)

button5.grid(row=3, column=1)

button6 = Button(gui, text=' 6', fg='black', bg='white',command=lambda: press(6), height=1, width=7)

button6.grid(row=3, column=2)

button7 = Button(gui, text=' 7', fg='black', bg='white',command=lambda: press(7), height=1, width=7)

button7.grid(row=4, column=0)

button8 = Button(gui, text=' 8', fg='black', bg='white',command=lambda: press(8), height=1, width=7)

button8.grid(row=4, column=1)

button9 = Button(gui, text=' 9', fg='black', bg='white',command=lambda: press(9), height=1, width=7)

button9.grid(row=4, column=2)

button0 = Button(gui, text=' 0', fg='black', bg='white',command=lambda: press(2), height=1, width=7)

button0.grid(row=5, column=0)

Add = Button(gui, text=' +', fg='black', bg='white',command=lambda: press("+"), height=1, width=7)

Add.grid(row=2, column=3)

Sub = Button(gui, text=' -', fg='black', bg='white',command=lambda: press("-"), height=1, width=7)

Sub.grid(row=3, column=3)

Div = Button(gui, text=' /', fg='black', bg='white',command=lambda: press("/"), height=1, width=7)

Div.grid(row=5, column=3)

Mul = Button(gui, text=' *', fg='black', bg='white',command=lambda: press("*"), height=1, width=7)

Mul.grid(row=4, column=3)

Equal = Button(gui, text=' =', fg='black', bg='white',command=equalpress, height=1, width=7)

Equal.grid(row=5, column=2)

Clear = Button(gui, text=' Clear', fg='black', bg='white',command=clear, height=1, width=7)

Clear.grid(row=5, column=1)

Decimal = Button(gui, text=' .', fg='black', bg='white',command=lambda: press("."), height=1, width=7)

Decimal.grid(row=6, column=0)

gui.mainloop()

Explanation:

I fixed several other typos. Your calculator works like a charm!

Match each code snippet to its appropriate markup language name

Answers

Answer:

Please find the complete solution in the attached file.

Explanation:

Write a Scientific report modeling a written reasearch paper on big data applications.​

Answers

Big data applications is known to be the methods and ways that are often used to handle large amount of data.

What is  Scientific data modeling in big data?

Data modeling is known to be the ways of analyzing the “areas” of interest to one's organization and how these things is linked to each other.

Note that The data modeling helps us to know and also helps in documentation of the data resources needed for one's business.

Big data are often measured by terabytes and lots more and as such managing them is one that is  time-consuming,.

Learn more about Big data  from

https://brainly.com/question/19049345

#SPJ1

Pixar is a company that creates a huge amount of images, audio recordings, and videos, and they need to decide what compression algorithms to use on all those files. When would Pixar most likely use lossless compression

Answers

feels like im getting outta touch, maybe im juust staying inside too much, lately its getting harder to pretend i can do this alone without my friends

Which elements most affect the voice of an academic paper? Check all that apply.

Answers

where are the options

Answer:

C

Explanation:

On the Print screen, which portion shows you a sample of how the publication will look when printed?

Printer

Settings

Number of Copies

Print Preview

Answers

Answer:

D. Print Preview

Explanation:

print preview allows you to view the layout of your paper before you print it hence the pre part of preview

Print preview allows you to view the layout of your paper before you print it hence the pre part of preview.

What is Print preview?

A feature called print preview shows what a printed copy would look like on the screen. By checking the layout using print preview before printing, you can detect any potential problems and prevent the need for multiple prints, saving ink or toner and paper.

You can examine a page in landscape mode by switching the page orientation in the print preview from portrait to landscape. Sadly, not all software supports this function.

You are unable to see how your page will print in landscape format if the program you are using lacks any settings or print preview features.

Therefore, Print preview allows you to view the layout of your paper before you print it hence the pre part of preview.

To learn more about Print preview, refer to the link:

https://brainly.com/question/17441291

#SPJ2

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

compare shopping centre and open -air market​

Answers

Answer:

The similarities between a shopping center and an open-air market are;

1. Goods are bought and sold in both a shopping center and an open-air market

2. The stores within the location have different owners

3. Buyers can move between stores for transactions

The differences between a shopping center and an open-air market are;

1) The shopping center is usually roofed, while an open-air market is usually located outdoors

2) The stores in a shopping center more often have a checkout point, while stores in an open-air market rarely make use of a checkout

3) Items found with a defect after purchase can usually be returned for a replacement in a shopping center, while it is necessary to check an item well when buying from an open-air market as returning such items is usually difficult

Explanation:

A shopping center is a complex or area that have several shop groups built together which can all be located under a roof

Professional offices, restaurants, banks, theaters, and pharmacy's  can also be located in a shopping center

Open-air market is a place in the public used for the sale of food and merchandise

Other Questions
you can tell that grandads house is a) brand newb) very cluttered c) close to the grocery store d) located in a big city angle DAC= angle BADwhat is the length of side bd round to one decimal place Correctly match the requirements for being in government.Question 4 options:At least 35 years oldMust be a native born citizenLived in the U.S. for at least 14 yearsAt least 30 years oldLive in the state you representBeen a U.S. Citizen for at least 9 yearsno set of requirements listed in the Constitution.At least 25 years oldLive in the state you representBeen a U.S. Citizen for at least 7 years1. Legislative Branch - House2. Legislative Branch - Senate3. Executive - President4. Judicial - Federal Judge 6. Which statement describes evolution? which number represents 4%400400.40.04 Please help me answer the question which of the following is an example of a positive incentive from the 1700s? A. cotton required a lot of work to cleanB. Many textile mills wanted to buy cotton to create clothesC. the amount of land for farmers in the south was scaredD. i didnt have enophe tikme pls help Cul es el tiempo mximo que puede estar en un curso de orientacin?A) 1 HoraB) 3 HorasC) 6 Horas . Which side has the ability to mass produce ironclads? A) USA B) CSA -8 * 2/3 answer as a fraction You start with 0.1 L of a 5.00 M solution, and you plan to dilute it to make asolution with a concentration of 0.625 M. How much water did you add tothe container?a) 800MLb) 100mlc)700mld)750ml Whom do we honor on Memorial Day? Also, list 3 new facts you learned about this holiday from Flocabulary. What are examples of Symbolic Speech? Find the value of x and y. solving equations x-1=19 particles that are found in the sun's plasma Question # 18DropdownA(n) is the tool that will help you the most when developing the content you will use in your presentation. Cmo se mide el grado de una ecuacin algebraica? J'ai besoin de quelqu'un qui parler parce que je suis si seul What would be used by a business to assess how the business is working within its organization goals? O A. Information systems B. Interactivity C. Management plan D. Business analysis