Tag: databases

Product - Many Manufacturer - Many

Product - One or Many Manufacturer - One or Many

Product - Many Manufacturer - One

Product - One Manufacturer - One

Product - One Manufacturer - Many

The right table will return ALL rows

The right table will return NULL

Both tables will return NULL

The left table will return ALL rows

The left table will return NULL.

Structure

Design Issue

Data Source

Storage Issue

Operational Process

Command is used to delete all the rows of the table.

Command is used to delete complete table structure.

Command free the space used by the table.

Command deletes all the constraints,relations and previleges with other tables

Primary key constraint creates clustered index by default.

Unique key constraint creates clustered index by default.

Primary key constraint allows null values.

Unique key constraint allows null values

Data about Data

Describes a data dictionary

Self-describing

Includes user data

True

False

True

False

True

False

True

False