we want to find if we need to buy additional stock for each item in our inventory item list according to the following conditions: - if item stock for november and december was less than 100 , OR stock for septemper and october less than 200 then we will buy stock double the stock of december. -else, we will buy stock half december stock. example: the stock of pens for november and december is 95 which is less than 100 then we will buy double the stock of december which is (84 2)=168

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
100%

IF Function Lab submission

we want to find if we need to buy additional stock for each item in our inventory item list
according to the following conditions:
- if item stock for november and december was less than 100 , OR stock for septemper
and october less than 200 then we will buy stock double the stock of december.
-else, we will buy stock half december stock.
example: the stock of pens for november and december is 95 which is less than 100 then
we will buy double the stock of december which is (84*2)=168
item
Sep
Oct
Nov
Dec
new stock
pen
74
85
11
84
раper
65
67
40
55
eraser
55
42
49
89
notebook
14
19
15
99
ruler
68
55
58
52
sticky not
binder clij
70
76
89
14
15
88
9
staples
50
150
25
34
Transcribed Image Text:we want to find if we need to buy additional stock for each item in our inventory item list according to the following conditions: - if item stock for november and december was less than 100 , OR stock for septemper and october less than 200 then we will buy stock double the stock of december. -else, we will buy stock half december stock. example: the stock of pens for november and december is 95 which is less than 100 then we will buy double the stock of december which is (84*2)=168 item Sep Oct Nov Dec new stock pen 74 85 11 84 раper 65 67 40 55 eraser 55 42 49 89 notebook 14 19 15 99 ruler 68 55 58 52 sticky not binder clij 70 76 89 14 15 88 9 staples 50 150 25 34
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Single source shortest path
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
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