Practical Database Design – Blog Schema

سرفصل های دوره

Database Theory and Practical Application

1 - Introduction

1 - Introduction

2 - Course Resources.html

2 - Specification.docx

2 - Relational Database Underpinning Knowledge

3 - Key Terminology Databases RDBMS and the Data Lifecycle

4 - Key Terminology Entity and Tables

5 - Key Terminology Attributes and Fields

6 - Database Design Objectives

3 - Stage 1 Project Initiation

7 - Project Introduction Designing a Blog Database

4 - Stage 2 Establishing Entities and Attributes

8 - Introducing the Entities

9 - Identifying Significant Entities

10 - Project Approach 1 Formulate the Preliminary Entity List

11 - Project Lucid Chart

12 - Project Approach 1 Associate Attributes with Entities

13 - Project Approach 2 Identifying Entities from a List of Attributes

14 - Illustrating a Database Design Entity Relationship Diagram ERD

15 - Table and Field Naming Convention 19

5 - Stage 3 Refining the Table Structures

16 - Normalisation and 1NF

17 - Multivalued Fields

18 - Project Identify and Resolve Multivalued Fields

19 - Multipart composite Fields

20 - Project Identify and Resolve Multipart Fields

6 - Stage 4 Establishing Keys

21 - Table Keys

22 - Candidate Key

23 - Primary Key

24 - Project Establishing Table Keys

7 - Stage 5 Dependency

25 - Dependency

26 - Normalization Second Normal Form 2NF

27 - Partial Key Dependencies

28 - Project Identify and Resolve Partial Key Dependencies

8 - Stage 6 Establishing Table Relationships

29 - Table Relationships

30 - Identifying Table Relationships

31 - OnetoMany

32 - ManytoMany

33 - OnetoOne

34 - Project Establishing Table Relationships

9 - Stage 7 Normalization 3NF

35 - Normalization Third Normal Form 3NF

36 - Transitive Dependency

37 - Project Identity and Resolving Transitive Dependencies

10 - Stage 8 Expanding the Database Design

38 - Project Requirement Capture User Actions

39 - Project Requirement Alert to Any Objectionable Material by Flagging

40 - Project Requirement Custom Post Attributes

41 - Project Requirement Post Comments

42 - Project Requirement Post Ratings

“Spring AI: Beginner to Guru” به سبد خرید شما اضافه شد. مشاهده سبد خرید

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training