4Geeks logo
4Geeks logo
About us

Learning library

For all the self-taught geeks out there, here our content library with most of the learning materials we have produces throughout the years.

It makes sense to start learning by reading and watching videos about fundamentals and how things work.

Full-Stack Software Developer

Data Science and Machine Learning - 16 wks

Search from all Lessons

Social & live learning

The most efficient way to learn: Join a cohort with classmates just like you, live streams, impromptu coding sessions, live tutorials with real experts, and stay motivated.

← Back to Projects

Continue learning for free about:

Data Modeling a StarWars Blog using Node and Typescript

Goal

4Geeks Coding Projects tutorials and exercises for people learning to code or improving their coding skills

Difficulty

easy

Repository

Click to open

Video

Not available

Live demo

Not available

Average duration

3 hrs

Technologies

StarWars blog database

Inside the ./entities directory you will find a ./entities/User.js class describing an example User database entity (table).

Here is a 4min video explaining what UML is: https://www.youtube.com/watch?v=UI6lqHOVHic

We are going to be creating the Entity Relationship Diagram for your StarWars Blog Database, a very similar diagram to this one:

Starwars Diagram Click to open diagram

🔥 You can use this FREE tool to practice your diagram for the first time: https://app.quickdatabasediagrams.com/#/d/

💻 Instalation

This boilerplate already comes with everything you need: a postgres database, the typescript configuration, and the TypeORM configuration.

Every time you want to generate your diagram just type: $ npm run diagram and it will print a URL link to your diagram image.

📝Instructions

Start by reading the documentation on how to create entities using TypeORM.

Your Job is to update the ./entities/ directory with the files and code needed to replicate the StarWars data model.

The project is using the TypeORM Node.js library to generate the database.

  • Your project must have a table User that will represent your blog users.
  • Your blog users will be able to login and save their favorite planets and characters.
  • The database should store the user favorites.
  • The database should store characters and planets.
  • What other tables do you think a blog like this might have?
  • What properties should go inside the user? or inside the Character or Favorite table?
  • What are the relationships between those tables?
  • Please add at least 4 models with all of its properties.
  • Generate your diagram by running $ npm run diagram on the console.

Goal

4Geeks Coding Projects tutorials and exercises for people learning to code or improving their coding skills

Difficulty

easy

Repository

Click to open

Video

Not available

Live demo

Not available

Average duration

3 hrs