X hits on this document

PDF document

“Beginning Visual C# 2005 Express Edition Video Series” - page 67 / 73

193 views

0 shares

0 downloads

0 comments

67 / 73

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



Document info
Document views193
Page views193
Page last viewedFri Dec 09 10:37:39 UTC 2016
Pages73
Paragraphs821
Words15988

Comments