Hi
Killer390,
you can try to make a database for 3 types of users.
(1) Management (2) staff (3) customers
you can add tables like management/ staff details
management users can have right to see the reports of collection , reports of profit, reports of staff members.
they will not make any entry in the tables but they can assign authority to staff members to do this tasks.
you can make a customer details and can include the fields like name, address , contact no.
you can add booking table.
in which you can include booking id, movie name, screen no, show timing, no of sheets, total cost
then you can add details regarding movie like movie name, date of release, star cast, language of the movie, category of the movie, type of the movie (like 2d or 3d) etc.
all the users have their unique username and password to login in the database.
user can insert , update and delete his information and can book and cancel tickets.
the staff members can book tickets for customers and they can insert and update the details but they can't delete. also staff members can also update and insert the details of themselves.
the management person or you can say chair person can view the daily collection, weekly collection, monthly collection and other reports. but staff members and customers are not able to view these things.
I know I have mentioned the things which are very basic in real world but it is too much for you.
and it is just a rough idea what can we include in this type of system.
so just try to understand it and try to implement in your project. no need to include all the things because you are just at the starting level and it is so much for you.
Regards
Deepak
We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click
HERE to participate the survey.
