Good afternoon, This is my first post on that list, I was looking for relational database mailing list, and found none. So I will post my question here since my database will be under mySQL and users on this list probably have good experiece with DB design.
I designed my database, and before all coding the interface, I'd like some experts to have a quick look to it to at least tell me if there are major mistakes in the design. I read "Database design for mere mortals" a little while ago and this is my first attempt in a real-world and complex (well compared to what I done before) DB. I attached an image copy of the file made with Visio. Visio is made for Access, I managed to get the primary and foreign keys to be as my original sketches (playing with weak and strong tables and identifying or not links) So for the ones interested in my structure, let me know any questions you may have regarding the way everything works and any comments you have. Thanks a lot, Etienne -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
