Anyone here knowledgeable in SQL?

Discussion in 'General Off-Topic Chat' started by Shadow_Boss, Nov 25, 2013.

  1. Shadow_Boss
    OP

    Shadow_Boss Advanced Member

    Newcomer
    57
    1
    Dec 19, 2011
    Canada
    my professor assigns us an assignment saying to write a script and he says:

    - CREATE A COLLECTION
    - CREATE ALL THE TABLES FROM ASSIGNMENT 1 SOLUTION UPLOADED
    - ADD THE PRIMARY KEYS AND FOREIGN KEYS TO THEM
    - INSERT (MINIMUM OF 3 RECORDS) TO EACH TABLE
    - UPDATE AND DELETE (MINIMUM OF 1 RECORD) FROM EACH TABLE

    he's never used the term COLLECTION before...and he's taking forever to respond to emails.


    how the hell do I create a collection? what is a collection? IBM's website's description made it sound like a library where you add tables packages etc....

    so would i do something like this in a DDL script


    CREATE COLLECTION ASSIGN1 (

    CREATE TABLE VENDOR (

    CompanyName varchar(255) NOT NULL,
    Address varchar(255) NOT NULL,
    City varchar (255) NOT NULL,
    );

    );


    does that make any sense lol ? if anyone could help I'd greatly appreciate it
     
  2. Shadow_Boss
    OP

    Shadow_Boss Advanced Member

    Newcomer
    57
    1
    Dec 19, 2011
    Canada
    can someone delete this thread please? I got my answer