Project Description:
We have an SQL Database that handle all our orders. The database run on NexusDB engine. We want to add some features to it.
1# Orders put in database should be stamped with time. Each product we manufacture have a specific production time. Therefore we also want a list that show orders that where put in late, so each product should have a "time margin" if there is less time between order put in and delivery time then i want all these orders to show on specific list.
2# All products in database belong to certain types. I want to be able to change the name of the types, and also the products retroactively.
3# I want statistic to be shown for all productes and product types manufactured. Currently i can only see quantity per client, i want to see statistics for total output.
Here you can download database files,
https://dl.dropbox.com/u/47440130/DB.rar
And here you can download our engine
https://dl.dropbox.com/u/47440130/Br%C3%B6d%20o%20Salt%20Orderhantering.exe
ENgine is in swedish language so you have to use google translate to understand what is going on. To open database you have to have exe file and db folder in same folder.
There is also more work to be done on database but we start with these features to see if you can solve the tasks.
