Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In this assignment, well practice working with one-to-many relationships in SQL. You may work in a small group on the assignment. Note that each group

In this assignment, well practice working with one-to-many relationships in SQL. You may work in a small group on the assignment. Note that each group member must submit individually and list the other group members in the SQL file comments. One to Many Relationships Suppose you are tasked with keeping track of a database that contain the best how-to videos on Power BI. In a single SQL script, with comments, follow these steps: Create a new database (schema) called "Video_Reviews". On the newly created schema, create one table to keep track of the videos. This table should include a unique ID, the title of the video, the length in minutes, and the URL. Populate the table with at least three related videos from YouTube, the Microsoft Power BI site, or other publicly available resources. Create a second table that provides at least two user reviews for each of at least two of the videos. These should be imaginary reviews that include columns for the users name (Luis, Sonya, etc.), the rating (which could be NULL, or a number between 0 and 5), and a short text review (Loved it!). There should be a column that links back to the ID column in the table of videos. Write a JOIN statement that shows information from both tables. Please note that creating the table and inserting records on each table must be done in SQL. Do not insert records using the MySQL interface, or from a CSV file (or any other file). All work must be performed as a SQL script.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Transact SQL Cookbook Help For Database Programmers

Authors: Ales Spetic, Jonathan Gennick

1st Edition

1565927567, 978-1565927568

More Books

Students also viewed these Databases questions