Question

Part II: Give the exact SQL syntax for the following (use the included table where necessary). 5pts ea. MEDIA TABLE FILE NAMES FILE LOCATION FILE ORDER DBS130.mkv -Desktop DBS131.mkv -Desktop 2 DBS129.mkv - Desktop null 11. When is a composite key necessary? 12. How do I change a column's name and data type in the above table? 13. How do add a column to the above table? 14. Select an from the above table in the following order: 3rd column followed by Ist followed by 2nd?(Any row(s) of your choice.)

Answer 1

column is used to specify 11) it refers to cases where more than one the primary key of a table at there we don't need Composite key FILE_NAMES boston Here primary key 12) ALTER TABLE MEDIA-TABLE A ALTER COLUMN COLUMN NAME: Datatype ; ibbon 13) ALTER TABLE MEDIA-TABLE ADD column_name datatype; 14) select FILE-ORDER, FILE NAMES, FILE_LOCATION from MEDIA_TABLE In 12, 13 Question column name they haven't given in Question, so I kept column name datatype