Question: * * * IN PYTHON * * * Step 1 : Implement database setup methods in DbManager.py DbManager.py contains class DbManager which allows the food

***IN PYTHON***Step 1: Implement database setup methods in DbManager.py
DbManager.py contains class DbManager which allows the food vendor to create and access the database. Implement the following attributes and methods for class DbManager:
Attributes
Connection conn - Connection object that, once connected, will be used throughout the program.
Instance methods
Database Setup Methods
connect()
Establishes a connection to an in-memory database.
disconnect()
Disconnects from the existing database.
create_menu_table(data_file)
Reads a .tsv file and creates a table named menu.
Calls insert_menu() to insert individual entries to the table.
insert_menu(menu)
Reads a menu tuple containing the column values of a menu entry (category, item_name, description, price, prep_time, availability).
Inserts an entry into the menu table with column values listed in the parameter.
create_user_table(data_file)
Reads a .tsv file and creates a table named user.
Calls insert_user() to insert individual entries into the table.
 ***IN PYTHON***Step 1: Implement database setup methods in DbManager.py DbManager.py contains

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!