The lines that connect each of the tables are called Relationships. We’ll talk about them more in a bit. There’s another way to view the structure of a table in a database:
This is called a Design View. A table has columns and rows. It might be easy at this point to think of a table as a spreadsheet, like the type you use in Microsoft Excel. The columns are the structure of the table. The columns define WHAT type of information will be saved in that table. In this case, the Customers table has a structure of 11 columns (CustomerID, CompanyName … Fax) A single customer in the Northwind database will have one row of data in this table. A row represents a collection of fields of information that are related together conceptually. The Design View (above) allows you as the database designer to add or remove columns from a table.
Supplemental Readings for the Express Edition Videos Copyright © 2005 LearnVisualStudio.NET