Wait what’s the question tho??
Answer:
a thing that happens or takes place, especially one of importance.
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
.