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
    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
    1
    Dec 19, 2011
    Canada
    can someone delete this thread please? I got my answer
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice