peterbowles
Registered User.
- Local time
- Today, 14:43
- Joined
- Oct 11, 2002
- Messages
- 163
I am going to produce a database for my final year project any one get any good ideas
Dissertation
- Thread starter peterbowles
- Start date
Newman
Québécois
- Local time
- Today, 09:43
- Joined
- Aug 26, 2002
- Messages
- 766
I did a show ticket booth.
The customer can choose a show from a list.
(There is many shows for many theatre.)
Then there is a map of the corresponding theatre with the seats in colours to represent the price of the section for that show. (Should be diffrent for every shows). There is also a colour for sold out seats.(DataGrid...Chalenging!)
He click on the seats he wants and get a receipt.
The manager can enter, with a password to add or remove a show.(Got to consider that there is only one show at a time in a theatre, but there could be more than one the same day with different hours.) The manager gives each new show one or many theatres, choose the price for the seats for that specific show. Put different prices depending on the day of the week or the time of the presentation. (ex.: half price for Tuesdays and 20% off on morning presentation [except on tuesdays].)
You need a form as an entry (where the customer choose the show and the manager enters his password), one with the datagrid for the customer and one for the manager's datas. A report for the customer's receipt and some for the management. (percentages, graphics, ...)
You need tables for the shows, theatres, sections seats, customers, ...
Its a good chaleng! Especialy if you never learned datagrids.
Good luck!
Don't forget to tell us what you choose, and come back if you need some help!
The customer can choose a show from a list.
(There is many shows for many theatre.)
Then there is a map of the corresponding theatre with the seats in colours to represent the price of the section for that show. (Should be diffrent for every shows). There is also a colour for sold out seats.(DataGrid...Chalenging!)
He click on the seats he wants and get a receipt.
The manager can enter, with a password to add or remove a show.(Got to consider that there is only one show at a time in a theatre, but there could be more than one the same day with different hours.) The manager gives each new show one or many theatres, choose the price for the seats for that specific show. Put different prices depending on the day of the week or the time of the presentation. (ex.: half price for Tuesdays and 20% off on morning presentation [except on tuesdays].)
You need a form as an entry (where the customer choose the show and the manager enters his password), one with the datagrid for the customer and one for the manager's datas. A report for the customer's receipt and some for the management. (percentages, graphics, ...)
You need tables for the shows, theatres, sections seats, customers, ...
Its a good chaleng! Especialy if you never learned datagrids.
Good luck!
Don't forget to tell us what you choose, and come back if you need some help!
Autoeng
Why me?
- Local time
- Today, 09:43
- Joined
- Aug 13, 2002
- Messages
- 1,302
A message for Newman
I am very interested in learning more about datagrids. Is there any good sources that you can recommend. We are a manufacturing facilty that locates parts to the production line based on a line, rack, shelf location numbering system. This works great for finding and locating a part but when you want to add a new part to a particular rack you really have no way of knowing what locations are empty becasue the bin sizes might make a shelf hold 16 bins or only 2 bins and you never know which. What I would like to do is create datagrids for every rack and located the appropriate sized bins on the rack so that you can tell if a space is empty and if the bin size you are locating will fit. Can it be done easily (the setup of the datagrids I mean) because I would like to create the database then turn it over to the users.
Thanks,
Autoeng
I am very interested in learning more about datagrids. Is there any good sources that you can recommend. We are a manufacturing facilty that locates parts to the production line based on a line, rack, shelf location numbering system. This works great for finding and locating a part but when you want to add a new part to a particular rack you really have no way of knowing what locations are empty becasue the bin sizes might make a shelf hold 16 bins or only 2 bins and you never know which. What I would like to do is create datagrids for every rack and located the appropriate sized bins on the rack so that you can tell if a space is empty and if the bin size you are locating will fit. Can it be done easily (the setup of the datagrids I mean) because I would like to create the database then turn it over to the users.
Thanks,
Autoeng
