Welcome to the Django E-commerce project variation 2. In this Django tutorial we focus developing an inventory app. The function of the stock app database is to keep the data that is needed to support online retail sales and stock inventory management. In this tutorial we focus on the database design. Database style and modelling are a few of those topics which hardly ever get the attention they should have, particularly at the start of the job, I have actually tried to provide you a summary of the actions used to develop the database tables for the inventory app.
The process of designing a database is not and must not be tough to comprehend. This is the very first shot at discussing the process in an uncomplicated way and each concept or strategy I try and plainly discuss. Ideally this tutorial will give you some insights, supported by a popular book.
The Book Referenced:
===.
Database Style for Mere Mortals: 25th Anniversary Edition Paperback– 28 Oct. 2020.
https://www.amazon.co.uk/Database-Design-Mere-Mortals-Anniversary/dp/0136788041.
===.
Database ERD.
====.
https://lucid.app/lucidchart/invitations/accept/inv_10095ab4-1f6f-4247-a2d5-285a7c7b82de.
Timeline:.
====.
Intros.
====.
Job and Tutorial Intros.
00:00 Introduction.
00:39 E-commerce Job v2 – the basic plan.
04:10 E-commerce Task Paperwork.
https://django-ecommerce-project-v2.readthedocs.io/en/latest/index.html.
04:38 E-commerce job quick.
07:36 Inventory app database preview.
08:10 Suggested book (No association) simply an excellent book!
https://www.amazon.co.uk/Database-Design-Mere-Mortals-Anniversary/dp/0136788041.
09:27 Guide protection and general Django app design concepts.
====.
Stock Objective Statement.
====.
10:47 Objective declaration & objective goals.
====.
Initial Fields List.
====.
12:56 Developing the Initial Fields List.
====.
Developing Table Structures.
====.
18:48 Intro – Establishing Table Structures.
19:26 Determining implied topics.
21:06 Identifying tables from gathered information.
21:41 Use objective goals to determine tables.
23:35 Designing 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 qualities of an ideal field.
29:48 Ideal Field -1: A field being an unique attributes of the subjects.
31:48 Ideal Field -2: Deconstructing fields into smaller sized components.
33:48 Perfect Field -3: Single worths – identifying multi-valued fields.
====.
38:19 Handling multivalued fields [Important] 43:21 Handling multivalued fields that have reliance fields [Important]====.
57:23 3-Refine the tables even more.
57:23 4-Assigned appropriate fields.
====.
Developing Keys.
====.
58:25 Introduction – Developing Keys.
58:38 Establishing a Suitable Table 1-6.
1:00:55 Candidate key conformality.
1:02:16 Assigning Main Keys to the tables.
====.
Table Relationships.
====.
1:16:45 Intro – Table Relationships.
1:17:40 Types of table relationships.
1:18:38 Building relationships in between tables.
1:36:10 Addressing/Resolving Many-to-Many.
====.
Table Refinements.
====.
1:39:55 Introduction – Table Refinements.
1:40:00 Reviewing the present design against the objective goals.
1:42:15 Item associates tables.
1:50:45 New mission goal: Refining the type table.
2:00:55 Evaluating the final style – including addition fields (updated_at) for example.
2:04:09 Examining the Stock table and WeightUnit table.
Documentation.
===.
https://django-ecommerce-project-v2.readthedocs.io/en/latest/index.html.
Assistance us – join us as a Really Academy Member.
https://www.youtube.com/channel/UC1mxuk7tuQT2D0qTMgKji3w/join.
Sign up for get more free tutorials, courses and code snippets!
http://www.youtube.com/channel/UC1mxuk7tuQT2D0qTMgKji3w?sub_confirmation=1.
Source