A) Domain
B) Relation
C) Set
D) Schema
Lecturer Computer Science 2017
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 has a relation that possesses data about an individual entity?
A) 2NF
B) 3NF
C) 4NF
D) 5NF
Advertisements
Which of the following has each related entity set has 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
Build and fix model is suitable for Programming exercises of ……. LOC (Line of Code)?
A) 100-200
B) 200-400
C) 400-1000
D) Above 1000