Databases for Designers

Why learn about databases?

It turns out that understanding data and databases is a major part of creating feasible designs.

Demystifying Databases

Objects

Fields

  • Text
  • Long text
  • Dropdown (set options)
  • Date
  • Number
  • Email
  • Phone
  • and there’s a lot more
(I’ll get to the blank space shortly!)

Record

Bonus: Related objects

A relation object
Showing a connection between our objects

Putting this in action

Design

A simple website displaying books

But, what if I want something that’s not there?

  • What kind of data is it?
  • Where do we get that data from?
  • Who will get it?
  • How will it stay maintained?
  • How will we validate it?
  • What if we can’t get that data for every record?

When will I run into this?

  • Blog posts
  • User profiles
  • Reviews
  • Any kind of listings — jobs, apartments, people, you name it.

Try it yourself!

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store