1

7

2

An exception is thrown

5

There are no functional dependencies

There are

no repeating groups

There

are no non-key attributes that are dependent on another non-key attribute

There are no non-key attributes that are fully

functionally dependent on part of  

primary key only

The

first column in the table;

One

column that uniquely identifies each record in the table and can be

autoincrement;

It’s

the same as Foreign Key.

One or more columns that uniquely identifiy each record in the table;

A column that can contain only unique values;

SELECT teacher.name, dept.name FROM teacher OUTER JOIN dept ON dept.id

SELECT teacher.name, dept.name FROM teacher JOIN dept ON (dept = id)

SELECT teacher.name, dept.name FROM teacher

LEFT OUTER JOIN dept ON (teacher.dept = dept.id)

SELECT teacher.name, dept.name FROM teacher, dept JOIN WHERE(teacher.dept = dept.id)

SELECT teacher.name, dept.name FROM teacher, dept INNER JOIN ON (teacher.dept = dept.id)

Primary key order

Arbitrary order

Clustered index order

Insertion order