Self-paced

Explore our extensive collection of courses designed to help you master various subjects and skills. Whether you're a beginner or an advanced learner, there's something here for everyone.

Bootcamp

Learn live

Join us for our free workshops, webinars, and other events to learn more about our programs and get started on your journey to becoming a developer.

Upcoming live events

Learning library

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

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

Search from all Lessons


LoginGet Started

Register to 4Geeks

โ† Back to Projects

Data Modeling a StarWars Blog

Difficulty

  • easy

Average duration

3 hrs

Technologies

Difficulty

  • easy

Average duration

3 hrs

๐Ÿ’ป Installation

Important: To do this activity, you need to fork this repo into your Github account and then open the forked repo on Gitpod.

Inside the src/models.py file you will find a couple of classes describing an example database.

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/

๐Ÿ’ป Installation

  1. Get inside the environment $ pipenv shell

  2. Install all dependencies $ pipenv install

  3. Generate de diagram as many times as you need $ python src/models.py

  4. Open the file diagram.png to check out your UML diagram!

๐Ÿ“ Instructions

Your Job is to update the src/models.py file with the code needed to replicate the StarWars data model.

The project is using the SQLAlchemy Python 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 their properties.
  • Generate the diagram.png file at the end by running $ python3 models.py on the console.

This and many other projects are built by students as part of the 4Geeks Academy Coding Bootcamp by Alejandro Sanchez and many other contributors. Find out more about our Full Stack Developer Course, and Data Science Bootcamp.

Signup and get access to similar projects

We will use it to give you access to your account.
Already have an account? Login here.

By signing up, you agree to the Terms and conditions and Privacy policy.

Difficulty

  • easy

Average duration

3 hrs

Difficulty

  • easy

Average duration

3 hrs

Difficulty

  • easy

Average duration

3 hrs

Difficulty

  • easy

Average duration

3 hrs

Signup and get access to similar projects

We will use it to give you access to your account.
Already have an account? Login here.

By signing up, you agree to the Terms and conditions and Privacy policy.

Difficulty

  • easy

Average duration

3 hrs

Difficulty

  • easy

Average duration

3 hrs