You did not answer this question. 

 Correct answer is  (d)  

 Your score on this question is: 0.00  

 Feedback: 
   
See section 3.3.1, subsection "Functional Dependencies," in the course notes.
 
 

--------------------------------------------------------------------------------

 4. 
 Which of the following is a property (are properties) exhibited by good relational schemas?

The use of null values in tuples 
The grouping of as many attributes as possible into one main table 
The elimination of data redundancy to avoid update anomalies 
 
 

  (a) III only
 (b) II and III only
 (c) I and II only
 (d) None  

 You did not answer this question. 

 Correct answer is  (a)  

 Your score on this question is: 0.00  

 Feedback: 
   
See section 3.3.1 in the course notes.
 
 

--------------------------------------------------------------------------------

 5. 
 Which of the following statements concerning normal forms is true?  
 

  (a) Schemas that are in second normal form are considered the best.
 (b) Each normal form contains a state of independent properties, unrelated to other normal forms.
 (c) A relation that is in second normal form is also in first normal form.
 (d) The lower the normal form number, the better the schema design is.  

 You did not answer this question. 

 Correct answer is  (c)  

 Your score on this question is: 0.00  

 Feedback: 
   
See section 3.3.1 in the course notes.
 
 

--------------------------------------------------------------------------------

 6. 
 The FD X -> Y is a partial dependency in a relation R, if there is _____ attribute A that can be _____ X and the dependency still holds.  
 

  (a) at least one, added to
 (b) at least one, removed from
 (c) no, removed from
 (d) no, added to  

 You did not answer this question. 

 Correct answer is  (b)  

 Your score on this question is: 0.00  
 

--------------------------------------------------------------------------------

 7. 
 For a relation to be in 2NF, _____ attribute must be fully functionally dependent on _____.  
 

  (a) every non-primary-key, the primary key
 (b) every non-key, at least one key
 (c) every non-key, every key
 (d) every alternate key, the primary key  

 You did not answer this question. 

 Correct answer is  (a)  

 Your score on this question is: 0.00  
 

--------------------------------------------------------------------------------

 8. 
 Consider a table with atomic attributes A, B, and C and the following functional dependencies.

A -> B 
B -> C
If the primary key of this table is attribute A, then this relation satisfies which of the following normal forms?

First 
Second 
Third 
 
 

  (a) I only
 (b) None
 (c) I and II only
 (d) I, II and III  

 You did not answer this question. 

 Correct answer is  (c)  

 Your score on this question is: 0.00  

 Feedback: 
   
See section 3.3.2 in the course notes.
 
 

--------------------------------------------------------------------------------

 9. 
 The FD X -> Y is a full dependency in a relation R, if there is _____ attribute A that can be _____ X and the dependency still holds.  
 

  (a) no, removed from
 (b) at least one, removed from
 (c) at least one, added to
 (d) no, added to  

 You did not answer this question. 

 Correct answer is  (a)  

 Your score on this question is: 0.00  
 

--------------------------------------------------------------------------------

 10. 
 For a relation to be in 3NF, it should not contain _____ attribute that is transitively dependent on _____.  
 

  (a) a primary key, a foreign key
 (b) a non-primary key, a foreign key
 (c) a non-primary key, the primary key
 (d) a primary key, a non-primary key  

 You did not answer this question. 

 Correct answer is  (c)  
1. 
 Which of the following statements concerning normal forms is true?  
 

  (a) The lower the normal form number, the better the schema design is.
 (b) A relation that is in second normal form is also in first normal form.
 (c) Schemas that are in second normal form are considered the best.
 (d) Each normal form contains a state of independent properties, unrelated to other normal forms.  

 You did not answer this question. 

 Correct answer is  (b)  

 Your score on this question is: 0.00  

 Feedback: 
   
See section 3.3.1 in the course notes.
 
 

--------------------------------------------------------------------------------

 2. 
 Consider the following functional dependency.

{A, B} -> {C}
Regarding this dependency, which of the following statements is (are) true?

The values of C are uniquely determined by the values of A. 
The values of A are uniquely determined by the values of C. 
 
 

  (a) I only
 (b) II only
 (c) I and II
 (d) None  

 You did not answer this question. 

 Correct answer is  (d)  

 Your score on this question is: 0.00  

 Feedback: 
   
See section 3.3.1, subsection "Functional Dependencies," in the course notes.
 
 

--------------------------------------------------------------------------------

 3. 
 Which of the following problems can be caused by data redundancy in a relational schema?

Inefficient use of space 
Update anomalies and possible loss of data 
Inefficient use of processing time 
 
 

  (a) I, II, and III
 (b) I and II only
 (c) I and III only
 (d) II only  

 You did not answer this question. 

 Correct answer is  (a)  

 Your score on this question is: 0.00  

 Feedback: 
   
See section 3.3.1 in the course notes.
 
 

--------------------------------------------------------------------------------

 4. 
 Through normalization, update anomalies  
 

  (a) can be eliminated
 (b) can be maximized
 (c) is usually left unchanged
 (d) can be minimized but not eliminated  

 You did not answer this question. 

 Correct answer is  (a)  

 Your score on this question is: 0.00  
 

--------------------------------------------------------------------------------

 5. 
 Which of the following is a property (are properties) exhibited by good relational schemas?

The use of null values in tuples 
The grouping of as many attributes as possible into one main table 
The elimination of data redundancy to avoid update anomalies 
 
 

  (a) I and II only
 (b) III only
 (c) None
 (d) II and III only  

 You did not answer this question. 

 Correct answer is  (b)  

 Your score on this question is: 0.00  

 Feedback: 
   
See section 3.3.1 in the course notes.
 
 

