sql coding in programming

Sql Coding in programming
topic: Sql Coding in programming
Your assignment will be scored on the following criteria. You will use the Weekly Solutions Submission Template to submit your assignment.

Use the mysqldump.exe command line tool to backup the data in your volunteer database.
To access the mysqldump.exe tool, start the MySQL command line tool.
Use the quit command to exit to the system command prompt.
Run mysqldump.exe and direct the output of the backup to an appropriately named file.
Create a new database and restore the database from the backup to the new database. Submit a screenshot to document the restoration of the data to a new database.
Write SQL CREATE TABLE statements and run them to create three new tables (ADDRESS, PHONE, AND EMAIL) to split out the contact information for your volunteers that is currently contained in the PERSON table.
Each table should have a unique primary key and foreign key constraint reference to the PERSON table.
Save your SQL statements to a text file using the MySQL tee command and document the process with screenshots.
After creating the new tables (in Step 2), write and run SQL to insert the relevant data for the volunteers in the new tables.
Save your SQL statements to a text file using the MySQL tee command and document the process with screenshots.
Modify the PERSON table using the ALTER TABLE statement to remove the columns for the data moved to the new tables.
Save your SQL statements to a text file using the MySQL tee command and document the process with screenshots.

Do you have a similar assignment that you would wish our expert writers to handle for you? Place an order with us on https://assignmentsproficient.com/ and expect the best grades and help from qualified writers

rubric for Sql Coding in programming

  A (4) B (3) C (2) D/F (1/0)
Focus: Purpose Purpose is clear Shows awareness of purpose Shows limited awareness of purpose No awareness
Main idea Clearly presents a There is a main idea Vague sense of a No main idea
  main idea and supported throughout main idea, weakly  
  supports it most of the paper. supported  
  throughout the   throughout the  
  paper.   paper.  
Organization: Well-planned and Good overall There is a sense of No sense of
Overall well-thought out. organization, includes organization, organization
  Includes title, the main although some of the  
  introduction, organizational tools. organizational tools  
  statement of main   are used weakly or  
  idea, transitions and   missing  
  conclusion.      
Organization: All paragraphs have Most paragraphs have Some paragraphs Para. lack clear ideas
Paragraphs clear ideas, are clear ideas, are have clear ideas,  
  supported with supported with some support from  
  examples and have examples and have examples may be  
  smooth transitions. transitions. missing and  
      transitions are weak.  
Content Exceptionally well- Well-presented and Content is sound and Content is not sound
  presented and argued; ideas are solid; ideas are  
  argued; ideas are detailed, developed present but not  
  detailed, well- and supported with particularly  
  developed, evidence and details, developed or  
  supported with mostly specific. supported; some  
  specific evidence &   evidence, but  
  facts, as well as   usually of a  
  examples and   generalized nature.  
  specific details.      
Research (if Sources are Sources are well Sources support The paper does not
assignment exceptionally well- integrated and some claims made in use adequate
includes a integrated and they support the paper’s the paper, but might research or if it does,
research support claims claims. There may be not be integrated the sources are not
component) argued in the paper occasional errors, but well within the integrated well.
  very effectively. the sources and paper’s argument. They are not cited
  Quotations and Works Cited conform There may be a few correctly according
  Works Cited to MLA style sheet. errors in MLA to MLA style, nor
  conform to MLA   style.. listed correctly on
  style sheet.     the Works Cited
        page.
Style: Sentence Sentences are clear Sentences are clear Sentences are Sentences aren’t
structure and varied in but may lack generally clear but clear
  pattern, from simple variation; a few may may have awkward  
  to complex, with be awkward and there structure or unclear  
  excellent use of may be a few content; there may  
  punctuation. punctuation errors. be patterns of  

 

 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"