MTA Databse 1.0

Primary Datafiles have this extension

These speed up searches in a table

Secondary data files have this extension

Transaction Log Files have this file extension

A shopping list would be this type of database

• Flat Type

• Hierarchial

• Relational

This type of database has a parent that can have multiple child tables

• Flat

• Hierarchial

• Relational

This type of table can have child tables with multiple parent tables

• Flat

• Hierarchial

• Relational

This acronym defines the 4 basic functions of a databse

A blank database entry in called a

All of the following are constraints except

• Unique

• Check

• Default

• Not Null

• Self Reference