Hello-
Facts:
Where I work, we have about 20 stores. Each store sells the same 8 objects for sale. Each store sells each item for a different price on any given day.
The questions:
1) It seems that MySQL would be able to mange this easily. What I am not sure is, could MySQL manage to save all the past data as well - so that a user could check for past 6 month's prices of object 4 at store 10?
2) Would it be possible to figure out what store has each item the cheapest at any given time or date?
3) Would it be possible to create an admin interface so that a trusted person could add or subtract stores - add or subtract items from the global list?
4) Finally, it would be nice to have it so that you could click on a specific store to view its picture, location info, whatever store specifics.
If this is something that is workable, I'll go get myself a MySQL book and study the heck out of it and install linux and MySQL on a computer here to practice on.
Thanks for reading this far and thanks for any help you can offer to me on this path..
-WC-
Facts:
Where I work, we have about 20 stores. Each store sells the same 8 objects for sale. Each store sells each item for a different price on any given day.
The questions:
1) It seems that MySQL would be able to mange this easily. What I am not sure is, could MySQL manage to save all the past data as well - so that a user could check for past 6 month's prices of object 4 at store 10?
2) Would it be possible to figure out what store has each item the cheapest at any given time or date?
3) Would it be possible to create an admin interface so that a trusted person could add or subtract stores - add or subtract items from the global list?
4) Finally, it would be nice to have it so that you could click on a specific store to view its picture, location info, whatever store specifics.
If this is something that is workable, I'll go get myself a MySQL book and study the heck out of it and install linux and MySQL on a computer here to practice on.
Thanks for reading this far and thanks for any help you can offer to me on this path..
-WC-