a little sprint review for you
- fork & clone this project
-
cd
into your project - create your own branch -
firstname-lastname
-
npm i
to get all node dependencies
- a
store
can have multiplegroceries
- a
grocery
belongs to only onestore
- a
store
can use multiplesupplies
. Examples of somesupplies
would be: reusable grocery bags, cart, grocery list, pen - the same
supplies
can be used in mulitplestores
- when adding a
grocery
the client must provide aid
of an existingstore
please follow this schema when building your db tables
Table Names | Requirements | Entities |
---|---|---|
store | name | unique ID(integer), name(string), location(string), completed(boolean) |
gorceries | store_id, name | unique ID(integer), store_id(matches with store ID in the store table, integer) name(string), completed(boolean) |
supplies | name | unique ID(integer), name(string), in_use(boolean) |
store_supplies a table to combine the store and the supplies tables | store_id, supplies_id | store_id(matches with the store ID in the store table, integer), supplies_id(matches with the supplies ID in the supplies table) |
as you build these tables, think about the relationships between them
if you are a visual learner and would like a drawing of the table connections, here is a jamboard I created 😊 👇
https://jamboard.google.com/d/1EPeL3jNxmSHUHQtRLilKbhDPObYGKisniUhq9hYy1uo/edit?usp=sharing