2. Mr. ABC goes to AEON supermarket for his monthly grocery/provisions purchases. He has purchased the following items: (Units: Ringgit Malaysia/grams, Kilograms, Litres, Millilitres) Items Apples Oranges Flour Milk Maggie Noodles Cooking oil Sugar Quantity 1kg 800 gms 2 kgs 1 carton = 12 x1L tetra packs 2 family packs 2 Litres 3 kgs Amount 3RM/150 gms 2RM/100 gms a. Total no. of items purchased b. Cost of each item purchased c. Discount applied d. The final amount to be paid 40RM/1000gms 6RM/L 10RM/pack (5*79gms) RM13/250ml RM2/250gms Design and develop a python code to calculate the total bill amount including the discount for the items purchased. Since ABC was an AEON member, he was given a discount of about 5% on the total bill amount. The output should have the following:

2. Mr. ABC goes to AEON supermarket for his monthly grocery/provisions purchases. He has purchased the following items: (Units: Ringgit Malaysia/grams, Kilograms, Litres, Millilitres) Items Apples Oranges Flour Milk Maggie Noodles Cooking oil Sugar Quantity 1kg 800 gms 2 kgs 1 carton = 12 x1L tetra packs 2 family packs 2 Litres 3 kgs Amount 3RM/150 gms 2RM/100 gms a. Total no. of items purchased b. Cost of each item purchased c. Discount applied d. The final amount to be paid 40RM/1000gms 6RM/L 10RM/pack (5*79gms) RM13/250ml RM2/250gms Design and develop a python code to calculate the total bill amount including the discount for the items purchased. Since ABC was an AEON member, he was given a discount of about 5% on the total bill amount. The output should have the following:

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter3: Performing Calculations With Formulas And Functions

Section: Chapter Questions

Problem 19RA

See similar textbooks

Similar questions

An agency called Resourcecover supplies part-time/temporary staff to hotels throughout Mauritius. The table shown in Figure 1 lists the time spent by agency staff working at two hotels. The National Insurance Number (NIN) is unique for each employee. NIN contractNo HrsPerWeek empName HotelNo HotelLocation 125WD C1024 16 Samuel Н25 Grandbay Fody 142XA C1024 24 Dev Samy Н25 Grandbay 169YD C1025 28 Sara Ally H4 Tamarin 125WD C1025 16 Samuel Н4 Tamarin Fody Figure 1: Resourcecover i. The table shown in Figure 1 is susceptible to update anomalies. Provide examples of insertion, deletion, and update anomalies. i. Describe and illustrate the process of normalising the table shown in Figure 1 to 3NF. State any assumptions you make about the data shown in this table.
Q Normalize the following table up to 3 NF Ono Odate CustCN CustName City Phone PCode Pname CatId CatName Qty UPrice 1/12/2017 6893692 Amani Ruwi Marker Stationary Hardware Stationary Sports Stationary Stationary Sports 196 95251456 M1 150 1.2 R1 Printer 10 35 Pencil Football P3 173 1 190 1/11/2019 6893692 Amani Ruwi 95251456 P1 1 4 Pencil Marker Football P3 2 173 1 200 2/12/2020 1232345 Ahmed Salalah 898989980 M1 200 1.2 P1 1 5 4
Normalized the information mention in form into 3NF plz solve in 70 minutes.
2. For the given two table: Salesman Customer C ID C 1 С 12 С 13 С 14 С 15 Name S ID City Paris S_ID Name City Age РPP S001 S001 JJJ Paris 56 S002 ΚΚ New York 80 QQQ Paris S002 RRR London S003 S003 LLL London 46 SS California S005 S004 MMM Rome 86 S005 London TTT Germany S005 O00 74 Orders S ID С ID C 1 С 1 С 13 С 14 С 15 Ord Date Amount O no C 1 С 12 C 13 С 14 С 15 2012-10-20 1000 S001 2012-11-12 2000 S002 2012-09-23 3000 S003 4000 5000 2012-08-14 S004 2012-07-18 S005 a. Write a query to find the salesperson and customers who belongs to same city. b. Write a query to find the name and the Amount purchased by the customers who's ordered amount exists between 3500 to 5000. c. Write a query to find all the orders issued by the salesman "JJ". d. Write a query to find all the orders, which are generated by those salespeople, who live in the city of "London". e. Write a query to find the orders generated by the salespeople who may work for customers whose id is C 11.
The table below is how Magical Medical Place (MMP) keep track of the medication it givens to patients and the doctors that prescribed the medication. Doc ID Doc Name Pat Name Pat contact 321456 John 321457 Sarah Medication Price Quantity Reggy Samual 0861236548 Penicillin R200 10 0796549872 Antibiatics R400 20 Robafen Cough Doxycycline Penicillin Antibiotics Robafen Cough R10 40 321459 Mary 321460 Linda 321461 John 321462 Robert Susan 0116549875 R250 20 Reggy 0861236548 R200 10 0321789654 0987349165 R400 20 Queen Junior R10 25 3.1 In which normal form is the above table? Motivate your answer. 3.2 Identify a Primary Key and motivate why the identified attributes were chosen. 3.3 Provide all the dependencies of the given table. 3.4 Convert the table into the second normal form. 3.5 Convert the table into the third normal form. 3.6 Must is the purpose of Normalization? 3.7 Provide two(2) suggestions on how to improve the design of the table after they have been restructured into third…
Question 18 Cte y thet finh the pduct that hae unit cont larger thn 50 ur ry ut the Product 0 Pduct ame Slier's company name S er's contact perso's name phone Sort the pruducts by price from largest to smutlest OMECT D Pt Srte Contett Pu FROM P T JOIN Ste ON odSerib SeesSe WHERE A ORDER BY DEC OMuCT hda ert Contt thoe FROM P NER FOIN Spers ON Podu ert Se Soier WERE P 0 ORDER BY DESC OMECT dtD Productha olertame ContartName hone FROM Prodach NNER JOIN Sules ON Produ SupliertD-Supples SpoferD WHERE P THAN 30 ORDER BY DESC OMLECT P D. ProductName Sunolierhane Contacte Phane FROM Pducts FULL OUTER JOIN Saen ON Paducts SlerD- Suls ler WHERE P 30 ORDER BY Pri DnC
I need the answer as soon as possible
convert the crow foot notation diagram into a chen's notation
Consider the table below showing details of parents and their children ID NO Full Name Age Children Name Sex Date of Birth 001 Alex morgan 40 yrs 1. John Alex M 03 Jan 2017 2. Kim Alex M 15 Jun 2019 3. Tom ALEX M 27 Aug 2020 002 Jack Lig 45 yrs 1. Seth Jack M 13 Sep 2014 2. Palu Jack 21 May 2021 003 Sam Dan 36 yrs 1. Ann Sam F 17 Apr 2000 2. Lims Sam F 30 Jul 2009 Ben Sam 20 Nov 2013 from the details above create a ms access database. 3.
Given the following schema ROOM mNo mPrice mBeds mCapacity mFecilities mElec 10 80 1 WC Shower 20 95 25 100 3 3 Bethtub TV CUSTOMER RESERVATION cusNo cusName 1000 Ahmed Aamer cusAddress cusNo rmNo dateln dateOut Salelah Ibri 1000 20 09/02/2020 15/02/2020 20/04/2021 12/12/2020 18/12/2020 1001 Sami Mohamed 1001| 25 1004 Faisal Fares Suhar 1004 10 1. Write SQL commands to create the above tables. Include necessary constraints. 2. Write relational algebra expression to display names of customers who reserved a rooms with capacity less than 3 people. 3. Write SQL command to find the name of the customers who stayed in rooms that do not have a Bathtub. 4. Write SQL command to display the names of customers who did not fix the date of departure from the hotel. 5. Write SQL command to modify the attribute mPrice in the table ROOM to real number with 3 decimal places. 6. Create a VIEW which can display the rooms which are roomprice lessthan 100.
Cse Note need step by step Answer
quickly Please