I just want to maintain data like an employee can belongs to
3 or more departments . We can resolve this by using
composite key but it avoids normalization rules. So Can
anyone tell me how can I maintain data.
- 0 Answers
- 1690 Views
- IBM, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
How to create an oracle testing table?
What is meant by joins?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
How to put more than 1000 values into an oracle in clause?
How to find out what privileges a user currently has in oracle?
How to retrieve first and last records from a table?
12. Display the client name in upper case only and in lower case only.
What is where clause in oracle?
Can group functions be used in the order by clause in oracle?
What are the Limitations of a CHECK Constraint ?
Oracle General 
