CIS 336 DEVRY Course Material - cis336dotcom

CIS 336 DEVRY Course Material - cis336dotcom

CIS 336 Week 7 iLab 7 Devry University (Devry)

For more course tutorials visit
www.cis336.com

STEP 5: Insert two new publishers into the PUBLISHER table, one named Double Week with a contact name of Jennifer Close at 800-959-6321, and the second one named Specific House with a contact name of Freddie Farmore at 866-825-3200. Use your new sequence to create the PUBID for each record. Now, query your PUBLISHER table to see your two new records. STEP 6: Using a single query, query the PUBNUM_SEQ to determine what both the current sequence number is and the next sequence number will be. STEP 7: Create a unique index on the combined columns ORDERID and CUSTOMERID in the BOOK_ORDER table. Give the index a name of BOOK_ORDER_IDX. STEP 8: Determine how many objects you currently own in your schema by querying the USER_OBJECTS view in the Data Dictionary. Your result set should list the different object types that you find and include a count by object type.

........................................................................................................................................................................

CIS 336 Week 6 Group Project Task 4 (Devry)

For more course tutorials visit
www.cis336.com

To submit this task, create a heading called MODIFY STATEMENTS in your group project SQL script, and name the file TEAM_X_TASK4.TXT. This should be the same script that contains your DROP TABLE, CREATE TABLE, and INSERT statements. Once you have verified that your SQL statement or statements work, create a spooled output showing the results of your statements.
Deliverables for this task:
Any revisions of task 3 based on feedback from your instructor. Task 4 comprised of the complete script file (DROP, CREATE, INSERT, SELECT, and UPDATE statements) and the output file showing that it works. Team member responsibilities document outlining contributions by team member to this deliverable....

Similar Essays