Stack 4 - Week 1 - Practice 003 - Dojos and Ninjas

Dojos and Ninjas (Practice)

This practice assignment will reinforce important learning objectives from the previous lesson(s), and allow you to take on more challenging core assignments, preparing you for graduation.

Practice and tinker with this assignment until you're comfortable performing each of the tasks. Then, be sure to submit your output as described in the steps below.

Learning Objectives:

  1. Practice designing ERDs

Assignment:

Create an ERD in MySQL workbench to represent the database that tracks dojos and the ninjas that belong to each.

Each dojo should have a name and city; each ninja should have a first name, last name, and belong to a specific dojo. Use the MySQL Workbench for creating this diagram.

Be careful to:

  • Follow our conventions

  • Consider primary and foreign keys!

  • Consider the type of relationship between the tables!

  • Name your schema "dojos"

Save your model as a .mwb file for use in the next lesson.

Add a screenshot of your ERD to a google doc and share the link.


My Submission