4.7 out of 5
4.7
19 reviews on Udemy

Practical Database Design – Blog Schema

Database Theory and Practical Application
Instructor:
Very Academy
34 students enrolled
English [Auto]
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

Databases or relational database systems have always been a subject with a “steep learning curve”. Students tend to find it challenging, and learning takes much more effort 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.

Introduction

1
Introduction
2
Course Resources

Relational Database Underpinning Knowledge

1
Key Terminology: Databases, RDBMS, and the Data Lifecycle
2
Key Terminology: Entity and Tables
3
Key Terminology: Attributes and Fields
4
Database Design Objectives

Stage 1: Project Initiation

1
Project Introduction: Designing a Blog Database

Stage 2: Establishing Entities and Attributes

1
Introducing the Entities
2
Identifying Significant Entities
3
Project: Approach 1 – Formulate the Preliminary Entity List
4
Project: Lucid Chart
5
Project: Approach 1 – Associate Attributes with Entities
6
Project: Approach 2 – Identifying Entities from a List of Attributes
7
Illustrating a Database Design – Entity Relationship Diagram (ERD)
8
Table and Field Naming Convention [19]

Stage 3: Refining the Table Structures

1
Normalisation and 1NF
2
Multivalued Fields
3
Project: Identify and Resolve Multivalued Fields
4
Multipart (composite) Fields
5
Project: Identify and Resolve Multipart Fields

Stage 4: Establishing Keys

1
Table Keys
2
Candidate Key
3
Primary Key
4
Project: Establishing Table Keys

Stage 5: Dependency

1
Dependency
2
Normalization Second Normal Form (2NF)
3
Partial Key Dependencies
4
Project: Identify and Resolve Partial Key Dependencies

Stage 6: Establishing Table Relationships

1
Table Relationships
2
Identifying Table Relationships
3
One-to-Many
4
Many-to-Many
5
One-to-One
6
Project: Establishing Table Relationships

Stage 7: Normalization 3NF

1
Normalization Third Normal Form (3NF)
2
Transitive Dependency
3
Project: Identity and Resolving Transitive Dependencies

Stage 8: Expanding the Database Design

1
Project Requirement: Capture User Actions
2
Project Requirement: Alert to Any Objectionable Material by Flagging
3
Project Requirement: Custom Post Attributes
4
Project Requirement: Post Comments
5
Project Requirement: Post Ratings
Faq Content 1
Faq Content 2

Productivity Hacks to Get More Done in 2018

— 28 February 2017

  1. Facebook News Feed Eradicator (free chrome extension) Stay focused by removing your Facebook newsfeed and replacing it with an inspirational quote. Disable the tool anytime you want to see what friends are up to!
  2. Hide My Inbox (free chrome extension for Gmail) Stay focused by hiding your inbox. Click "show your inbox" at a scheduled time and batch processs everything one go.
  3. Habitica (free mobile + web app) Gamify your to do list. Treat your life like a game and earn gold goins for getting stuff done!


4.7
4.7 out of 5
19 Ratings

Detailed Rating

Stars 5
12
Stars 4
5
Stars 3
1
Stars 2
0
Stars 1
1