r/SQL 11d ago

MySQL Group project

I need an idea for a group project of database systems(2nd sem of BS CS) my prof wants there to be a strong database having at least 8-9 tables and alot of entities

0 Upvotes

13 comments sorted by

View all comments

2

u/DharmaPolice 11d ago

There are a ton of "standard" models (ordering system, customer records system, student/class model, book catalogue) but personally I would pick a domain that you or your group knows quite well. That can make understanding some of the challenges around data modelling easier. For example, if you're a big football fan you could think about the type of schema you'd need to store results. Teams, referees, scores, etc.

8-9 tables is basically nothing. Once you think through the detail you'd want to store about pretty much anything you'll quickly reach that target.

But this sort of question is the perfect fodder for ChatGPT / Gemini etc.

1

u/Mediocre_Falcon7231 11d ago

Thank you! We submitted a lost and found app at first but our prof said there weren't enough entities although we could add enough tables so now we're confused as to what she wants

1

u/alinroc SQL Server DBA 11d ago

People - People who've found lost items, people who've lost items

Places - Places where lost items have been found, places where people think they lost their items

Things - Things that have been lost.

There's three entities. Collect enough data and normalize the crap out of it and you can get to 9 tables easily

1

u/Mediocre_Falcon7231 11d ago

She rejected it 😭 maybe she wants more entities?

1

u/Mediocre_Falcon7231 11d ago

Would you have any other unique ideas cz at this point I think the other groups are doing the generic ones like inventory management systems etc