Course Content
Databases in Python
Databases in Python
1. Introduction to SQLite
3. More About SQLite
Challenge: Table Design
Task
Swipe to show code editor
You need to complete the code to create a table in an SQLite database named cars. The table should contain four fields:
id— a unique identifier for the car.brand— the brand of the car.engine_capacity— the engine capacity of the car.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 desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
Thanks for your feedback!
Section 3. Chapter 3
Challenge: Table Design
Task
Swipe to show code editor
You need to complete the code to create a table in an SQLite database named cars. The table should contain four fields:
id— a unique identifier for the car.brand— the brand of the car.engine_capacity— the engine capacity of the car.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 desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
Thanks for your feedback!
Section 3. Chapter 3
Switch to desktop for real-world practiceContinue from where you are using one of the options below