I have the attached database diagram and relations for the backend of my tradesman web site. The concept is that a potential trader will navigate to my web site and insert their name, address etc along with their trade and trade type into my database through a frontend GUI, i.e. Joe Bloggs, 1 Microsoft Way etc, Builder, Houses. Do I have the right relations set up for this to work correctly? Should the relationship between my tblTrade table and tblTradeType table be a one to one relationship instead of a one to many as I do only want each trade for a specific trader to have one trade type? - Another aspect I must mention is that ultimately I am going to build another similar frontend that will insert data into the same database (within different tables obviously) but this frontend will be for customers and not traders. The customer will insert themselves against a trade and trade type (the work they require) chosen from two drop down boxes on my frontend that are populated from the tblTrade and tblTradeType tables respectively.
Any help appreciated.