Database Design | MCQs

Explanation

The third stage in designing a database is analyzing our tables more closely and creating a between tables.

Explanation

A super key is a set of one or more attributes (columns), which can uniquely identify a row in a table.

Explanation

Explanation

An integer  that can be positive, negative, or zero.

Explanation

A primary key must be unique for each record and never change.

Zip code is not unique (many people can share the same zip code), so it's not suitable as a primary key.

Explanation

In an Entity-Relationship (E-R) diagram, a rectangle represents an Entity.

Attributes are shown as ellipses.

Relationships are shown as diamonds.

Explanation

Table in database must have a primary key.

Explanation