Django Project E-commerce v2 Part 1 - Database Design скачать в хорошем качестве

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