The goal of this exercise is to create a schema that matches the needs of our model to store data. From the preceding exercises, we already have the table
Products defined in the OrderingSystem database. So let's add the remaining tables:
Employeestable. Right-click on the Tables folder and select New Table…. A new tab opens with the table designer for the new table.
int. Right-click on the column and select Set Primary Key to make it the Primary Key of the table. Note that the Allow Nulls is automatically ...