Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Kamlee
Starting Member
6 Posts |
 Posted - 2004-09-07 : 05:40:18
|
| HiI am using the Scott database in Oracle 9i, and need to create and populate some tables. I have been asked by a colleague to help them to do this, and it would be good to know how it can be done. The scenario is:The set of functional dependencies F = {AB „_C, C „_ A} exist on a relational schema R(A, B, C). Such a relation is in Third Normal Form but not in BCNF. However, a decomposition to BCNF relations R1(C, A) and R2(B, C) has well-documented problems. By creating and populating tables corresponding to R1 and R2 use PL/SQL to ensure that no update or insert anomalies can take place.If someone could please advis me on the coding, syntax, layout of how to satisfy this query it would be very helpful. I am using this forum as a last resort as have been banging my head against a brick wall about this for the past week.Anybody, please help!Thanks. |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-09-07 : 05:42:27
|
| DUPLICATE postings don't get solutions any faster. If we don't have the knowledge....we don't have the knowledge. You are asking quite a specialist question. |
 |
|
|
|
|
|
PL/SQL Query