kphillips001 / modeling

Node DB 4 Guided Project

Guided project for Node DB 4 Module.

Prerequisites

• SQLite Studio installed.
• a rest client like Insomnia or Postman installed.

Project Setup

• import and clone this repository.
• CD into the folder where you cloned your version.
• type npm i to download dependencies.
• type npm run server to start the API.

Please follow along as the instructor uses Knex migrations and seeding to create a multi-table database schema.

Modeling

Users had a map with markers. Kept record of user information.

• user accounts
  • id, pk, guid, required
  • avatar, optional, image
  • name, search term, required, at least 2 characters
  • username, unique
• messages
  • long and lat for location.
  • date
  • text
  • pictures

Workflow

• identify the entities (nouns) --> tables
• identify the properties --> columns
• identify relationships --> foreign keys

Relationships

• one to one
• one to many
• many to many

Mantras

• every table must have a primary key.
• work on two or three entities.
• one to many relationships require a foreign key
• the foreign key goes on the many side.
• on a many to many, use a third table.
• the third table could have extra information.

School Model

• keep a record of tracks (ds, ios, android, web, db)
• keep a record of units. A track is made up of multiple units.
• A unit is made up of sprints.
• the school has students.
• the students are grouped into cohorts.
• a student could be part of more than one cohort.