Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Learn Challenge: Table Design | More About SQLite
Working with Databases in Python
close
Section 3. Chapter 3
single

single

bookChallenge: Table Design

Swipe to show menu

Task

Swipe to start coding

You need to complete the code to create a table in an SQLite database named cars. The table should contain four fields:

  1. id - a unique identifier for the car.
  2. brand - the brand of the car.
  3. engine_capacity - the engine capacity of the car.
  4. video_presentation - a video presentation of the car.

Fill in the blanks in the SQL query by choosing the correct data types for each field.

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 3. Chapter 3
single

single

Ask AI

expand

Ask AI

ChatGPT

Ask anything or try one of the suggested questions to begin our chat

some-alt