Explain about functional dependency and its relation with table design?
List out the difference between commit, rollback, and savepoint?
9. Display the client name and order date for all orders using the JOIN . . . USING method.
Who developed oracle & when?
Describe Referential Integrity ?
What is set operator oracle?
what is a Nested Loop join?
What is a database table in oracle?
How to create an oracle database?
What happens in oracle commit?
How to bring a tablespace online?
How to use in conditions in oracle?
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.