search

JBostroem96 / indieProject

Indie Project
0 stars 0 forks source link

Checkpoint #2 #3

Open JBostroem96 opened 8 months ago

JBostroem96 commented 8 months ago

@pawaitemadisoncollege I'd appreciate any feedback so far! Thank you. I'm still thinking about how I should form the complete DB design. So far I have two tables, User and Race.

pawaitemadisoncollege commented 8 months ago

Hi @JBostroem96!

  1. For the DB design,

a. It seems like this would need a table for Teams with name and category, anything else? b. A Category table would be helpful. Categories would be Solo Man, Solo Woman, Women, Men, and Coed. c. Then a joining table for TeamsAndRace that would have the team id, race id, and team's score (or place?) on it.

Here are some resources for the many to many with hibernate:

https://www.codejava.net/frameworks/hibernate/hibernate-many-to-many-association-with-extra-columns-in-join-table-example

https://mkyong.com/hibernate/hibernate-many-to-many-example-join-table-extra-column-annotation/

  1. Time to implement the generic dao. Remember you will still need your entity-specific-dao unit tests, but the daos themselves can be reduced to a single one. UPDATE - Paula Missed this it is implemented
  2. It looks like you are doing a good job keeping your time log up-to-date.
  3. Once you have the new tables above added, create an ERD and add it to your project documents. You can generate this in IntelliJ's database view if you don't have a tool that you prefer to use for this.
  4. Based on the tables I suggested above, you may want to re-examine your user stories. May need a story to add a team, for example?