Create table, primary key, foreign key, and subquery in Microsoft SQL Server Management Studio HD

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).