Help! What is Scott.Bonus?
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: Help! What is Scott.Bonus?

  1. #1
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339

    Question

    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

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    No clue since the table containts redudant data and I cant see which column can be a PK to start with :D

  3. #3
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Lovely, isn't it?

  4. #4
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Come on guys and gals, *somebody* out there has to have a clue about this one.

    PPPPPPllllllllleeeeeaaaaaaassssssseeeeeeeee :)

    - Chris

  5. #5
    Join Date
    Jan 2000
    Location
    Silver Spring MD USA
    Posts
    105
    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.

  6. #6
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    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

  7. #7
    Join Date
    Nov 2000
    Posts
    212
    "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.

  8. #8
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    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

  9. #9
    Join Date
    Feb 2001
    Posts
    99
    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.

  10. #10
    Join Date
    Nov 2000
    Posts
    212
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width