Tutorial 201:

Create

Tutorial 201: Lesson 2

Data Model

Organizing your information

You’ve defined a clear goal for your custom app. Now it’s time to think about what kind of information it will track and how that information will be organized. This is called your data model.

Your model is fundamental to your success: the choices you make when organizing your information determine what your app can show to the user and what your app can do. In this lesson you will learn what a data model is, and will plan one for your custom app.

Why is this important?

The big “wins” in a custom app — automating your workflow and building insightful reports for your team — depend on having a solid data model. Investing in this foundation will help ensure the success of your custom app.

Video 1

Learning about data organization

This video will introduce a few key database concepts and terms you’ll use in your future design work, then help you begin planning your data model.

In this video, you will:

  • Learn key data modeling terms:
    • Tables: the categories of things you want to track (0:21)
    • Fields: specific attributes describing each individual thing (0:28)
    • Records: individual instances of the things tracked in a given table (0:36)
    • Relationships: connections you make between tables to describe what they have in common (0:46)
  • Decide which tables the physical therapy app will need (1:07)

Video 2

Designing your data model

Learn how relationships depend on essential “key” fields, then plan the relationships you’ll use in the sample app.

In this video, you will:

  • Understand a common type of relationship: learn about the “one-to-many” relationship (0:38)
  • Define primary and foreign keys: see how a lack of key fields can lead to messy data (1:00)
  • Find your relationships: determine how your app’s tables should relate to each other (2:40)

Related Resource