Central Texas University Creating and Managing Views Databases Questions

Answer these questions based on your reading and the walkthrough activities above

You’re creating a view named USA_Artists. The view is based on the ARTIST_NAME column and the PLACE_OF_BIRTH column of the ARTISTS table. The view column names will be the same as the table column names. What SQL code should you use to create the view?

You’re creating a view based on the COMPACT_DISCS table in the INVENTORY database.  You want the view to include only those rows whose value in the LABEL_ID column is 546.  What clause—in addition to the SELECT clause and the FROM clause—should be included in the SELECT statement for the view?

1. You’re creating a view, named INSTOCK_LABELS, that references the COMPACT_DISCS table and the CD_LABELS table. The data in the two tables is matched together by the LABEL_ID column in each table.  Make sure to show these columns:  COMPANY_NAME, CD_TITLE, IN_STOCK.  Include the with check option.  Write the statement that creates the view.   Explain the success or challenge you faced doing so.  If there is a challenge, how did you make it a success?
2. You want to use the INSTOCK_LABELS view to change the LABEL_ID #832’s company name to ‘MCA Entertainment’. Write the statement that update those rows in the view.   Explain the success or challenge you faced doing so.  If there is a challenge, how did you make it a success?
3. here is the questions attached to the projectDownload and complete this worksheet >> course project worksheet (Links to an external site.)Deliverables, submit as directed in the worksheetThe worksheet as a docx file (350 pts)The corrected database schema script as a txt file (100 pts)The create and insert statementsThe scripts as a txt file (100 pts)The scripts that answered the questions