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
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
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F9373af86-2896-43fc-9f25-81a3bbbc3837%2F2d00734e-59a2-475c-850f-fb30d70e3938%2Fcgix4fj_processed.jpeg&w=3840&q=75)
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
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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.Recommended textbooks for you
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
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)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
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)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education