Re: Database design
Heya all, I am new to this. Just up to the 2nd chapter but still dont have a clear understanding on how to design the database we want to create. If anyone can suggest how to, that would be great.
I would like to create a database of, E.g. suppliers of pens. So far I have created one database with all the contact details of all the suppliers. I believe that the next step is that I should be creating a second database of all the type of pens available. Then link all the suppliers to the particular pens that they stock. Pricing or availability of the item is not necessary.
The end result would be that I would be able to type in a search form the name of a particular pen and up come all the suppliers that supply that pen with a list of the other pens they sell as well.
This is basically it. Can anyone suggest what to do with this database or even suggest where I may see a database similar to this for my viewing.
Thanks for your support.
So far great book.