ExamHoot
12 / 30Django Models and Database DesignMediumPython - Django Framework

Scenario: Hari's E-commerce Product Database Design

  1. Product should have ForeignKey to Category and ManyToManyField to Tag

  2. Product should have ManyToManyField to both Category and Tag

  3. Product should have ForeignKey to both Category and Tag

  4. Product should have OneToOneField to Category and ForeignKey to Tag

Show answer & explanation

Correct answer

Product should have ForeignKey to Category and ManyToManyField to Tag

Explanation

For an e-commerce system, Product should have ForeignKey to Category (one-to-many), and ManyToMany relationship with Tag since products can have multiple tags and tags can be associated with multiple products. This avoids data redundancy.

Written by ExamHoot EditorialPublished · Updated

All 30 Django Models and Database Design questions

  1. 1.What is the primary purpose of Django Models?
  2. 2.Which field type should be used to store an email address in a Django Model?
  3. 3.What does the Meta class inside a Django Model do?
  4. 4.Which relationship type is used when one model can have many instances of another model?
  5. 5.What is the purpose of the `__str__` method in a Django Model?
  6. 6.Which field attribute makes a field mandatory in Django Models?
  7. 7.What does the `on_delete` parameter do in a ForeignKey relationship?
  8. 8.Which of the following is a valid Django field type for storing boolean values?
  9. 9.What is the default behavior when you don't specify `null=True` for a field in Django?
  10. 10.Which method is used to retrieve a single object from the database in Django?
  11. 11.Understanding Django Model Meta Options
  12. 12.Scenario:
  13. 13.Django QuerySet Filter vs Get Method
  14. 14.Coding:
  15. 15.Scenario:
  16. 16.Understanding Django Model Inheritance
  17. 17.Coding:
  18. 18.Scenario:
  19. 19.Django Model Manager and QuerySet Methods
  20. 20.Coding:
  21. 21.Django Model Inheritance Strategy Selection
  22. 22.Django QuerySet Optimization with select_related vs prefetch_related
  23. 23.Django Model Field Choices and Validation
  24. 24.Django Model Relationships:
  25. 25.Django Model Signals and Database Consistency
  26. 26.Django Model Meta Options:
  27. 27.Django Model Managers and Custom QuerySets
  28. 28.Django Model Field:
  29. 29.Django Model Validation:
  30. 30.Django Model Aggregation and Annotation