I have 10 Database management Multiple choice questions hat needs to be answered.Only tutors whose rating is 3.0 and above may proceed to work on these problems.This is a very important exam so be sure that all Multiple choice questions are correct.Please see attached for questions.

Time to complete is : 3 hours

 

1 Qn) All of the following are true about logical database excepta. Physical DB is performed before logical DB design.b. Logical database design is performed before physical database design.c. tables that result from logical database design have no data redundancy.d. data normalization is a logical database design technique.e. Conversion of E-R diagrams to relational tables is a logical database design technique.--------------------------------2 Qn) An E-R diagram shows a one to many relationship between entities A and B. For each Aoccurance there are many B occuranxes; For each B occurances there is exactly one A occurances.Converting this E-R diagram as part of logical database design____?a. Requires placing a copy of the unique identifier of entity A in the table for entity Bb. Can be done by placing the attribute for entities A and B in a single table.c. Requires three tables .d. Requires placing a copy of the unique identifier of entity B in the table for entity Ae. none of the above.--------------------------------3 Qn) All of the following are true if a relational DB is in third normal form , except of the tables of theDB is ___?a. In First Normal Formb.In Third Normal formc.In every Normal form higher than 3NFd.In second normal forme.Free of data redundancy.-------------------------------4th Qn) A relational table in second normal form ____?a. Is free of data redundancyb. May have transitives dependencies.c. Cannot have functional dependenciesd.cannot have determinantse.permits partial functional dependencies.______________________________

Attachments:

• 1494471110-Database management Qns.docx