Total score: 100.00
	


	1. 	
	What attributes does a subclass have? 	

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

	Correct answer is 	(a)

	Your score on this question is: 	10.00 	

	2. 	
	The functional dependency X -> Y is true if 	

	(a) the value of Y depends on the collective values of X
(b) the value of X depends on the collective values of Y
(c) a value of X uniquely determines a value of Y
(d) a value of Y uniquely determines a value of X

	Correct answer is 	(c)

	Your score on this question is: 	10.00 	

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

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

	Correct answer is 	(d)

	Your score on this question is: 	10.00

	Feedback: 	
   

3.1#Three-Schema Architecture
	

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

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

	Correct answer is 	(a)

	Your score on this question is: 	10.00 	

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

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

	Correct answer is 	(b)

	Your score on this question is: 	10.00 	

	6. 	
	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 can only be designed by users with special privileges.
(c) A composite attribute can be broken into more basic attributes.
(d) A composite attribute cannot be broken into more basic attributes.

	Correct answer is 	(c)

	Your score on this question is: 	10.00 	

	7. 	
	Y is transitively dependent on X, if 	

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

	Correct answer is 	(d)

	Your score on this question is: 	10.00 	

	8. 	
	In EER modeling, specialization is the process of generating 	

	(a) subclasses out of superclasses
(b) superclasses out of subclasses
(c) entities out of attributes
(d) attributes out of entities

	Correct answer is 	(a)

	Your score on this question is: 	10.00 	

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

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

	Correct answer is 	(a)

	Your score on this question is: 	10.00 	

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

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

	Correct answer is 	(c)

	Your score on this question is: 	10.00 	

	Go to top of assessment.

	Total score: 100.00