Skip to main content

Data Models (3.2)

Note

Timing

You have 2 hours to complete this stage of the project, after which we will debrief as a group.

Step 1: Data Model Design and Construction

Using the process flow diagram and the requirements listed below, record your design decisions in the shared Google Sheets document.

Note

Get your Data model designs approved by a course Instructor before building them in L7|ESP.

3157557412.png

Data Model Requirements:

  1. All Entity Types should belong to one new Entity Class.

  2. Each Entity Type should have a unique custom ID sequence.

  3. At a minimum, Seeds should contain the following information:

    1. Plant Species (Field Mustard, Radish, or Turnip)

    2. Mother Plant's ID

    3. Father Plant’s Pollen (Stock Pollen - North Carolina, Stock Pollen - Florida, or Stock Pollen - Georgia)

    4. Date Harvested

  4. At a minimum, Plants should contain the following information:

    1. Plant Species (Field Mustard, Radish, or Turnip)

    2. Number of Flowers Pollinated

    3. Number of Pods

    4. Number of Seeds

  5. At the start of the process, Planting Trays are used to grow one seed per location (see image below).

  6. At the end of the process, Seed Chambers are used to store harvested Seeds (see image below).

  7. Fertilizer is used for nutrients (see image below).

  8. Light bulbs are used to provide controlled light exposure (see image below).

  9. Inventory Items are purchased from Home Depot.

3157557424.png

Note

Testing

Test that each data model renders as expected by creating entities in the Entities App, containers in the Location App, and items in the Inventory App.

Items must be created in the Inventory app before they can be used in Experiments.

In this section: