1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
nydimaria [60]
3 years ago
15

Q3** Write a query to create a new price list for books written by the same author. Allow the user to enter only the first 4 let

ters of the last name and the first letter of the first name, they should be able to get the right author. Ask the user to input a percentage and calculate the new discounted price based on the current retail price minus this percentage. Round the result to cents (two decimals). For your example query, assume the user wants to discount the price of James Patterson books by 20%.
Computers and Technology
1 answer:
Harrizon [31]3 years ago
5 0

Answer:

We will SQL(Structured Query Language) designed for this specific problem to manage the data base  for the library management system.This querry SQL based system will ask the user  to tell the first name and this SQL based system will his full name.

You might be interested in
In cell E13, create a formula using the AVERAGE function
lukranit [14]
USE SOCRACTIC IT WOULD REALLY HELP WITH QUESTIONS LIKE THIS
3 0
3 years ago
Read 2 more answers
You are running an 802.11g wireless router in mixed mode. You have three 802.11g wireless NICs connected to the router. A new us
notka56 [123]

Complete Question:

You are running an 802.11g wireless router in mixed mode. You have three 802.11g wireless NICs using the router. A new user connects using an 802.11b wireless NIC. What will happen?

Group of answer choices.

A. The user with 802.11b will access the network at 11Mbps while the users with 802.11g will access the network at 54 Mbps.

B. The user with 802.11b will not be able to communicate on the network.

C. The user with 802.11b will access the network at 11 Mbps. The users with 802.11g will access the network at 54 Mbps unless they are communicating with the 802.11b device,which will be at 11 Mbps.

D. All users will access the network at 11 Mbps.

Answer:

D. All users will access the network at 11 Mbps.

Explanation:

A 802.11g is one of the wireless network standards developed by the Institute of Electrical and Electronics Engineers (IEEE) which operates on a 2.4 GHz microwave bandwidth and as a result can only transmit over a short distance. The 802.11g has a data transfer rate or throughput of 54 megabits per seconds (Mbps).

Basically, the 802.11b is a similar standard to the 802.11g wireless standard that typically allows the transmission (transfer) of data for up to 11 megabits per seconds (Mbps).

In this scenario, you are running an 802.11g wireless router in mixed mode. You have three 802.11g wireless NICs using the router. A new user connects using an 802.11b wireless NIC.

Hence, what will happen is that, all the users will access the network at 11 Mbps.

6 0
3 years ago
Deleting messages keeps them in the mailbox and on the server. How can they be removed from the server to reduce the quota?
Thepotemich [5.8K]

Answer:

Left-click each message, and move it to the Trash folder.

Right-click the Deleted Items folder, and click Empty Folder.

Click the Folder tab, and click the Empty Folder in Clean Up group.

Right-click the Deleted Items folder, and click Mark All as Read.

8 0
3 years ago
Read 2 more answers
These are used to find information on the internet. They include keywords, sidebars, hyperlinks, and search engines.
Aleks04 [339]
Search tools. 

Hope this is what you needed. 
7 0
3 years ago
Write a function that creates a new string from a given string (as a function parameter) that consists of no digits. example get
VLD [36.1K]
Chicken with a side of fries is c is the answer x-9(6)^2
5 0
2 years ago
Other questions:
  • Which of the following is true of property?
    13·1 answer
  • Who played a leading role in perfecting movable type for printing?
    15·1 answer
  • Which consol was dominant in the US market between 1993 and 1998
    8·1 answer
  • What key should you press and hold to select and open multiple files at one time? Enter Alt Control Esc
    12·2 answers
  • What is the difference between delete and backspace key?​
    12·2 answers
  • Help pls. Computer basics.
    5·2 answers
  • The valid call to the function installApplication is
    5·1 answer
  • User defined blocks of code can be created in
    13·1 answer
  • What type of app is Drake designing? Drake is designing a mobile app for an online travel blog. The app will enable browsers to
    5·1 answer
  • Poshmark is more than a shopping app; it connects people and brings them together. Poshmark is a passionate group of people that
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!