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 & C
- (B) A multi-valued attribute of an entity set
In 2NF:
- (A) No functional dependencies (FDs) exist
- (B) No multi-valued dependencies (MVDs) exist.
- (C) No partial FDs exist.
- (D) No partial MVDs exist.
- (C) No partial FDs exist.
________ can help us detect poor E-R design.
- (A) Database Design Process
- (B) E-R Design Process
- (C) Relational scheme
- (D) Functional dependencies
- (D) Functional dependencies
Build & Fix Model is suitable for programming exercises of _______LOC (Line of Code).
- (A) 100-200
- (B) 200-400
- (C) 400-1000
- (D) Above 1000
- (A) 100-200
What is the best way to represent the attributes in a large database?
- (A) Relational-and
- (B) Concatenation
- (C) Dot representation
- (D) All of these
- (B) Concatenation
What is the major drawback of using the RAD Model?
- (A) Highly specialised & skilled developers/ designers are required
- (B) Increases reusability of components
- (C) Encourages customer/client feedback
- (D) Both A & C
- (D) Both A & C
Designers use which of the following to tune performance of systems to support time- critical operations?
- (A) Demoralization
- (B) Redundant optimization
- (C) Optimization
- (D) Realization
- (A) Demoralization
RAD stands for.
- (A) Relative Application Development
- (B) Rapid Application Development
- (C) Rapid Application Document
- (D) Rational Application Document
- (B) Rapid Application Development
Which one of the following models is not suitable for accommodating any change?
- (A) Build & Fix Model
- (B) Prototyping Model
- (C) RAD Model
- (D) Waterfall Model
- (D) Waterfall Model
Which one of the following is not a phase of the Prototyping Model?
- (A) Quick Design
- (B) Coding
- (C) Prototype Refinement
- (D) Engineer Product
- (B) Coding