Hi,
Im designing a database for an order management system for a school project and had a problem with one thing. I have two sets of employees on my employee table, OfficeStaff and Workers. Workers need to have an attribute to say in which WORKAREA they work in, and this attribute isnt required for OfficeStaff. So i need to know how i would go about designing this on my Employee table. If i include a WORKAREA column on the table it would have a NULL value for the OfficeStaff since they dont work in a WorkArea. Should i include another table to assign all the Workers to WORKAREAs?
Also, all the employees’ have a Department that they are assigned to (for example: Manufacturing/Administration/Sales etc).
Please provide some advice, thank you!
Sasika.
