Database Design_Topic 3_Formative

Importance of Normalization EXCEPT .....................

• To reduce storage redundancy

• To ensure that the anomalies occur

• To reduce data redundancy

• To ensure easy for record searching or finding

An attribute is functionally dependent on an attribute other than the primary key refers to ...............................

• Transitive Dependencies

• Functional Dependencies

• Normalization

• Anomalies

Relationship between the Primary Key and other non key attributes within a table refers to .........................

• Transitive Dependencies

• Partial Dependencies

• Normalization

• Anomalies

First Normal Form (1NF) refers to .......................

• No repeating group and primary key is identified.

• Relation is in 1NF and no partial dependencies.

• Relation is in 2NF and no transitive dependencies.

Second Normal Form (2NF) refers to .......................

• No repeating group and primary key is identified.

• Relation is in 1NF and no partial dependencies.

• Relation is in 2NF and no transitive dependencies.

Main components of ERD are ...............................

• Entity, Attribute and Primary Key

• Entity, Attribute and Relationship

• Entity, Cardinality and Primary Key

• Entity, Attribute and Cardinality

Third Normal Form (3NF) refers to .......................

• No repeating group and primary key is identified.

• Relation is in 1NF and no partial dependencies.

• Relation is in 2NF and no transitive dependencies.

Object of interest to the end user, represented by a rectangle, name is a noun and usually written in all capital letters.

These characteristics refers to ...................

• Entity

• Attribute

• Relationship

• Cardinality

Association between entities, In the Chen notation, represented by

diamond and name is an active or passive verb.

These characteristics refers to ........................

• Entity

• Attribute

• Relationship

• Cardinality

Cardinality in Chen's notation consists of the following EXCEPT................

• One to One (1:1)

• One to Many (1:M)

• Many to Many (M:M)

• Many to Many (M:N)