In this assignment you will create a video illustrating how to create and use a many-to-many relationship in SQL Server.
Your job is to implement the many-to-many relationship in your database on our SQL Server instance and make a video (with narrating audio in your voice) of yourself doing it. Be sure to demonstrate your foreign key constraints by adding data as necessary.
The video must include demonstration and narration of:
Creating the data tables, including a primary key, natural key, and at least one other attribute. Creating the intermediate table with two foreign keys. Adding data to all the tables and demonstrating how the intermediate table works. Demonstrating On Delete/Cascade and On Update No Action situations.
Use the naming conventions specified in Course Documents on Canvas.
You get to pick the subject of your tables. Pick a relationship that is reasonably reasonable in the real world.
Publish your video on YouTube and submit a link to BB. Do not upload your video to Canvas. I will watch your video and observe your tables in SQL Server.
The video should be no longer than 5 minutes: I will stop watching at that point. 5 minutes is sufficient time to make your points and demonstrate your work.
Database Naming Conventions
0. Do not use spaces in your symbol names. Ever. Spaces are for civilians.
1. Tables have a't' prefix
2. A table name represents the contents of one row in the table. The table name is not plural. For example, tEmpl is the Employee table. Empls is incorrect.
3. Queries have a 'q' prefix in Access. For example, tEmpl would be a query based on the table called tEmpl.
Students succeed in their courses by connecting and communicating with an expert until they receive help on their questions
Consult our trusted tutors.