This content has been marked as final. Show 3 replies
i had similar issues in my brain when i did my first database design.
well that was long time back.
I am no expert in this subject to give u suggestions.
well I can be a fall back mode, if no suggestions got then u can safely use mine.:)
Now Yes ADDT really wont directly help u in multiple linked tables..
u need to sit and think a strategy of how users will interact with ur web interface.
1.> yes anything that repeats we keep in separate table.
2.> we link it with some unique key to its parent/master/ whatever....
sometimes we do self links.
now ur question about handling mutiple tables links..
it gets not so easy with plain ADDT .
it get time for u start using stored procedures and custom forms of ADDT.
wherein u can call a function/ procedure stored in database which does all the house keeping into various tables.. for u in one go.
there are many things which i cannot explain u in one post.
i believe u should read a little more about best practices of database design
hope this helps.
Try checking out www.erdlibrary.com - they have loads of database designs including a couple for online shops. They also have related database designs for stock management, CMS systems, user systems etc..
Try checking out www.erdlibrary.com - they have...
it shouldn´t read "they have" -- it should actually read "we have" or "I have", because a) it´s apparently your own company, as your forum account´s registered email address (contact@...) does relate to this company, and b) the erdilibrary website has a link to another website which contains the name "limetree-software".
I will not delete or edit your post, as it´s not completely out of context and possibly *might* help some users, but you may rest assured that further attempts to advertise your company´s offerings in these forums will not be tolerated.
Adobe Community Expert, Dreamweaver