Almost embarassed to ask this but here it goes...
Need to create a database, which will store employee, manager and department. Could someone please help me in creating these tables and their relationships. Looking for something efficient and simple...where this employee works in this department, managed by manager.
Thank you.
May be you should use a simpler product like MS Access to see how you can create these tables and establish relations between the tables.|||hi,
perhaps you can have a look at http://www.databaseanswers.org/data_models/hr_intro.htm..
the Microsoft database sample AdventureWorks include a human resource implementation as well.. you can see/download the diagram at http://www.microsoft.com/downloads/details.aspx?FamilyID=0f6e0bcf-a1b5-4760-8d79-67970f93d5ff&DisplayLang=en
regards
