Challenge 6: Table Design

Complete all parts of the task in sequence

• 📁 Create a new project in PyCharm;
• 📝 Create a new python file;
• 📚 Import the sqlite3 library;
• 🗄 Create a new database;
• 🤚 Create a cursor;
• 📄 Create a table named cars with the following fields:
  • id;
  • brand;
  • engine_capacity;
  • video_presentation;
• 📄 Select the appropriate data types in the table field;
• 🗝 One of the fields must be PRIMARY KEY;
• 🪖 Save the changes;
• 🔑 Close the database connection.