Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

General discussion


Designing a table for a database.

By sasika99 ·

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!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums