Need ideas for designing app using SQL Server

[maynard]

Sorry if I'm posting this in the wrong forum. I'm looking for ideas for a school project. It's something we will be building for college class. I guess I'm just looking for app ideas that would use a database. Any suggestions would be helpful. Or any links that would give me a better understanding of what apps use databases.

 

[Hack]

How about the old tried and true Inventory System?

 

[maynard]

yeah I suppose I could do that.. I was thinking more of a Guitar training program. I would like to have chord diagrams and scale diagrams and maybe some sheet music. I would also be able to track users progress. Just not to sure if this would really qualify as a database app per say.

 

[cjard]

Any app that needs to store data, qualifies. Even better if it can be used to run reports. What's the most common chord on the tab sheets? The database will know.. What are the top ten most varied songs (number of chords)? Again, the database will know..

 

[maynard]

Any app that needs to store data, qualifies. Even better if it can be used to run reports. What's the most common chord on the tab sheets? The database will know.. What are the top ten most varied songs (number of chords)? Again, the database will know..

True. I guess I just needed an extra little bit of reassurement.
Thanks!

 

[cjard]

Here are some SQLs, presuming that the songs table has a songid, barnumber and chordid (a song being composed of an arbitrary number of bars which do or do not have a chord in each; i don't know how songs are built but this may suffice) as an example of how databases can solve problems like these

SQL Server:
SELECT TOP 1 chordid FROM songs GROUP BY chord id ORDER BY count(*) DESC

Oracle:
SELECT chordid FROM (SELECT chordid FROM songs GROUP BY chord id ORDER BY count(*) DESC) WHERE rownum = 1


Most varied songs:
SELECT TOP 10 songid FROM songs GROUP BY songid ORDER BY count(DISTINCT chordid) DESC


SELECT * FROM (SELECT songid FROM songs GROUP BY songid ORDER BY count(DISTINCT chordid) DESC) WHERE rownumber < 11


Note: Please don't use Access for your DB!

 

[maynard]

Well, ran the idea by the teacher today and she liked it! The idea I guess will be that a user can bring up a song (tablature) which will be a picture I guess, then the app will bring up the appropriate chords and scale to go with it.. Not to sure how to implement this yet.. Still kinda toying with different ideas. Still trying to figure out what all the attributes will be too..

And no I'm not using Access, haha.. We are required to use SQL Server 2008 and the interface will be in VB.