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-06 : 17:17:25
|
| HiI am using Oracle 9i, working with the scott database and need to create and populate some tables for the following scenario: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.I have been asked by a colleague to help them with this, as I have come into this blind and am using your forum as a last resort. I would be ver so grateful if someone couldd assist with the syntax, code etc for this as it woul dhelp me for furture queries of this nature.Please any help would be greatly appreciated.Thanks. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-09-06 : 19:11:53
|
| Shouldn't that be the Scottish database?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-09-06 : 19:49:16
|
| But one should never mention the name of the Scottish database |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-09-07 : 01:36:34
|
| the scott schema in oracle is equivalent to pubs/northwind in SQL Server. It is just a test schema.I would recommend posting your PL/SQL questions at www.dbforums.com in their Oracle section. best of luck.-ec |
|
|
|
|
|
|
PL/SQL Query