python and databases

Create a SQLite3 Database A database is a container for related tables, so for our example we will create the database first, then a table, and then add data to the table The database will be petFood, and here is the table that we will create (called dogTreats) Weight Price 6.92 4.46 11.83 0.98 3.10 ProductID MB001 Description Milk-Bone 25 28 SB024 Snausages PC267 CC985 PP043 Pupcorn Canine Carryouts Pup-Peroni 10 Metadata about the table dogTreats ProductID is the primary key, every record (row) must have unique value in the is column cannot be null - Data Types o ProductID text o Description -text o Weight-integer o Price- real (decimal type numbers) Create a SQLite3 Database A database is a container for related tables, so for our example we will create the database first, then a table, and then add data to the table The database will be petFood, and here is the table that we will create (called dogTreats) Weight Price 6.92 4.46 11.83 0.98 3.10 ProductID MB001 Description Milk-Bone 25 28 SB024 Snausages PC267 CC985 PP043 Pupcorn Canine Carryouts Pup-Peroni 10 Metadata about the table dogTreats ProductID is the primary key, every record (row) must have unique value in the is column cannot be null - Data Types o ProductID text o Description -text o Weight-integer o Price- real (decimal type numbers)