Practical Database Design - Blog Schema

What you'll learn
Build a database design from a given set of requirements
Determine a set of prelimiary entities and attributes to start a database design
Normalise a database design into 1NF taking into consideration multivalued and miltipart fields
Establish table candidate and primary keys
Normalise a database design into 2NF taking into consideration partial key dependencies
Identify multiple types of table relationships and define relationships between tables
Normalise a database design into 3NF taking into consideration transitive dependencies
Develop database design solutions to common features of a blog application
Requirements
No Prior experience needed but would be advantageous
Description
Out of all the tech subjects I have lectured on, databases or relational database systems have always been a subject with a "steep learning curve". Students tend to find it challenging, and it just takes much more effort to learn than other subjects.To my surprise, I am one of many people who have observed this trend. There is, in fact, a small niche of research papers written on this topic.So why is it so challenging? When I think of how we might overcome some challenges when learning databases instantly, I think of one fact that remains true, which goes back to even when I started learning database systems. There needed to be more examples or actual database design in practice. This course aims to help support anyone starting their journey into relational database systems by establishing underpinning skills and concepts of database and database design by working through practical scenario reasoning and providing the rationale to design decisions. Nothing beats experience in most subjects. That is amplified in the realms of relational database development. With the knowledge and experience gained in the course in hand, I hope that on completion of this course, it will provide the scaffolding, underpinning knowledge to support your endeavours in the world of relational database development.
Overview
Section 1: Introduction
Lecture 1 Introduction
Lecture 2 Course Resources
Section 2: Relational Database Underpinning Knowledge
Lecture 3 Key Terminology: Databases, RDBMS, and the Data Lifecycle
Lecture 4 Key Terminology: Entity and Tables
Lecture 5 Key Terminology: Attributes and Fields
Lecture 6 Database Design Objectives
Section 3: Stage 1: Project Initiation
Lecture 7 Project Introduction: Designing a Blog Database
Section 4: Stage 2: Establishing Entities and Attributes
Lecture 8 Introducing the Entities
Lecture 9 Identifying Significant Entities
Lecture 10 Project: Approach 1 - Formulate the Preliminary Entity List
Lecture 11 Project: Lucid Chart
Lecture 12 Project: Approach 1 - Associate Attributes with Entities
Lecture 13 Project: Approach 2 - Identifying Entities from a List of Attributes
Lecture 14 Illustrating a Database Design - Entity Relationship Diagram (ERD)
Lecture 15 Table and Field Naming Convention[19]
Section 5: Stage 3: Refining the Table Structures
Lecture 16 Normalisation and 1NF
Lecture 17 Multivalued Fields
Lecture 18 Project: Identify and Resolve Multivalued Fields
Lecture 19 Multipart (composite) Fields
Lecture 20 Project: Identify and Resolve Multipart Fields
Section 6: Stage 4: Establishing Keys
Lecture 21 Table Keys
Lecture 22 Candidate Key
Lecture 23 Primary Key
Lecture 24 Project: Establishing Table Keys
Section 7: Stage 5: Dependency
Lecture 25 Dependency
Lecture 26 Normalization Second Normal Form (2NF)
Lecture 27 Partial Key Dependencies
Lecture 28 Project: Identify and Resolve Partial Key Dependencies
Section 8: Stage 6: Establishing Table Relationships
Lecture 29 Table Relationships
Lecture 30 Identifying Table Relationships
Lecture 31 One-to-Many
Lecture 32 Many-to-Many
Lecture 33 One-to-One
Lecture 34 Project: Establishing Table Relationships
Section 9: Stage 7: Normalization 3NF
Lecture 35 Normalization Third Normal Form (3NF)
Lecture 36 Transitive Dependency
Lecture 37 Project: Identity and Resolving Transitive Dependencies
Section 10: Stage 8: Expanding the Database Design
Lecture 38 Project Requirement: Capture User Actions
Lecture 39 Project Requirement: Alert to Any Objectionable Material by Flagging
Lecture 40 Project Requirement: Custom Post Attributes
Lecture 41 Project Requirement: Post Comments
Lecture 42 Project Requirement: Post Ratings
Beginners, Developers, Students, and Enthusiasts new to relational database design


Homepage