Tech.Note.Database.linking

Tech.Note.Database.linking - Multi-Table Databases /...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Multi-Table Databases / “Linking” Tables The solution to most database problems involves more than one table. Typically, the data in the different tables is related. This relationship is implemented by a set of linking keys. To return to our example, suppose that we want to keep information about the various manufacturers of model trains. We could set up a table that has info for each manufacturer, and link them together by common key. Here we are building a second table in our database using design view. This time we have identified six pieces of information that we want to keep about the model train manufacturer: Links between tables are accomplished by special fields called “key” fields. Since we intend to use the same manufacturer identification in this table that we used in the model cars table, manufacturer would make an excellent primary key field. You accomplish this by selecting the row and then clicking on the key symbol in the tool bar:
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Now we can add some data to the manufacturer table:
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/22/2010 for the course BUS 255 taught by Professor Mcgee during the Spring '10 term at Aarhus Universitet.

Page1 / 6

Tech.Note.Database.linking - Multi-Table Databases /...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online