Homework 10 For this assignment you are to read in the data from the 'menu.txt file and create an SQLite database from it, called 'menu.db'.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
Emenu.txt x +
1 Antipasti Misto, $9.95, 1
2 Rigatoni Alle Stagioni, $14.95, 2
3 Penne Cesare, $15.95, 2
4
5
Penne Vodka, $14.95, 2
Farfalle del Campo, $13.95, 2
6 Fettucini al Grano duro, $13.95, 2
7 Vongole Alla Oregonata 0. Casino, $8.95, 1
Homemade Canoli, $6.00, 3
8
9
10
13
Tartufo Gelato al Cioccolate, $7.50, 3
Gozze Posillipo 0. Luciana, $7.95, 1
11 Rigatoni All'Amatriciana, $13.95, 2
12 Vongole Posillipo 0. Luciana, $8.95, 1
Lumache Poluignon, $8.95, 1
Gonochi Sorrento, $13.95, 2
15 Linguini Diabolo, $15.95, 2
16 Zucchini Fritti, $6.95, 1
17 Tartuffo Di Mare, $9.95, 1
14
18
19
20 Copa Di Gamberi, $11.95, 1
21
22
23
24
Tartuffo Alla Rockefeller, $9.95, 1
Cocktail Di Vongole, $8.95, 1
25
Spumoni Ice Cream, $6.00, 3
26 Suppa del Giorno, $6.00, 1
27
Cheese Cake, $6.00, 3
28
Stracciatella Fiorentina, $5.00, 1
Delizia Di Parma con Melone, $8.95, 1
Minestrone, $5.00, 1
Pasta and Fagioli, $5.00, 1
Fresh Fruit Salad, $6.00, 3
29 Zuppa Pavase, $5.00, 1
30 Insalata di Stagioni, $5.00, 1
31
Spaghetti al Filetto di Pomodoro, $19.95, 2
32 Spaghetti Carbonara, $13.95, 2
33
Calamari Fritti, $8.95, 1
34 Ravioli al Funghetto, $14.95, 2
35 Insalata Tricolore, $6.50, 1
36 Spinach Salad, $6.00, 1
37 Pepperoni Arostili, $8.00, 1
41
42
38 LaCaprese, $8.00, 1
39
40
43
44
Capellini Alla Primavera, $13.95, 2
Carpaccio al Salmone, $8.95, 1
Antipasto Fredo, $8.95, 1
Gran Misto di Fonghi alla Griglia, $12.95, 1
Vegelati all Griglia, $7.95, 1
Linguini Alla Salsa D'Astice, $16.95, 2
45 Linguini Alle Vongole, $14.95, 2
46 Sabaglioni, $6.50, 3
47 Linguini di Mare, $16.95, 2
48 Fettucini Al Fredo, $13.95, 2
49 Spaghetti Bolognese, $13.95, 2
50 Tortellini Alla Nana, $13.95, 2
Tiramisu, $7.00, 3
51
52 Lasagna del Giorno, $13.95, 2
Fusilli Mare and Monte, $15.95, 2
53
54 Risotto Fruitti di Mare, $15.95, 2
55 Risotto al Funcghi, $13.95, 2
56 Risotto Cesare, $13.95, 2
57
Carrot Cake, $6.00, 3
58
Flan Caramel Custard, $6.00, 3
59
Transcribed Image Text:Emenu.txt x + 1 Antipasti Misto, $9.95, 1 2 Rigatoni Alle Stagioni, $14.95, 2 3 Penne Cesare, $15.95, 2 4 5 Penne Vodka, $14.95, 2 Farfalle del Campo, $13.95, 2 6 Fettucini al Grano duro, $13.95, 2 7 Vongole Alla Oregonata 0. Casino, $8.95, 1 Homemade Canoli, $6.00, 3 8 9 10 13 Tartufo Gelato al Cioccolate, $7.50, 3 Gozze Posillipo 0. Luciana, $7.95, 1 11 Rigatoni All'Amatriciana, $13.95, 2 12 Vongole Posillipo 0. Luciana, $8.95, 1 Lumache Poluignon, $8.95, 1 Gonochi Sorrento, $13.95, 2 15 Linguini Diabolo, $15.95, 2 16 Zucchini Fritti, $6.95, 1 17 Tartuffo Di Mare, $9.95, 1 14 18 19 20 Copa Di Gamberi, $11.95, 1 21 22 23 24 Tartuffo Alla Rockefeller, $9.95, 1 Cocktail Di Vongole, $8.95, 1 25 Spumoni Ice Cream, $6.00, 3 26 Suppa del Giorno, $6.00, 1 27 Cheese Cake, $6.00, 3 28 Stracciatella Fiorentina, $5.00, 1 Delizia Di Parma con Melone, $8.95, 1 Minestrone, $5.00, 1 Pasta and Fagioli, $5.00, 1 Fresh Fruit Salad, $6.00, 3 29 Zuppa Pavase, $5.00, 1 30 Insalata di Stagioni, $5.00, 1 31 Spaghetti al Filetto di Pomodoro, $19.95, 2 32 Spaghetti Carbonara, $13.95, 2 33 Calamari Fritti, $8.95, 1 34 Ravioli al Funghetto, $14.95, 2 35 Insalata Tricolore, $6.50, 1 36 Spinach Salad, $6.00, 1 37 Pepperoni Arostili, $8.00, 1 41 42 38 LaCaprese, $8.00, 1 39 40 43 44 Capellini Alla Primavera, $13.95, 2 Carpaccio al Salmone, $8.95, 1 Antipasto Fredo, $8.95, 1 Gran Misto di Fonghi alla Griglia, $12.95, 1 Vegelati all Griglia, $7.95, 1 Linguini Alla Salsa D'Astice, $16.95, 2 45 Linguini Alle Vongole, $14.95, 2 46 Sabaglioni, $6.50, 3 47 Linguini di Mare, $16.95, 2 48 Fettucini Al Fredo, $13.95, 2 49 Spaghetti Bolognese, $13.95, 2 50 Tortellini Alla Nana, $13.95, 2 Tiramisu, $7.00, 3 51 52 Lasagna del Giorno, $13.95, 2 Fusilli Mare and Monte, $15.95, 2 53 54 Risotto Fruitti di Mare, $15.95, 2 55 Risotto al Funcghi, $13.95, 2 56 Risotto Cesare, $13.95, 2 57 Carrot Cake, $6.00, 3 58 Flan Caramel Custard, $6.00, 3 59
Homework 10
For this assignment you are to read in the data from the 'menu.txt file and create an SQLite database from it, called 'menu.db.
Show Transcribed Text
main.py x +
1 import sqlite3
2
3
4 Put your solution here
5
6
7
for record in c.execute("SELECT * FROM items"):
8
print (record)
Transcribed Image Text:Homework 10 For this assignment you are to read in the data from the 'menu.txt file and create an SQLite database from it, called 'menu.db. Show Transcribed Text main.py x + 1 import sqlite3 2 3 4 Put your solution here 5 6 7 for record in c.execute("SELECT * FROM items"): 8 print (record)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY