Question: Need help with assignment ,?. A- 1,-.12. el- |||Heading T? Normal 1N0 Spac Heading 1 Heading 2 Paragraph Styles ASSIGNMENT 2 - CREATING SCRIPTS Assignment
,?. A- 1,-.12. el- |||Heading T? Normal 1N0 Spac Heading 1 Heading 2 Paragraph Styles ASSIGNMENT 2 - CREATING SCRIPTS Assignment Points: 40 Create a script that will do the following. 1. Create table scripts for each table in one of the databases (TAL Distributors, Colonial Adventure Tours or Solmaris Condominium Group) 2. Generate insert statements for each table based on CSV files that are generated from Mockup Data. 3. Commit the changes 4. Create empty tables like the tables m #1 but append-NEW" to the table. ic: customer and customer new 5. Insert data from tables in #1 to tables generated in #3] 6. Commit the changes 7, Delete all the tables in #1 and #4. 8. Commit the changes 9, Drop all the tables that were created in #1 and #4 so- wil e a??????@
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
