Re: Logic question

This WebDNA talk-list message is from

2002

It keeps the original formatting. numero = 43172
interpreted = N
texte = You need to design a relational system to handle this. Several interrelated tables, rather than a single table.Off the top of my head, you could have the following tables:People (name, address, credit card, people ID, etc.)Packages (cost, seat, packageID, etc)Theaters (Seats, Films, etc.)PurchasedPackages (peopleID, PackageID, theater, etc.)You could do a huge variety of reporting and processing from thesetables.Think about how the WebCatalog Orders, Lineitems, Products DB modelworks. That's a relational system. Hope this helps.>>> PatrickJ@vsm.net 09/05/02 03:58PM >>>Dearest members of the talk list -My feeble mind can't wrap around this project. I'll lay it out, andifsomeone can think of a good starting point, let me know please!We are hosting a film festival website. They would like to do onlineticketreservations (NOT sales). However, the spreadsheet they came up withrepresents about just under 73 trillion fields. Here are theessentials:There are 5 ticketing reservation TYPES: The Bronze, Silver Gold andPlatinum packages each represent a certain number of seats reserved forasingle movie in a single theater. The fifth type is individual ticketsales.All of the theaters have either 65, 75 or 100 seats available permovie.There are 5 MOVIES times 4 THEATERS each day for 20 movies.There are 9 DAYS of film festivities.They wish to track how many of each package was sold, and keep arunning tabof total ticket reservations for each movie (allotted and remaining),aswell as the total receivables (tickets are universally and blessedly$8).Other than creating a field for each package type, each movie, eachtheaterand each day...can this be done?Opinions, suggestions, remarks please.Patrick Junkroski-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail toWeb Archive of this list is at: http://search.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

Re: Logic question (PatrickJ 2002) Re: Logic question (John Peacock 2002) Re: Logic question (ROBERT MCPEAK 2002) Logic question (PatrickJ 2002)

You need to design a relational system to handle this. Several interrelated tables, rather than a single table.Off the top of my head, you could have the following tables:People (name, address, credit card, people ID, etc.)Packages (cost, seat, packageID, etc)Theaters (Seats, Films, etc.)PurchasedPackages (peopleID, PackageID, theater, etc.)You could do a huge variety of reporting and processing from thesetables.Think about how the WebCatalog Orders, Lineitems, Products DB modelworks. That's a relational system. Hope this helps.>>> PatrickJ@vsm.net 09/05/02 03:58PM >>>Dearest members of the Talk List -My feeble mind can't wrap around this project. I'll lay it out, andifsomeone can think of a good starting point, let me know please!We are hosting a film festival website. They would like to do onlineticketreservations (NOT sales). However, the spreadsheet they came up withrepresents about just under 73 trillion fields. Here are theessentials:There are 5 ticketing reservation TYPES: The Bronze, Silver Gold andPlatinum packages each represent a certain number of seats reserved forasingle movie in a single theater. The fifth type is individual ticketsales.All of the theaters have either 65, 75 or 100 seats available permovie.There are 5 MOVIES times 4 THEATERS each day for 20 movies.There are 9 DAYS of film festivities.They wish to track how many of each package was sold, and keep arunning tabof total ticket reservations for each movie (allotted and remaining),aswell as the total receivables (tickets are universally and blessedly$8).Other than creating a field for each package type, each movie, eachtheaterand each day...can this be done?Opinions, suggestions, remarks please.Patrick Junkroski-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail toWeb Archive of this list is at: http://search.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ ROBERT MCPEAK

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Press Release hit the NewsWire!!! (1997) Three new problems, maybe a fourth (1997) Interesting speed comparison .. (2003) price on detail, but not shoppingcart (1997) First postarg not taking in $Commands (1997) Formatting Email (2000) Webcatalog/Butler (1998) Installed 4.5 but indicates 4.50rc2 (2002) Concerning Emailer under Linux... does it exist? (2000) Secure server question (1997) access denied problem (1997) [WebDNA] Circumnavigate Browser Timeout On Lengthy WebDNA Operations (2014) frames & carts (1997) Searchable WebCat (etc.) Docs ? (1997) 2 easy questions re: [showif] and [sendmail] (1997) [searchString] (1997) Works! (1997) using showpage and showcart commands (1996) [OT] Funny (2004) Kanji in http requests (1998)