I have to do a database for each course because each course has different rates for each day and time.
>First, I think you might consider that the database schema you have here is >not very good. You're going to have a separate database table for every >course? Why would you do this? A much better option would be to have a table >of courses, with course IDs, and another table with times and dates that >link to a course via a foreign key. If any of this sounds unfamiliar to you >I'd urge you to stop right now and read a book or some web tutorials on SQL >and database design, because not only is the critical knowledge to have as a >developer, it is critical to creating a maintainable database structure for >this application. > > > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285901 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
