Envío gratis siempre a todo México.
Haz clic para hacer zoom
Not Available
Rismon Hasiholan
FULL SOURCE CODE: MYSQL FOR STUDENTS AND PROGRAMMERS WITH PYTHON GUI
Cargando comentarios…
Comparte
$193
Envío gratis siempre
Comentarios
Cargando el resumen…
Cargando comentarios…
product
1267267FULL SOURCE CODE: MYSQL FOR STUDENTS AND PROGRAMMERS WITH PYTHON GUIhttps://www.gandhi.com.mx/full-source-code-mysql-for-students-and-programmers-with-python-gui/phttps://gandhi.vtexassets.com/arquivos/ids/180069/0621f805-1155-4271-a89f-b088f7dd6ca0.jpg?v=638333710784500000193193MXNBALIGE PUBLISHINGInStock/Ebooks/<p>In this project, we provide you with a MySQL version of an Oracle sample database named OT which is based on a global fictitious company that sells computer hardware including storage, motherboard, RAM, video card, and CPU. The company maintains the product information such as name, description standard cost, list price, and product line. It also tracks the inventory information for all products including warehouses where products are available. Because the company operates globally, it has warehouses in various locations around the world.</p><p>The company records all customer information including name, address, and website. Each customer has at least one contact person with detailed information including name, email, and phone. The company also places a credit limit on each customer to limit the amount that customer can owe. Whenever a customer issues a purchase order, a sales order is created in the database with the pending status. When the company ships the order, the order status becomes shipped. In case the customer cancels an order, the order status becomes canceled. In addition to the sales information, the employee data is recorded with some basic information such as name, email, phone, job title, manager, and hire date.</p><p>In this project, you will write Python script to create every table and insert rows of data into each of them. You will develop GUI with PyQt5 to each table in the database. You will also create GUI to plot: case distribution of order date by year, quarter, month, week, and day; the distribution of amount by year, quarter, month, week, day, and hour; the distribution of bottom 10 sales by product, top 10 sales by product, bottom 10 sales by customer, top 10 sales by customer, bottom 10 sales by category, top 10 sales by category, bottom 10 sales by status, top 10 sales by status, bottom 10 sales by customer city, top 10 sales by customer city, bottom 10 sales by customer state, top 10 sales by customer state, average amount by month with mean and EWM, average amount by every month, amount feature over June 2016, amount feature over 2017, and amount payment in all years.</p>...1256198FULL SOURCE CODE: MYSQL FOR STUDENTS AND PROGRAMMERS WITH PYTHON GUI193193https://www.gandhi.com.mx/full-source-code-mysql-for-students-and-programmers-with-python-gui/phttps://gandhi.vtexassets.com/arquivos/ids/180069/0621f805-1155-4271-a89f-b088f7dd6ca0.jpg?v=638333710784500000InStockMXN99999DIEbook20221230005684793_W3siaWQiOiJjNDg2MDhiYS04ZDY0LTQzM2QtOGZlMi1iYjhmMDUxYzViODgiLCJsaXN0UHJpY2UiOjE5MywiZGlzY291bnQiOjAsInNlbGxpbmdQcmljZSI6MTkzLCJpbmNsdWRlc1RheCI6dHJ1ZSwicHJpY2VUeXBlIjoiSXBwIiwiY3VycmVuY3kiOiJNWE4iLCJmcm9tIjoiMjAyNS0wOC0yNFQxNjowMDowMFoiLCJ0byI6IjIwMjUtMDktMzBUMjM6NTk6NTlaIiwicmVnaW9uIjoiTVgiLCJpc1ByZW9yZGVyIjpmYWxzZX0seyJpZCI6ImVhYmJlZDQxLWU1MzktNDU3ZS04MDIyLTgxMWVhNzA2NmI0OCIsImxpc3RQcmljZSI6MTg2LCJkaXNjb3VudCI6MCwic2VsbGluZ1ByaWNlIjoxODYsImluY2x1ZGVzVGF4Ijp0cnVlLCJwcmljZVR5cGUiOiJJcHAiLCJjdXJyZW5jeSI6Ik1YTiIsImZyb20iOiIyMDI1LTEwLTAxVDAwOjAwOjAwWiIsInJlZ2lvbiI6Ik1YIiwiaXNQcmVvcmRlciI6ZmFsc2V9XQ==1230005684793_<p>In this project, we provide you with a MySQL version of an Oracle sample database named OT which is based on a global fictitious company that sells computer hardware including storage, motherboard, RAM, video card, and CPU. The company maintains the product information such as name, description standard cost, list price, and product line. It also tracks the inventory information for all products including warehouses where products are available. Because the company operates globally, it has warehouses in various locations around the world.</p><p>The company records all customer information including name, address, and website. Each customer has at least one contact person with detailed information including name, email, and phone. The company also places a credit limit on each customer to limit the amount that customer can owe. Whenever a customer issues a purchase order, a sales order is created in the database with the pending status. When the company ships the order, the order status becomes shipped. In case the customer cancels an order, the order status becomes canceled. In addition to the sales information, the employee data is recorded with some basic information such as name, email, phone, job title, manager, and hire date.</p><p>In this project, you will write Python script to create every table and insert rows of data into each of them. You will develop GUI with PyQt5 to each table in the database. You will also create GUI to plot: case distribution of order date by year, quarter, month, week, and day; the distribution of amount by year, quarter, month, week, day, and hour; the distribution of bottom 10 sales by product, top 10 sales by product, bottom 10 sales by customer, top 10 sales by customer, bottom 10 sales by category, top 10 sales by category, bottom 10 sales by status, top 10 sales by status, bottom 10 sales by customer city, top 10 sales by customer city, bottom 10 sales by customer state, top 10 sales by customer state, average amount by month with mean and EWM, average amount by every month, amount feature over June 2016, amount feature over 2017, and amount payment in all years.</p>...1230005684793_BALIGE PUBLISHINGlibro_electonico_9810660f-af46-323d-bb19-1adb3d447349_1230005684793;1230005684793_1230005684793Rismon HasiholanInglésMéxicohttps://getbook.kobo.com/koboid-prod-public/f2ca928b-958d-498f-bb70-f76c6615d8f6-epub-2fcc52f9-83b0-4947-ba2e-afa54e87ea09.epub2022-07-24T00:00:00+00:00BALIGE PUBLISHING