3- Suppose you have the information of some of chickens farms (F1, F2) as fallow: chicken dilscount price S chicken Age chicken new Numbers of total tarms ne colur chicken pricechicen inthe farm months rate price s F1 1000 F2 2000 4 F2 1500 F1 2000 6. F1 1500 F2 3000 1- Find the chicken price depending on the chicken age and color as fallow : Chicken age > 6 months and chicken color 8 35 Chicken age 6 months and chicken color w + 255 chicken age <6 months and chicken color B→ 25 chicken age c6 months and chicken color W → 15$ 2- Find the discount rate depending on chicken color as fallow : Chicken color B> 3% ,chicken color W> -2% > Find the new chicken price for each farm, where new pricerold pricet(discount rate"old price) 4. Find the total price for each farm. 5- In cell D10 find sum of total price of chicken color W and chicken age (4.8] months

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
icon
Related questions
Question
Topic name: data structures please solve quickly
3- Suppose you have the information of some of chickens farms (F1, F2) as fallow:
chicken Age
in months
chicken discount
price S
chicken
new
Numbers of
total
farms ne
color
rate
chicken price chicken in the farm
price S
F1
1000
3.
F2
2000
4
F2
1500
F1
2000
6.
F1
1500
F2
3000
1- Find the chicken price depending on the chicken age and color as fallow :
Chicken age > 6 months and chicken color 8 → 3$
Chicken age >= 6 months and chicken color W → 2.5$
chicken age <6 months and chicken color B → 25
chicken age <6 months and chicken color W → 1.5$
2- Find the discount rate depending on chicken color as fallow :
Chicken color B> -3% ,chicken color W> -2%
3 Find the new chicken price for each farm, where new price-old price+(discount rate"old price)
4 Find the total price for each farm.
5- In cell D10 find sum of total price of chicken color W and chicken age [4.8] months
Transcribed Image Text:3- Suppose you have the information of some of chickens farms (F1, F2) as fallow: chicken Age in months chicken discount price S chicken new Numbers of total farms ne color rate chicken price chicken in the farm price S F1 1000 3. F2 2000 4 F2 1500 F1 2000 6. F1 1500 F2 3000 1- Find the chicken price depending on the chicken age and color as fallow : Chicken age > 6 months and chicken color 8 → 3$ Chicken age >= 6 months and chicken color W → 2.5$ chicken age <6 months and chicken color B → 25 chicken age <6 months and chicken color W → 1.5$ 2- Find the discount rate depending on chicken color as fallow : Chicken color B> -3% ,chicken color W> -2% 3 Find the new chicken price for each farm, where new price-old price+(discount rate"old price) 4 Find the total price for each farm. 5- In cell D10 find sum of total price of chicken color W and chicken age [4.8] months
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Structure chart
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education