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