Database Management System Set 7

Database Management System

61.

When converting one (1) to many (N) binary relationship into tables, the recommended solution is usually

(a)	One big table with all attributes from both entities included
(b)	Foreign key added on the Child (many side) referencing the parent
(c)	Foreign key added on the Parent (one side) referencing the child
(d)	Foreign key added on both sides (both tables)
(e)	Primary Key is added on one side.

62.

Which of the following is not correct?

(a)	Each entity must include some descriptive information
(b)	If an object only requires an identifier, it should be classified as an attribute
(c)	Each multivalued attribute should be classified as an entity even if it does not have any descriptive information
(d)	The procedure of identifying entities and attaching attributes always leads to a unique solution
(e)	Every entity is a collection of attributes.

63.

The property of transaction which ensures that either all operations of the transaction are reflected properly in the database or none, is called

64.

Which of the following is correct?

(a)	Function dependencies are not associated with relations; they are based on the semantics of information that we are dealing with
(b)	If a relation has no redundant information its attributes must not have any function dependencies
(c)	Functional dependencies may be determined if we are given several instances of a relation
(d)	The FDs that hold for attributes of a relation need not be satisfied at all times
(e)	BCNF is a fourth normal form.

65.

An entity type whose existence depends on another entity type is called a _____ entity.

66.

A property or characteristic of an entity type that is of interest to the organization is called an

67.

A relationship between the instances of a single entity type is called a _____ relationship.

68.

A ________ attribute is an attribute that can be further subdivided to yield additional attributes.

69.

In a super type/subtype hierarchy, each subtype has

70.

The hierarchical database model uses the hierarchic sequence that always starts at

61.	Answer : (b) Reason: When converting one (1) to many (N) binary relationship into tables, the recommended solution is Foreign key added on the Child (many side) referencing the parent
62.	Answer : (d) Reason: The procedure of identifying entities and attaching attributes always leads to a unique solution
63.	Answer : (a) Reason: Atomicity is the property of transaction which ensures that either all operations of the transaction are reflected properly in the database or none
64.	Answer : (a) Reason: Function dependencies are not associated with relations; they are based on the semantics of information that we are dealing with.
65.	Answer : (b) Reason: Entity type whose existence depends on another entity type is called a weak entity
66.	Answer : (a) Reason: A property or characteristic of an entity type that is of interest to the organization is called attribute
67.	Answer : (e) Reason: A relationship between the instances of a single entity type is called a Unary relationship.
68.	Answer : (a) Reason: Composite attribute is an attribute that can be further subdivided to yield additional attributes.
69.	Answer : (a) Reason: In a super type/subtype hierarchy, each subtype has only one super type
70.	Answer : (b) Reason: The hierarchical database model uses the hierarchic sequence that always starts at the left side of the tree