membership='Bronze' total_retail_price=1000 sales_tax=7.25 if membership=="Platinum" : discount_factor =10 elif membership=="Gold": discount_factor =8 elif membership=="Silver": discount_factor =6 elif membership=="Bronze": discount_factor =4 else: discount_factor =0 print(discount_factor) total_retail_price =0 for key in quantity_on_hand: value= items_price[key]*quantity_on_hand[key] total_retail_price = total_retail_price + value print(total_retail_price) def final_price(total_retail_price ): discount_value=total_retail_price*discount_factor/100 price_before_tax=total_retail_price-discount_value sales_tax_amount=price_before_tax*sales_tax/100 final_price=price_before_tax+sales_tax_amount return(final_price) final price(total retail price)

membership='Bronze' total_retail_price=1000 sales_tax=7.25 if membership=="Platinum" : discount_factor =10 elif membership=="Gold": discount_factor =8 elif membership=="Silver": discount_factor =6 elif membership=="Bronze": discount_factor =4 else: discount_factor =0 print(discount_factor) total_retail_price =0 for key in quantity_on_hand: value= items_price[key]quantity_on_hand[key] total_retail_price = total_retail_price + value print(total_retail_price) def final_price(total_retail_price ): discount_value=total_retail_pricediscount_factor/100 price_before_tax=total_retail_price-discount_value sales_tax_amount=price_before_tax*sales_tax/100 final_price=price_before_tax+sales_tax_amount return(final_price) final price(total retail price)

Programming with Microsoft Visual Basic 2017

8th Edition

ISBN:9781337102124

Author:Diane Zak

Publisher:Diane Zak

Chapter11: Sql Server Databases

Section: Chapter Questions

Problem 6E

See similar textbooks

Similar questions

price = 9 num= 2 total = Select the most appropriate replacement field definitions. = num * price print(' {2} tacos at $ {2} 2 tacos at $9 each costs $18. each costs ✓ Select.format(total, price, num)) {3} {1} {0} {2}
Write down 5 triggers. Triggers should be meaningful.
Relation: Relation is a two-dimensional table in which data is named. The relations have the named columns and numbers which denote the unnamed rows. Although relation is defined as the two-dimensional table of data, not all the tables are considered as relations. There are some properties that differentiate relation tables from non-relation tables.
SQL: Add a table-level PRIMARY KEY constraint to the EMPLOYEE table using the ID column. The constraint should be named at creation. (Which means you'll need to drop the table, then recreate.) Create a PRIMARY KEY constraint on the DEPARTMENT table using the ID column. The constraint should be named at creation. (Which means you'll need to drop the table, then recreate.) Add a foreign key reference on the EMPLOYEE table that will ensure that the employee is not assigned to a nonexistent department. Confirm that the constraints were added by querying USER_CONSTRAINTS. Note the types and names of the constraints and include them in your statement comments. Display the object names and types from the USER_OBJECTS data dictionary view for EMPLOYEE and DEPARTMENT tables. You will want to format the columns for readability. Provide comments that include the new tables and indexes created. Modify the EMPLOYEE table by adding a SALARY column of NUMBER data type, precision 7. Confirm…
Sql
Task 3: ' The Car Maintenance team wants to insert and store the following maintenance types to the MAINTENANCE_TYPES table: ID: 1; Description: Tire Change; Price: 50 ID: 2; Description; Oil Change; Price: 45 ID: 3; Description; Full Cleaning; Price: 100 ID: 4; Description; Gas Pump Change; Price: 145 ANSWER IN MYSQL PLEASE
Customer ={idC(PK), surname} Contract ={idC(PK), customer, consultant, insurance_type, date} Consultant means: id of some Staff member Staff={idPerson(PK), surname,dob, boss, email} Dob means: date of birth, boss: is id of another Staff member supervisor Insurance_Type={idT(pk) , Tname , price , length } Length = number of months it is valid (from the date when it was bought ) Find consultants born after some contract was already signed?
Based on the ERD below, display the first name, last name and employee initial of anyone whose first name starts with “A”. (Hint: You will use a “Like” phrase.)
herpever applicable 2. Title field in Instructor table should allow only Mr., Ms., Mrs., Dr., Prof. as values apply check constraints
Based on the ERD below, write the SQL statement to display the average hourly job charge for a job.
Write down 5 check constraints. Check constraints should be meaningful.
The International Conference on Mathematical Sciences and Technology, Math Tech, is a biennial conference organised by the School of Mathematical Sciences, USM. This event is open to all national and international experts, practitioners, researchers, and academics to gather and share their knowledge. The details of fees for participation in the conference are shown in the following table. Category Local (RM) International (USD) Presenter 990 260 Observer 600 150 Note: 1 USD = RM4.20 Assignment Requirement Part 1: Create Invoice Construct a C++ program to do the following tasks: a. Enter the participant's name, category, nationality, accommodation (Yes/No). b. If the answer for the question on accommodation is Yes, the program will ask for the number of days. Then the program will call function calcAccommodation() to calculate the accommodation charges. calcAccommodation() receives accommodation (Yes/No), number of days and participation type (local/international) as parameters and…