None 2- Suppose the fallowing information about some product in a cloths markets , wherethere are two discount offer (sil ja), that depend on prod type, write a suitableformula find the new price, note : new price old price +(discount rate 8 old price)AC1dis1=-15%dis2=-20%23 prod_type price $2$$ 23.002$new price4134.0026.156.002$67.0056.007?8.124?9.1- Find the new price where the discount value depending on prod_type as fallow:Prod_type= 1→ dis1prod_type=2 dis22- find the sum of all new price3- find the number of prod_type 1 and newprice >=30 $4- Find the average of price for prod_type 25- find the second largest new price

GIven : discount 1=-15% discount2 =-20% product type 1 and product type 2

2- Suppose the fallowing information about some product in a cloths markets, where there are two discount offer (sill ja), that depend on prod type, write a suitable formula find the new price, note : new price old price +(discount rate 8 old price) A D 1 dis1= -15% dis2= -20% 2 3 prod_type price $ 4 new price 1 $34.00 $23.00

2- Suppose the fallowing information about some product in a cloths markets, where there are two discount offer (sill ja), that depend on prod type, write a suitable formula find the new price, note : new price old price +(discount rate 8 old price) A D 1 dis1= -15% dis2= -20% 2 3 prod_type price $ 4 new price 1 $34.00 $23.00

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

What year did John von Neumann obtain his PhD degree?
Compare and contrast the experiences of persons who use technology in the twenty-first century with those who lived in the twentieth.
How many books John von Neumann wrote over the course of his life.
Whose father is Thomas Watson Jr. named after?
In terms of modern computer use, how much do you know about it?
The number of books that John von Neumann wrote throughout his lifetime.
Why chess titles are important?