O'Reilly logo

Start Here!™ Fundamentals of Microsoft® .NET Programming by Rod Stephens

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Relational Databases

Without getting too technical, a relational database contains tables that hold records. Each record holds fields containing data for that record.

For example, a test scores database might have a Student table. Each record holds the same data about a specific student: StudentId, FirstName, and LastName.

Different tables are linked by using common values in their fields. For example, the TestScore table would contain information about test scores: StudentId, TestNumber, and Score. In this example, the Student table’s StudentId field links to the TestScore table’s StudentId field. To find the scores for a particular student, you would look up that student’s Student record, find the StudentId, and then find all the TestScore records ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required