The term attribute refers to a ……. of a table?

• A. Record
• B. Column
• C. Tuple
• D. Key

For each attribute of a relation, there is a set of permitted values, called the …….. of that attribute?

• A. Domain
• B. Relation
• C. Set
• D. Schema

Which of the following is a tuple-generating dependency?

• A. Functional dependency
• B. Equality-generating dependencies
• C. Multi-valued dependencies
• D. Non-functional dependency

The main task carried out in the ……. is to remove repeating attributes to separate tables?

• A. First normal form
• B. Second normal form
• C. Third normal form
• D. Fourth normal form

Which of the normal form is based on multi-valued dependencies?

• A. First
• B. Second
• C. Third
• D. Fourth

Which forms have a relation that possesses data about an individual entity?

• A. 2nf
• B. 3nf
• C. 4nf
• D. 5nf

Which of the following has each related entity set its own schema and there is an additional schema for the relationship set?

• A. A many-to-many relationship set
• B. A multi-valued attribute of an entity set
• C. A one-to-many relationship set
• D. Both a & b

In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set?

• A. A many-to-many relationship set
• B. A multi-valued attribute of an entity set
• C. A one-to-many relationship set
• D. Both a & b

In 2NF:

• A. No functional dependencies (fds) exist
• B. No multivalued dependencies (mvds) exist
• C. No partial fds exist
• D. No partial mvds exist

……. can help us detect poor E-R design?

• A. Database design process
• B. E-r design process
• C. Relational scheme
• D. Functional dependencies