Okay, as part of a document I'm writing, I am basically dissecting the default SCOTT/TIGER schema provided by Oracle. The problem is that I can't find any documentation on it. With a well-designed schema, this would not be a problem. I have to say, however, that what they provide as an example for others to follow is perfectly disgraceful. Basically, I have absolutely no idea what the BONUS table is supposed to store, especially since the one they provide is blank (nice, eh?).
Anyone out there have any insights or links for me?????
Insert into bonus values (123,null,'AE',2000);
Insert into bonus values (124,null,'AF',2200);
Insert into bonus values (125,null,'AH',1200);
Insert into bonus values (126,null,'AH',1200);
Insert into bonus values (127,null,'AF',1200);
Insert into bonus values (128,null,'AT',1500);
Insert into bonus values (129,null,'AT',1100);
Insert into bonus values (130,null,'AU',1400);
Insert into bonus values (131,null,'AE',200);
Insert into bonus values (132,null,'AF',220);
Insert into bonus values (133,null,'AG',120);
Insert into bonus values (134,null,'AG',200);
Insert into bonus values (135,null,'AG',200);
Insert into bonus values (136,null,'AU',1400);
Insert into bonus values (137,null,'AH',100);
Insert into bonus values (138,null,'AU',1400);
The book uses this data to show how to create reports.
Unfortunately, that bonus table does not match the structure of the bonus table in the default SCOTT schema.
The SCOTT.BONUS table looks like:
BONUS
-EMPNO
-JOB
-SAL
-COMM
What's odd is that there is no PK and the EMP table already has all 4 of these columns.
What I can glean from the various SQL examples in the document is very little. The only use for the table I can find is when they search it for employees that have bonuses. Basically, simple existence in the table signifies you got a bonus. How much or why we don't know. We also don't know why this isn't just a flag in the EMP table, or why we have these other 3 fields in there, or why there is no PK.
Sorry for the rant, but I just think it is so ridiculous that this is there 'example' database that they use to teach people their product.
Again,
***********************************
Any and all help would be appreciated!!
***********************************
Yes, it is the 'example' database that I am asking about
I don't use Designer/2000 so I don't have such a repostory. Even if I did, the best that SELECT would give me is the table name. Since I already have the schema, I already have access to all the table and column names. What I'm asking about is the logical reasoning behind the design of the table:
- What purpose does it serve?
- What data is each of the fields supposed to hold and why?
From the design of the table, I am left with:
- Why is there no PK?
- Why does it only have 4 fields that are already in the EMP table?
- If it is a M:1, then where is the new info
- If it is 1:1, then where is the new info
- If these fields are not meant to hold the same values as they do in EMP, then what data are they supposed to hold?
- As it is called BONUS, where is the monetary information for said bonus?
Again,
***********************************
Any and all help would be appreciated!!
***********************************
Hi. You get the dubious honor of being my first reply on this board ( I just joined the site this morning). Anyway, I am still very new to this and going through the classes. Seems to me that I remember the instructors having to run some scripts(supplied by oracle) to creat and populate that training db (emp, dept, bonus, etc). Just what I overheard them talking about.
Reply With Quote
Bookmarks