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
Processing is handled by the computer’s central processing unit (cpu).​ <br> a. True <br> b. False
zhuklara [117]
It is true, the cpu handles the processing
7 0
4 years ago
Define the terms candidate key and primary key. Explain the difference between a primary key and a candidate key.
Shkiper50 [21]

Explanation:

Both Primary Key and Candidate Key are the attributes that are used to access tuples from a table. These (Primary key and Candidate key) are also can be used to create a relationship between two tables.

  • A Candidate Key can be any column or a combination of columns that can qualify as a unique key in the database. Each Candidate Key can qualify as a Primary Key.
  • A Primary Key is a column or a combination of columns that uniquely identify a record. The primary key is a minimal super key, so there is one and only one primary key in any relationship.

<em> The main difference between them is that a primary key is unique but there can be many candidate keys. </em>

I hope you find this information useful and interesting! Good luck!

5 0
4 years ago
In 3-4 sentences, write a note to a friend describ
sladkih [1.3K]

you can copy and paste your text.

7 0
3 years ago
Read 2 more answers
Which option best describes a trustworthy person?
jasenka [17]
<span>A person who babysits your kids or who you tell your secrets to.



A example since you dont have choices</span>
5 0
4 years ago
Read 2 more answers
3-5 paragraphs on how and why robotics are used in nuclear fields
Dmitriy789 [7]
Robots can be used in fabrics where they now use them to help do the work faster and do somethings that humans cant do.
3 0
4 years ago
Read 2 more answers
Other questions:
  • Match terms in the first column with the order descriptions in column two.
    11·1 answer
  • Which passage form the passage best contributes to elisa impatient tone
    8·1 answer
  • Which phase takes all the detailed design documents from the design phase and transforms them into the actual system? Testing ph
    7·1 answer
  • Somebody who is good at this stuff, please halp meh ;-;
    6·1 answer
  • To move one screen to the left press ____.
    9·1 answer
  • In a period of steep increases in interest rates, which issuer is most likely to be negatively affected? A Trucking company B Ut
    9·2 answers
  • Using this tool to help you to visualize your slides and develop your content
    13·1 answer
  • True of False - use T or F The Math class can be instantiated.
    15·1 answer
  • What network security tool, usually included with Kali Linux, allows a user to ping multiple IP addresses
    8·1 answer
  • What (if any) are the same feature requirements that might be found in server software/OS environments
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!