Help! What is Scott.Bonus?

[chrisrlong]

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?????


Thanks in advance,

- Chris

[pando]

No clue since the table containts redudant data and I cant see which column can be a PK to start with :D

[chrisrlong]

Lovely, isn't it?

[chrisrlong]

Come on guys and gals, *somebody* out there has to have a clue about this one.

PPPPPPllllllllleeeeeaaaaaaassssssseeeeeeeee :)

- Chris

[maachan]

Here's something out of 'Oracle: A Beginner's Guide' from Oracle Press. (pages 191-192)

CREATE TABLE bonus (
emp_id number(4),
emp_class varchar2(2),
fac_id varchar2(3), -- factory Id
bonus_amt number);

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.

[chrisrlong]

Hey, thanks for the effort.

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!!
***********************************

Thanks,

- Chris

[LND]

"this is there 'example' database that they use to teach people their product. "

look into designer/2000 repository:
select table_name, count(1) from user_tab_columns group by table_name order by 1 desc

So, it is the same story as with GOTO operator: not for beginers, only for experienced programmers.

[chrisrlong]

Sorry, but I have no clue what you just said :)

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!!
***********************************

Thanks again,

- Chris

[DcsoBob]

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.

[LND]

ok, the some statistics about designer/2000 - this is comercial product intended to help develop good db's. Lets look into the product itself:

table: SDD_ELEMENTS
no of columns: 184

some column names:
EL_2ND_WITHIN_ID
EL_2ND_WITHIN_NAME
EL_3RD_WITHIN_ID
EL_4TH_WITHIN_ID
EL_5TH_WITHIN_ID
EL_6TH_WITHIN_ID
EL_7TH_WITHIN_ID
EL_8TH_WITHIN_ID
EL_9TH_WITHIN_ID

EL_USRX0
EL_USRX1
EL_USRX2
EL_USRX3
EL_USRX4
EL_USRX5
EL_USRX6
EL_USRX7
EL_USRX8
EL_USRX9
EL_USRX10
EL_USRX11
EL_USRX12
EL_USRX13
EL_USRX14
EL_USRX15
EL_USRX16
EL_USRX17
EL_USRX18
EL_USRX19


any more questions?
But damn, I understand those developers.