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]
4 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]4 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
You can clear a log file simply by redirecting nothing into it. true or false?
nekit [7.7K]
True

cat /dev/null > fileName


------------------------------------
6 0
4 years ago
What happens to the files and folders on the desktop when the computer is turn off
andriy [413]

Answer:

All of the files are stored on a hard-drive. Except for the files you just viewed before turning off the computer, which is stored in the RAM (Random Access Memory). If your computer is a desktop, and the power goes out while looking at a photo/pdf, you may corrupt/lose the image if the computer didn't have enough time to store it in the hard drive. Everything in the hard drive is 'scratched' into it like a record. If you delete a file, that part of the disk is 'smoothed' as best as it can. If you upload another file, you might corrupt/ruin the image/pdf. Think of the smoothing like recording a football game over an old VHS of Winne the Pooh. If you have any other questions, please ask by commenting on this answer!

4 0
3 years ago
When one user could perform a query to determine which recordings had a track length of four minutes or more, and another user c
Vikentia [17]

Answer:

In my opinion, the answer is increased flexibility.

Explanation:

When one user performs the query to perform analysis and distribution of recordings as they relate to other categories. This is the advantage of increased flexibility. Data is also flexible in that case because features and variables are recorded before evaluation.

6 0
3 years ago
Why it is important for everyday people to have access to credible online information?
Citrus2011 [14]

Answer:

so you know what is true

Explanation:

5 0
4 years ago
Read 2 more answers
What kind of networking is only for the use of people within the company
zaharov [31]
LAN = Local Area Network
6 0
3 years ago
Read 2 more answers
Other questions:
  • Project managers have the overall responsibility for planning, executing, and completing a project. True False
    7·2 answers
  • What does a computer do with what it receives from the interpreter?
    14·1 answer
  • What Is one reason that more personal computers have windows operating systems as opposed to Mac operating systems
    7·2 answers
  • Give two differences between EIRGP and RIP.
    14·1 answer
  • A tiny spot on an LCD monitor display screen that permanently remains black when it should be activated and displaying color is
    12·1 answer
  • Which of the following is NOT a safety practice for working near power lines?
    14·1 answer
  • 1. what is another name for CPU?
    6·1 answer
  • Why do we use if statements?
    9·1 answer
  • Difference between batabse and database management system
    5·1 answer
  • Meteoroids are small space rocks. They are usually pieces of asteroids or comets. Meteoroids orbit the sun like asteroids and co
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!