the project is website and android app to just rating TV show
TV show added by admin.
website in php for rating TV show have only two user admin and customer
A)customer have two function for
1- customer can rate TV show .
2- customer can show rate (top 10 for selected category ).
3- customer no need to registration
B) admin have the following function
1) log in.
2) change password .
3) edit channel for example (add\delete\update).
4)edit satellite for example (add\delete\update).
5) edit show for example (add\delete\update).
6) add new admin .
android app only for customer and have only two function and its take information from website .
1- show rate (top for selected category ).
2-rate show .
i post database schema avg_rate is calculated =avg_rate + rate stars\number of raters