I'm about to start a university database course, and we have to build a substantial project over the entire semester. It should work without internet access and include separate interfaces for managers and regular users. I'm looking for something more creative and unusual than a typical store or library system—ideally a project with enough complexity to be interesting, demonstrate strong database design, and be worth a significant portion of the final grade. What ideas would you suggest?
5 Answers
Build around a hobby or interest you already understand. That usually leads to better requirements and more realistic workflows. For example, you could manage equipment, events, memberships, bookings, maintenance, rankings, or progress tracking instead of just storing basic records.
Another ambitious option is a database toolkit that generates example schemas for several industries, along with data-entry screens, reports, useful views, and queries for detecting unusual activity. That would demonstrate database design, reusable components, role-based access, and analytics. You could limit it to two or three well-designed domains so the project stays manageable.
A criminal investigation database could make a really engaging project. You could model police departments, investigators, cases, suspects, criminals, offenses, evidence, witnesses, and case outcomes. Different user roles could have different permissions, and you could add reports showing connections between cases or recurring patterns. A presentation would also be more memorable if you populate it with fictional or publicly available historical cases.
A sports competition system has a lot of room for depth. For tennis, you could track tournaments, rankings, players, schedules, match results, individual points, rally details, equipment, and player statistics. You could then create queries comparing performance across tournaments, surfaces, equipment, or time periods. The same approach would work for racing, esports, martial arts, or team sports.
You could design a media lending platform that handles both physical discs and digital rentals. It could include creators, studios, titles, versions, staff, customers, loans, downloads, licensing rules, and reports for studios. The interesting part is handling different roles and permissions, ownership, availability, overdue items, and historical rental data rather than just making a basic catalog.
That’s a great idea—there are a lot more entities and relationships to model than I initially expected.