Question: 1. Connect mySQL database by using Python. 2. (10 points) Create database and tables as given below by using Python. (a) RESTAURANT database (b)

1. Connect mySQL database by using Python. 2. (10 points) Create database

1. Connect mySQL database by using Python. 2. (10 points) Create database and tables as given below by using Python. (a) RESTAURANT database (b) MEAL: meal_id integer, meal_name varchar, cook_time time (c) INGREDIENTS: ing_id integer, ing_name varchar, preserve_time in- teger, ing_bought date (d) RECIPE: meal_id integer, ing_id integer Choose primary and foreign keys depending on the relations in RESTAU- RANT database design. 3. (20 points) Create arrays of at least 5 different records. Use these arrays to populate each table in the database. 4. (30 points) Apply the functions given below and print the results BASIC + cook_time 02:30:00 (MEAL) RESULT1+Tmeal_name (BASIC) RESULT2+ meal_name (ADVANCED) Umeal_name( RESULT3+ (MEAL INGREDIENTS) (BASIC) RESULTAT(ADVANCED meal_id-meal_id RECIPE) 5. (20 points) Print name of the meals which cook time is less than 1 hour and its ingredient is bought in 1 week time. 6. (20 points) Define Python functions for each table to insert a new record. For example, def insertMeal (id, name, lastname, cookTime). Note: Ensure that your programs are fully documented, using com- ments.

Step by Step Solution

★★★★★

3.41 Rating (167 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

PYTHON CODE import mysqlconnector Connect to the MySQL database mydb mysqlconnectorconnect hostlocalhost useryourusername passwordyourpassword databas... View full answer

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 Programming Questions!

Make a list of at least 5 systems that store energy, explaining which form of energy.

Think of at least 5 routine decisions you make or systems that you interact with on a routine basis that are now designed with Artificial Intelligence algorithms and constructs. Identify and list how...

The management of Mecca Copy, a photocopying centre located on University Avenue, has compiled the following data to use in preparing its budgeted balance sheet for next year: Ending Balances...

Darmen Corporation is one of the major producers of prefabricated homes in the home building industry. The corporation consists of two divisions: (1) Bell Division, which acquires the raw materials...

Suppose you are a manager in a customer service organization. Your group includes seven supervisors who report directly to you. Each supervisor manages a team of seven customer service...

=+a) Student ratings of an instructor on a 5 point Likert scale.

On January 1, 2010, Perez Company purchased 90% of the capital stock of Sanchez Company for $85,000. Sanchez Company had capital stock of $70,000 and retained earnings of $12,000 at that time. On...

Shwonson Industries reported a deferred tax asset of $7.25 million for the year ended December 31, 2020, related to a temporary difference of $29 million. The tax rate was 25%. The temporary...

For several years, Herschel Anderson had operated Management Consulting Company as its sole proprietor. On January 1, 2016, he formed a partnership with Richard Harris to operate the company under...

Sunland Company sells three different types of home heating stoves (gas, wood, and pellet). The cost and net realizable value of its inventory of stoves are as follows. Determine the value of the...

Draw a labelled diagram of the Dicot stem.

The magnitude and direction of two forces acting on an object are 50 pounds, S73E, and 110 pounds, N71E, respectively. Find the magnitude, to the nearest hundredth of a pound, and the direction...

Level 3: Write a program that alternates between the blue LED1 and red LED2, to simulate an emergency vehicle.

The figure shows a mechanism comprising two members AB and BD. Collar C is fastened to the mid point of member BD. If collar C moves freely along the rod with a constant velocity vc = 5 m/s ()....

1.A customer requires a hub-and-spoke Auto VPN deployment with two NAT-mode hubs with dual uplink connections and 50 remote sites with a single uplink connection. How many tunnels does each hub need...

How Should a lessor account for an operating lease?

Prove the following D,(cos x) = - sin x (Hint: Apply the identity cos(A + B) = cos A cos B sin A sin B)

Based on the following query: SELECT P_CODE, P_DESCRIPT, P_PRICE, PRODUCT.V_CODE, V_STATE FROM PRODUCT P, VENDOR V WHERE P.V_CODE = V.V_CODE AND V_STATE = NY AND V_AREACODE = 212; ORDER BY P_PRICE;...

As a discipline As a discipline, data visualization can be studied as _a group of visual communication techniques used to explore and discover data insights by applying: pattern recognition, spatial...

Global Unified Technology Sales (GUTS) is moving toward a bring your own device (BYOD) model for employee computing. Employees can use traditional desktop computers in their offices. They can also...

Restaurants need to plan the purchase and production of their food ingredients and components based on the forecast of demand for each meal. Consider the following example for veal picante with...

A furniture maker has received an order for 100 units of its kitchen table to be delivered at the beginning of Friday, March 20. The table consists of 1 top and 4 legs, made from purchased lumber (2"...

Consider the School Chairs Mini-case at the end of Chapter 6. Suppose the seat is made in a seat-fabrication work centre, all other parts (posts, cross bars, rails) are made in a post-bar-rail work...