--------------------------------------------------------------------------------

 6. 
 Consider a table with atomic attributes A, B, and C and the following functional dependencies.

A -> B 
B -> C
If the primary key of this table is attribute A, then this relation satisfies which of the following normal forms?

First 
Second 
Third 
 
 

  (a) I and II only
 (b) I only
 (c) I, II and III
 (d) None  

 You did not answer this question. 

 Correct answer is  (a)  

 Your score on this question is: 0.00  

 Feedback: 
   
See section 3.3.2 in the course notes.
 
 

--------------------------------------------------------------------------------

 7. 
 For a relation to be in 3NF, it should not contain _____ attribute that is transitively dependent on _____.  
 

  (a) a non-primary key, a foreign key
 (b) a primary key, a foreign key
 (c) a primary key, a non-primary key
 (d) a non-primary key, the primary key  

 You did not answer this question. 

 Correct answer is  (d)  

 Your score on this question is: 0.00  
 

--------------------------------------------------------------------------------

 8. 
 The FD X -> Y is a partial dependency in a relation R, if there is _____ attribute A that can be _____ X and the dependency still holds.  
 

  (a) at least one, added to
 (b) no, removed from
 (c) no, added to
 (d) at least one, removed from  

 You did not answer this question. 

 Correct answer is  (d)  

 Your score on this question is: 0.00  
 

--------------------------------------------------------------------------------

 9. 
 For a relation to be in 2NF, _____ attribute must be fully functionally dependent on _____.  
 

  (a) every non-primary-key, the primary key
 (b) every alternate key, the primary key
 (c) every non-key, every key
 (d) every non-key, at least one key  

 You did not answer this question. 

 Correct answer is  (a)  

 Your score on this question is: 0.00  
 

--------------------------------------------------------------------------------

 10. 
 The FD X -> Y is a full dependency in a relation R, if there is _____ attribute A that can be _____ X and the dependency still holds.  
 

  (a) no, added to
 (b) at least one, removed from
 (c) at least one, added to
 (d) no, removed from  

 You did not answer this question. 

 Correct answer is  (d)  

1. 
 In an ER model, which of the following is true about a composite attribute?  
 

  (a) A composite attribute can have a method attached to it.
 (b) A composite attribute cannot be broken into more basic attributes.
 (c) A composite attribute can be broken into more basic attributes.
 (d) A composite attribute can only be designed by users with special privileges.  

 Correct answer is  (c)  

 Your score on this question is: 10.00  
 



--------------------------------------------------------------------------------

 2. 
 The term physical data independence refers to the ability to change  
 

  (a) the physical layout of the data without changing the external schemas, the conceptual schemas, or the application programs
 (b) the data without physically relocating the tables
 (c) the conceptual schema without changing the application programs
 (d) the application programs without changing the conceptual schema  

 Correct answer is  (a)  

 Your score on this question is: 10.00  

 Feedback: 
   
3.1#Three-Schema Architecture
 
 

--------------------------------------------------------------------------------

 3. 
 What attributes does a subclass have?  
 

  (a) None of the attributes of its superclass
 (b) All the attributes of its superclass, and possibly more
 (c) Just the attributes from the superclass
 (d) A subset of the attributes of its superclass  

 Correct answer is  (b)  

 Your score on this question is: 10.00  
 

--------------------------------------------------------------------------------

 4. 
 If X -> Y, which of the following would make Y fully dependent on X?  
 

  (a) Y is a single attribute
 (b) X is a single attribute
 (c) X consists of multiple attributes
 (d) Y consists of multiple attributes  

 Correct answer is  (b)  

 Your score on this question is: 10.00  
 

--------------------------------------------------------------------------------

 5. 
 In an ER model, what is the degree of a relationship type?  
 

  (a) The validity of the relationship type
 (b) The strength of the relationship type
 (c) The number of entity types participating in the relationship type
 (d) The number of instances of the relationship type  

 Correct answer is  (c)  

 Your score on this question is: 10.00  
 

--------------------------------------------------------------------------------

 6. 
 Database design typically consists of which of the following phases?

Conceptual design 
Logical design 
Physical design 
 
 

  (a) II only
 (b) I, II, and III
 (c) II and III only
 (d) I only  

 Correct answer is  (b)  

 Your score on this question is: 10.00  

 Feedback: 
   
3.1#Database Design
 
 

--------------------------------------------------------------------------------

 7. 
 A relational schema is in first normal form, if the domain of all of its  
 

  (a) primary keys are not multi-valued
 (b) primary keys and alternate keys are not multi-valued
 (c) primary keys are not composite
 (d) attributes can take on only atomic values  

 Correct answer is  (d)  

 Your score on this question is: 10.00  
 

--------------------------------------------------------------------------------

 8. 
 In an ER model, a derived attribute is one whose values  
 

  (a) have been derived at some time in the past
 (b) can be derived from the values of some other attributes
 (c) can be derived from the system tables
 (d) can be derived from another table  

 Correct answer is  (b)  

 Your score on this question is: 10.00  
 

--------------------------------------------------------------------------------

 9. 
 Y is transitively dependent on X, if  
 

  (a) X -> Y and A -> Y
 (b) X -> A, B and A -> Y
 (c) X -> Y and Y -> A
 (d) X -> A, B and Y -> A, B  

 Correct answer is  (b)  

 Your score on this question is: 10.00  
 

--------------------------------------------------------------------------------

 10. 
 Relationships in an ER model are primarily translated to which of the following in a relational model?  
 

  (a) relationships
 (b) primary keys and foreign keys
 (c) three-way tables
 (d) dummy relationship tables  

 Correct answer is  (b)  

 Your score on this question is: 10.00