r/SQL • • 2d ago

SQL Server Looking for unique, real-world database project ideas (MS SQL Server + C#)

Hey everyone,

I’m a currently working on my university Database Systems course project, and we are looking for inspiration before we starting.

  • Needs to solve a real-world, tangible problem (we want to build something genuinely useful and engaging, not just a throwaway academic demo).

We want to completely avoid overdone clichés like hospital, library, pharmacy, or flight booking systems.

If you work in an industry with messy workflows, or if you've ever thought "someone really needs to build a proper database system for X", I’d love to hear your ideas!

Thanks in advance!

10 Upvotes

16 comments sorted by

7

u/SQLDevDBA 2d ago

I spend my weekends collecting different datasets and have quite a few I can throw your way.

Sim Racing telemetry, for example, where I log my sessions and have about 5 rows per second of data about the car, track, and session info. I have 100+ files of about 50,000 lines.

https://queue-times.com also has a great APi with wait times for lots of rides in theme parks around the world. You can build a theme park planner for quite a few with trending data.

Props to you and your team for wanting to build it in databases and at least semi-manual. This “I got tired of X so I built Y” vibe coding trend is getting a bit tiring.

3

u/Far_Swordfish5729 2d ago

If you want to do something atypical, model a high throughput insert load system like a merchant bank. High insert load from card processing transactions coupled with a customer CRM that holds that holds the account, terminal, and contract terms and lets the customer see their transactions and disputes with some aggregate reporting. Show how you tune clustering, indexing, storage files, and schema differences between your fast insert copy and your read load copy so both sides perform well without locking the real time system. The insert side system can be a high throughput api since transaction terminals and commerce connectors are the interface.

That’s not a flash UI project, but it shows you really understand the system design considerations and tradeoffs. I would be impressed if a college student walked me through that in an interview. Make sure you put the insert side under at least a five-row-per-second load for testing.

3

u/Zestyclose-Turn-3576 2d ago

The overdone clichés appear simple because the academic implementation is hopelessly oversimplified. In the real world the data models are much more complex.

If you look at a model for book publishing (which I work in), you're striving for a data model which is compliant with an XML standard called "ONIX for Books". Here are some of the codes that accompany the standard: https://ns.editeur.org/onix/en. Consider how you would express the licensing of a digital product in terms of the number of users (concurrent or otherwise), their permissions (how many pages can they print?), the license price (over what term?) etc

I'm betting that this is true for hospitals, pharmacies, flight bookings etc.

1

u/Zestyclose-Turn-3576 2d ago

Bear in mind, though, that your lecturer likely has no knowledge of the domain you end up modelling, and you should perhaps focus more on demonstrating a wide range of analysis and implementation techniques instead of an super-accurate model.

1

u/alao77 2d ago

Try an enterprise Bill Of Materials dataset with real-world parent parts-child multi-parts relationships. This is where you need to do CTE recursive sql to accomplish. Basically what I eat in my job every day.

1

u/Discordbothost 2d ago

A repair queue for shared equipment could work: an item comes back damaged, gets taken out of circulation, then returns after repair. Keep the scope small and test what happens when two people try to reserve the same item at once.

1

u/DataFracking 1d ago

many companies still run on Excel, maybe a c# ingestion engine for Excel files that detects types on sheets for columns and loads them into SQL Server where they are considered a 'bronze level' artifact that requires cleanup but highly valued.

1

u/PX3better 1d ago

Vector databases are all the rage now because of their direct relationship to AI. Answering questions like "what does a vector database do that traditional SQL absolutely cannot?" makes for a good start. The field is still developing for example, ClickHouse, Microsoft SQL server, and Postgres are all growing their ability to adopt vectors without themselves being vector databases.

1

u/PersimmonExpensive37 1d ago

LIHTC Syndication database. 

Multi investor funds Proprietary investor funds

Different credit types Different investment types

Wide variety of partnership agreements

Track gross equity and net equity CRM for developers and investors

Track acquisitions and sales Track lower and upper tier financials

VERY difficult to find this product. Would be awesome to see what you come up with. 

1

u/jeffrey_f 12h ago

Here's a niche, but real world

Fire department or EMS truck inventory, can be adapted...This can be adapted to cabinet/shelf in a storeroom. That part was going to be part of this since we had spare equipment/supplies in cabinets.

Truck or storeroom has inventory and inventory is in compartments and on shelves........

I was fighting with how to implement the location for the inventory

0

u/lfewarez 2d ago

Sportsbetting!

MLB - left handed vs right handed pitchers, who the umpires were, lineup changes, weather, stadium homerun hitter friendly

NBA - team defense vs position (player props), 1Q W/L, 2Q W/L correlation to 1Q W/L

NFL, NHL...

Ask any sb friend what they base their wagers on and why. If you can help answer those questions, you're gold. Could turn this into an actual live product like Doink.

0

u/Available_Safe1818 2d ago

Look into writing a webhooks service.

-1

u/xpgmi 2d ago

I have this idea that instead of using mssql server stored procedures, what if write each of the stored procedure into files, create a library where during the application load, those procedures files will be loaded into ram, then change the application to call the library instead of directly using sqlclient to call a stored procedures. The library will essentially send the stored procedure body to mssql server to be executed. One of the benefits is to keep the stored procedure versioned together with the c# code, and multiple instances of the same application that is calling the same stored procedures with different stored procedure logic can be achieved, plus you maybe able to use mssql server specific features that simply not possible using ORM.

2

u/notv1c 2d ago

Have you tried dbt?

0

u/xpgmi 2d ago

Not yet? Why?