Hints and tips for homework due Sept 10

1. For addding the extra employees, customers, and parts I manually cut/paste a bunch of insert statements as shown here. If you use my file, add more variety, e.g., all the customers live at the same address & have the same phone number, all the parts cost the same, and all the quantity on hand (qoh) and order levels (olevel) are the same!
2. To add more orders and order_details, I wrote two stored procedures and a PL/SQL anonymous block.
1. To help with debugging, two additional tables are used as shown here.
2. Stored procedure add_order
3. Stored procedure add_order_detatils
4. PL/SQL anonymous block here
3. Copy the above files to a working directory in your acount and "start" the files in order.
4. The above could be adapted for problem 2.2, but I haven't tried it.
5. Grant the course TA, Eric Albert (ealber_1) select privileges on the appropriate tables
1. grant select on your_schema.your_table_name to ealber_1;