Answer:
View Base tables: Virtual table based on a SELECT query
CREATE VIEW statement: Data definition command that stores the query specification in the data dictionary
DROP VIEW statement: Data definition command that removes the query specification in the data dictionary
Explanation:
Views are virtual tables, which can be created by select queries using the real database tables.
Creating and dropping views can be done by the CREATE VIEW and DROP VIEW statements.
<u>CREATE VIEW syntax:</u>
CREATE VIEW view_name AS
SELECT column1, column2, ...
FROM table_name
WHERE condition;
<u>DROP VIEW syntax:</u>
DROP VIEW view_name;
Answer:
item = "quesadilla"
meat = "steak"
queso = False
guacamole = False
double_meat = False
base_price = 4.5
if item == "quesadilla":
base_price = 4.0
elif item == "burrito":
base_price = 5.0
if meat == "steak" or meat == "pork":
base_price += 0.50
if meat == "steak" and double_meat:
base_price += 1.50
elif meat == "pork" and double_meat:
base_price += 1.50
elif double_meat:
base_price += 1.0
if guacamole:
base_price += 1.0
if queso and item != "nachos":
base_price += 1.0
print(base_price)
Explanation:
- Use a conditional statement to check if meat is steak or pork then add 0.50 to base_price
.
- Check if the meat is steak or pork, then double_meat adds 1.50 or 1.0 otherwise
.
-
Check if meat is steak and its double_meat
, then add 1.50 and if its for guacamole, then add 1.00 to base_price
. If queso is there and item is not nachos, add 1.00 to base_price
.
- Finally when item is nachos, no need to add any money to base_price
.
Answer:
Mac comes with the up (or is bundled with) the up-to-date OS where with windows there are multiple flavors to choose from.
Explanation:
Sorry if its wrong
Green marketing<span> is the </span>marketing<span> of products that are presumed to be environmentally preferable to others.Thus </span>green marketing<span> incorporates a broad range of activities, including product modification, changes to the production process, sustainable packaging, as well as modifying advertising.</span>