database concepts

Using a database: creating tables

Invoice schema

In the scheme for the INVOICE database:

• primary keys are represented by a solid underline
• foreign keys with a dotted underline
• referential integrity is represented by an arrow from the foreign key in the child table to the primary key in the parent table.