Create a new database (schema) called “Video_Reviews”.

Words: 291
Pages: 2
Subject: Uncategorized

One to Many RelationshipsSuppose 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 user’s 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.

Let Us write for you! We offer custom paper writing services Order Now.

REVIEWS


Criminology Order #: 564575

“ This is exactly what I needed . Thank you so much.”

Joanna David.


Communications and Media Order #: 564566
"Great job, completed quicker than expected. Thank you very much!"

Peggy Smith.

Art Order #: 563708
Thanks a million to the great team.

Harrison James.


"Very efficient definitely recommend this site for help getting your assignments to help"

Hannah Seven