Django ORM | Case Study 1 | Database Design Build and Query | Ecommerce Inventory | Django

We design, implement and query an E-commerce inventory database in this case study. Creating a relational database is not and should not be hard to understand. This is not my words, but a quote from the Book “Database Design for Mere Mortals”. To help us develop the database in this case study, we follow components of the design methodology inspired by this excellent book which I recommend to all new developers. As we move through the design phase, it is essential to remember that I have tried to summarise many of the design stages, relevant details, and processes for use in the case study and the context in that you are new to database design. As and when we add other case studies to the course, I hope to unfold a more comprehensive design process.

Udemy Course Link: Django 4.x ORM Mastery
===================
https://www.udemy.com/course/django-4...

Timeline: (todo)
00:00 Design - Design methodology
18.1.3. Design – Define the purpose
18.1.4. Design - Requirement analysis – Business Requirements
18.1.5. Design - Defining the preliminary list of fields
18.1.6. Design - Defining the preliminary subjects/entities
18.1.7. Design - Refining the fields and tables
18.1.8. Design - Naming fields and tables
18.1.9. Design - Establishing Keys
18.1.10. Design - Field Specifications
18.1.11. Design - Table Relationships
18.1.12. Design - Table Relationships – update fields
18.1.13. Design - Business Rules
18.1.14. Design – Django / Application Rules
18.1.15. Build – Create the tables and fields
18.1.16. Data – Create data - Django Admin Site
18.1.17. Data – Create data - Django fixtures
18.1.18. Data – Create data - Management command
18.1.19. Query – Return all products


Django ORM YouTube Playlist
===================
   • DJ101 | Django Database ORM Mastery C...  

Code Repository:
===================
https://github.com/veryacademy/Django...