Unformatted text preview: Â∙ Microsoft Access uses metadata Â∙ Metadata is data about data Â∙ A database allows you to have multiple indexes Â∙ In a database it doesn't matter what the order is in the file. Primary Key- Uniquely identifies each row/record in a table Foreign Key- Connects a row in one table with one or more rows in another table. A table can have 0, 1, or many foreign keys. A record from the customer table can be related to 0 or many records in the order table One order can be related to one and only one customer (minimums on the inside and maximums are on the outside)....
View Full Document
This note was uploaded on 08/15/2011 for the course ACIS 1504 at Virginia Tech.