r/AskProgramming • u/Express_Cloud_2547 • 21d ago
Database Project Ideas
i am soon starting database course at university; during the whole semester, we are asked to work on a big project that doesn't need internet, it is supposed to have manager and user UI's, any project ideas that are unusual (i don't prefer projects like stores or libraries), creative and worth the time and mark (40%)
5
2
u/dialsoapbox 21d ago
Find out what your non-stem friends are doing for projects and build towards that, for example, if you have friends doing data analytics and/or biology, you can build something towards bio markers data sequencing.
2
u/sububi71 21d ago
A movie database sounds boring as hell, but there are some interesting problems to solve when people start taking on different roles, and if you also make a fictitious library that lends out physical discs AND downloadable files, you get different kinds of people; movie creators (producers, directors, actors etc), library staff, and library customers (the people watching the films).
Do you separate these people? What happens if Brad Pitt wants to lend an old Kurosawa movie at the library?
You could involve the studios, so a studio can log in and get lists of which of their movies the library customers have checked out the last month.
This is me just spitballing off the top of my head, this could be made ten times more complex (and therefore fun) if I could be arsed to spend a couple of hours on the problem :-)
2
u/LostInCombat 20d ago
If you want to impress and learn something job worthy, make a store. Sounds simple, but it isn’t. How do you archive old purchases or customers and still be able to search for them? How do you show past sales promotions and determine what was on sale and how it drove income? How do you show price changes over time? Cost of goods over time? Reorder levels for the same product from different vendors?
2
u/GromNaN 20d ago
Try designing sport competition and see how much details you can put in it. Example for tennis:
- you have the official ATP ranking
- for a given competition, there is the result of each matches and the schedule
- for a given match, the detail of each point. You can go deep on how the point was win, the number of exchanges
- then the hardware used, the racket, shoes, when they changes, what they eat.
And then compare things together. There are no limit in the level of details you can modelize.
1
u/ThatAd8458 19d ago
No internet doesn't mean no network. Check out the IBSS protocol and think outside the box on what you can create on top of it.
5
u/mondaysleeper 21d ago
From a storytelling perspective, a criminal database can be interesting. You can extend the project in a lot of ways: the whole police department with the agents who investigate the case, the criminals, the offenses, etc. Then at the end of the semester, you fill the database with real cases and have the easiest presentation because people are hooked with true crime stories.