This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Need help on creating tables for a simple scenario

 
Rajesh Khan
Ranch Hand
Posts: 230
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Here is the scenario a company has a no of employees however some of those employees could be working for multiple companies having one to many relationships.
How would i describe them so far i only have two tables Employees_Info (containing employees details) and company_info(containg company deatails) how can i affiliate an employee with a company considering the fact that an employee could be working for multiple companies.

Employees_Info table:
ID|Name|Salary|Hours|designation

company_info table:
ID|Company_name|Employees_No

Now what changes should i make so that i can affiliate an Employee with multiple companies any ideas suggestions??
 
Wendy Gibbons
Bartender
Posts: 1107
Eclipse IDE Oracle VI Editor
  • 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
what you have is a link table, with an employee id and company id.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic