Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

BgDrip is a new textile manufacturer that has recently opened in your area. They sell various clothing items in bulk to various retailers. The business

BgDrip is a new textile manufacturer that has recently opened in your area. They sell various clothing items in bulk to various retailers. The business would like to store details of orders placed in a database. You have been contracted to develop a program that can be used to capture various order details and store them in a database. The owner would like to capture the following details:
Hide
Name
Surname
Email
Product
Unit Price
Quantity
The program should store these details in the database along with the calculated order total.
The following products are sold:
Search
Plain White Tee',
Plain Black Tee, Plain Grey Tee,
'Plain Colour Tee',
'Plain Grey Tee',
'Plain Colour Tee',
'Printed White Tee',
'Printed Black Tee',
Printed Grey Tee',
'Printed Colour Tee',
'Slim Fit Jeans',
Straight Fit Jeans',
'Ripped Jeans',
'Low-Cut Jeans',
'Plain Sweater',
'Printed Sweater',
'Plain Denim Jacket',
'Printed Denim Jacket',
'Plain Bomber jacket"',
'Printed Bomber Jacket',
'Plain Puffer jacket",
'Printed Puffer Jacket'
Write a Python GUI program that helps the business in the above scenario capture booking details and store them in a database (use sqlite database). The program must have the following components:
GUI: used to capture the order details as shown below.
Database: The details entered in the form must be saved in a database. The database must be implemented in a separate class. The database and the orders table must be created upon class initialization. The class should have a method to insert order details to the database. Note: All database interaction must be done through the class.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Pro Database Migration To Azure Data Modernization For The Enterprise

Authors: Kevin Kline, Denis McDowell, Dustin Dorsey, Matt Gordon

1st Edition

1484282299, 978-1484282298

More Books

Students also viewed these Databases questions