How to create table, primary key, foreign key, subquery using Microsoft SQL Server Management Studio
This video demonstrates how to create two new tables: Customer_T and Order_T in a relational database. Then set the primary key (at 2:01). Then Insert new records (at 4:30). Then use the Designer option to allow changes made to existing table structure (at 6:35). Then add foreign key constraints to maintain the referential integrity (at 7:50). Then create a subquery to find information of the customer who placed order 1008 (at 8:56).