Design a Relational Database

TechIntermediateHome

90 minutes

5 steps

·Intermediate

After 90 min: A properly structured database for a real application or business problem

What you need

LaptopDatabase design tool like LucidchartDatabase software

The 90-Minute Plan

Understand Normalization0–15 min

Learn about database normalization rules (1NF, 2NF, 3NF) to avoid data redundancy.

Define Entities15–35 min

Identify tables and columns for your application. List all attributes needed.

Create ER Diagram35–55 min

Draw entity relationships using a tool. Show primary and foreign keys.

Implement Database55–75 min

Write CREATE TABLE statements. Set up constraints and indexes.

Ship & next steps75–90 min

Insert sample data. Test relationships. Next: optimize with indexes.

Pro Tip

Think about queries before designing. Avoid unnecessary joins. Use meaningful names.

90 min·5 steps

TechBeginner

After 90 min: Ability to extract, filter, and analyze data from a real database

7,923

see the plan

90 min·5 steps

TechAdvanced

After 90 min: Dramatically faster query execution and reduced database load

8,765

see the plan

90 min·5 steps

TechIntermediate

After 90 min: A webpage with buttons, forms, and interactive elements that respond to user actions

8,901

see the plan

90 min·5 steps

TechIntermediate

After 90 min: A website that looks perfect on phones, tablets, and desktops

7,645

see the plan