Practical Database Design – Blog Schema Normalization to 3NF

Database Theory and Practical Application

Created by: Very Academy
Technical Education

What Will I 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

Target audience

• Beginners, Developers, Students, and Enthusiasts new to relational database design