
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Create a script called manageProducts.py. It should allow the user to Create, Read, Update, and Delete products using the framework we have built. Products should have the following fields:
id (pk, auto_increment)
name
description
price
stock (number in inventory)
- Create the product table as username_products
- create a product class from the user class
- change the code in app.py to use product class, not user
- copy app.py to manageProduct.py, and make changes so you can edit products instead of users.
- add additional functionality to manageProducts.py to c,r,u,d
- This means adding an if statement for read and delete, also finishing the update.
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 3 steps

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- In Java programming. Write the code to create an object of each type of class. The names of the objects created in this part will be used for further requirements in this phase. Class Name: Customer Class Name: Inventory Class Name: OrderHeader Class Name: OrderDetail Class Name: Invoice Class Name: Shipment Four lines of code, one for each class defined above.arrow_forwardclass dvd: def __init__(self, title, director, producer, release_date, duration, dvd_id): self.title = title self.director = director self.producer = producer self.release_date = release_date self.duration = duration self.dvd_id = dvd_id def get_title(self): return self.title def get_director(self): return self.director def get_producer(self): return self.producer def get_release_date(self): return self.release_date def get_duration(self): return self.duration def get_dvd_id(self): return self.dvd_id def __repr__(self): return "Movie Name: "+self.title+", \nDirector : "+self.director+", \nProducer : "+self.producer+", \nRelease Date : "+str(self.release_date)+", \nDuration : "+str(self.duration)+", \nDVD ID : "+str(self.dvd_id) class customer: def __init__(self, name, customer_id): self.name = name self.dvds=[] self.customer_id = customer_id…arrow_forwardWrite a class called TV with attributes: channel, volumeLevel, on_Off_state. The default values should be 1 for channel (only channels 1 to 100 are allowed), 5 for volumeLevel (only volumeLevels 1 to 10 are allowed), and OFF for on_Off_state (only ON and OFF are allowed). The TV class should allow the user to create a default TV and a TV with given parameters for channel, volumeLevel, on_Off_state. User should be able to set the TV channel to any channel, or increment or decrement the channel within the channel range. User can only increment or decrement volumeLevel within the valid range. User should be able switch the TV ON or OFF. User should be able read the current state of TV (i.e. values of channel, volumeLevel, and on_Off_state).arrow_forward
- read carefully. object must be passed to method not variablesarrow_forwardClass Circle A Circle will have a radius. The class will be able to keep track of the number of Circle objects created. It will also hold the total of the circumferences of all the Circle objects created. It will allow a client to create a Circle, passing in a double value for the radius into the Circle constructor. If the value for the radius that is passed in is 0 or negative, then the radius will be set to a value of 999. The constructor should add 1 to the count of the number of Circles created. The constructor should call a method to calculate the circumference and then add the circumference for that object to an accumulator. In addition to the constructor, the Circle class must have the following methods that return a boolean value: isCongruent(Circle c) – Compares two Circle objects to determine if they are congruent (radii are equal). isValid() – the radius may not be 0 or negative. equals (Triangle t) – compares two Triangle objects…arrow_forwardIn Java programming. Write the method that will populate the properties of each object. Assume that you have read the data from a flat file into variables for each property in the class. customer = new_Customer (); inventory = new_Inventory (); orderHeader = new_OrderHeader (); orderDetail = new_OrderDetail (); invoice = new_Invoice (); shipment = new_Shipment (); Use one of the object names from above. Write the signature line for this method Write the code that will assign a variable value to one property in the selected object. Be sure variable names use proper naming convention.arrow_forward
- Q2: Create a book modelDraw a class diagram to depict a book as specified by the following statement: "A book is made up of several parts, each of which is made up of several chapters."Sections are made up of chapters." To begin, concentrate just on classes and associations.Multiplicity should be added to the class diagram you created.Improve the class diagram by adding the following features:• The book has a publisher, a publishing date, and an ISBN number.• A title and a number are included in a part; a title, a number, and an abstract are included in a chapter; and a title, a number, and an abstract are included in a section.Take a look at the refined class diagram. A title and a number characteristic are included in the Part, Chapter, and Section classes. To factor out these two traits, use inheritance.arrow_forwardclass dvd: def __init__(self, title, director, producer, release_date, duration, dvd_id): self.title = title self.director = director self.producer = producer self.release_date = release_date self.duration = duration self.dvd_id = dvd_id def get_title(self): return self.title def get_director(self): return self.director def get_producer(self): return self.producer def get_release_date(self): return self.release_date def get_duration(self): return self.duration def get_dvd_id(self): return self.dvd_id class customer: def __init__(self, name, customer_id): self.name = name self.customer_id = customer_id def get_name(self): return self.name def get_customer_id(self): return self.customer_id class store: def __init__(self): self.dvds = [] self.customers = [] def add_dvd(self,…arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education

Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON

Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education