structured Query Language

Part 1

The Data Definition Language (DDL) is used to create and destroy databases and database objects. These commands will primarily be used by database administrators during the setup and removal phases of a database project.

Please respond to all of the following prompts:

• Discuss commands that are used to modify database tables (i.e., CREATE, INSERT, DROP).
• When would you want to use each of these commands?
• Compare and contrast the advantages of tables and views.
• Compare and contrast that advantages of tables and views.

Part 2

Goal: Using SQL, create a new table. Define each of its columns. Include at least one text and one numeric column.

·  Create a table using SQL:

·  Build a table of your favorite songs. Include the following:

• A song ID
• Name of the song
• The performer

 

Structured Query LanguagePart 1The Data Definition Language (DDL) is used to create and destroy databases and database objects.These commands will primarily be used by database administrators during the setup and removal phases of a database project.Please respond to all of the following prompts:Discuss commands that are used to modify database tables (i.e., CREATE, INSERT, DROP).When would you want to use each of these commands?Compare and contrast the advantages of tables and views.Compare and contrast that advantages of tables and views.Part 2Goal: Using SQL, create a new table. Define each of its columns. Include at least one text and one numeric column.Create a table using SQL:Build a table of your favorite songs. Include the following:A song IDName of the songThe performer

• 1495433954-sqlwk2.docx

ComputerScienceExpert

(11)

Status NEW Posted 22 May 2017 06:05 AM My Price 9.00

-----------

Attachments

file 1495433957-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer