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

139,000 تومان

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

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

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

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