Central Texas University Creating and Managing Views Databases Questions

Description

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?

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?
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?
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



^{Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."}

Our Service Charter

1. Professional & Expert Writers: Eminence Papers only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Eminence Papers are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Eminence Papers are known for the timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Eminence Papers, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.