I need a sample database which has a table consisting of users table.
Another table with these details.
- current stock
- in stock
This is how the portal should be.
A login page where users or Admin logins in. (change password/ create
new user etc)
The tabs should be.
- stock in
- stock out
- transfer stock
In the stock in tab( it should be according to the picture)
Users should be able to click on course dropdownlist, they will see a list
Users should be able to click on language dropdownlist, they will see 7
languages(English, Malay, Mandarin, thai, bengali, Tamil, burmese)
Current stock is by default should be 0. Administrators should be able to
change its default value.
In is stock in where by users or Admins add stock to the current stock.
Total should be the total number of stock available.
Do take note. Each course has 7 languages. The stock should bind to the
amount and language.
Stock out is exactly the same. Except that 'in' is replaced with out. And
the function subtracts from the current stock.
Transfer stock should be like in the picture at the right side.
Users and Admin should be able to transfer stock between 3 locations desker
and hill view and classroom.
Admin and users should be separated by roles. Admin should have extra
2 tabs with the function of logging (ip log of whoever logs in) and
chart (which books have how much)