Question

Question 29
What entity type is used to convert a many-to-many relationship to two one-to-many relationships?


repeating entity

intersection entity

associative entity

attributive entity


Question 30
A many-to-many relationship can be directly modeled in a relational database such as Microsoft Access.


True

False

Question 31
Which order is correct for the designer to normalize a data structure?
I. Remove all repeating groups and identify the primary key.
II. Remove any transitive dependencies.
III. Remove all partial dependencies and place them in another relation.


III - II - I

I - II - III

III - I - II

II - I - III

I - III - II


Question 32
A __________ symbol represents more than one instance of the other entity in an entity-relationship diagram.


single line

crow's foot

double line

dotted line

Question 33
In an entity-relationship diagram, an attribute is a characteristic or property of a(n) __________.


relationship

record

entity

sequential file

Question 34
Which of the following is not a difference between a data warehouse and a transaction-oriented database?

Data in a data warehouse are organized around major subjects rather than transactions.

Data in a data warehouse cover a much longer time frame than transaction data.

Data in a data warehouse are organized for rapid updating.

Data in a data warehouse are organized for fast queries.

Data in a data warehouse often include data from sources outside the organization.

Answer 1

29)associative entity

30)true

31)I-III-II

Explanation :firstly the given fd are get converted into canonical form then key is formed on the basis of key 2 nf decomposition take place after this 3nf then bcnf

32)crow's foot

33)entity

34)Data in a data warehouse are organized for rapid updating.