Hi im new to this forum but im hoping you guys can help.
I am tryign to create a database which stores Businesses details within it.
Along with them details the staff within a particular business.
I have 4 tables.
businesses (Stores business name,address, telephone, type of business etc)
businessCategories (Stores different types of businesses eg. Garage, Nursing home etc)
businessesStaff (Stores name, address and other personal details on staff members within the businesses)
and finally ... businessRegister (Stores the usernames, passwords for logining on to the website and being abel to edit the businesses table and there account).
Im just a little confused on how to go about the relationships, I have made one already "one-many" relationship between "biz_category" in the businesses table to the "cat_id" field in the businessCategories table.
Is this correct? Any suggestions on my other realtionships?
I have included a screen shot and a copy of my database file to date.