Django Project E-commerce v2 Part 1 - Database Design

Описание: Welcome to the Django E-commerce project version 2. In this Django tutorial we focus developing an inventory app. The purpose of the inventory app database is to maintain the data that is needed to support online retail sales and stock inventory management. In this tutorial we focus on the database design. Database design and modelling are some of those topics which rarely get the attention they deserve, especially at the start of the project, I have tried to provide you an overview of the steps used to develop the database tables for the inventory app.

The process of designing a database is not and should not be hard to understand. This is the first try at explaining the process in a straightforward manner and each concept or technique I try and clearly explain. Hopefully this tutorial will give you some insights, supported by a popular book.

The Book Referenced:
===
Database Design for Mere Mortals: 25th Anniversary Edition Paperback – 28 Oct. 2020
https://www.amazon.co.uk/Database-Des...
===

Database ERD
====
https://lucid.app/lucidchart/invitati...

Timeline:
====
📋 Introductions
====
Project and Tutorial Introductions
00:00 Introduction
00:39 E-commerce Project v2 - the general plan
04:10 E-commerce Project Documentation
https://django-ecommerce-project-v2.r...
04:38 E-commerce project brief
07:36 Inventory app database preview
08:10 Recommended book (No affiliation) just a good book!
https://www.amazon.co.uk/Database-Des...
09:27 Tutorial coverage and general Django app design principles
====
📋 Inventory Mission Statement
====
10:47 Mission statement & mission objectives
====
📋 Preliminary Fields List
====
12:56 Developing the Preliminary Fields List
====
📋 Establishing Table Structures
====
18:48 Intro - Establishing Table Structures
19:26 Identifying implied subjects
21:06 Identifying tables from collected data
21:41 Use mission objectives to identify tables
23:35 Modelling our initial fields and data
====
📋 Refining the fields
====
25:06 Intro - Refining the fields
26:31 1-Improving the field names - guidelines
28:49 2-Resolving any structural problems
28:54 The characteristics of an ideal field
29:48 Ideal Field -1: A field being a distinct characteristics of the subjects
31:48 Ideal Field -2: Deconstructing fields into smaller components
33:48 Ideal Field -3: Single values - identifying multi-valued fields
====
38:19 Resolving multivalued fields [Important]
43:21 Resolving multivalued fields that have dependency fields [Important]
====
57:23 3-Refine the tables further
57:23 4-Assigned appropriate fields
====
📋 Establishing Keys
====
58:25 Intro - Establishing Keys
58:38 Establishing an Ideal Table 1-6
1:00:55 Candidate key conformality
1:02:16 Assigning Primary Keys to the tables
====
📋 Table Relationships
====
1:16:45 Intro - Table Relationships
1:17:40 Types of table relationships
1:18:38 Building relationships between tables
1:36:10 Addressing/Resolving Many-to-Many
====
📋 Table Refinements
====
1:39:55 Intro - Table Refinements
1:40:00 Reviewing the current design against the mission objectives
1:42:15 Product attributes tables
1:50:45 New mission objective: Refining the type table

2:00:55 Reviewing the final design - adding addition fields (updated_at) for example
2:04:09 Reviewing the Stock table and WeightUnit table

Documentation
===
https://django-ecommerce-project-v2.r...

✨ Support us - join us as a Very Academy Member
   / @veryacademy  

👍SUBSCRIBE to get more free tutorials, courses and code snippets!
   / @veryacademy