Question

True or False:

1. Logical database design is the process of modifying the physical database design to improve performance.
2. The two major logical database design techniques are conversion of E-R diagrams to relational tables and data normalization.
3. Multivalued attributes are not permitted in unnormalized data.
4. A many-to-many binary relationship in an E-R diagram requires the creation of a total of three tables in a relational database.
5. A one-to-one unary relationship in an E-R diagram requires the creation of a total of three tables in a relational database.
6. The input to the data normalization process is a list of the attributes in the database and a list of the functional dependencies among them.
7. The data normalization process is known as a “composition process.”
8. A group of tables is said to be in a particular normal form if every table in the group is in that normal form.
9. In first normal form tables every attribute value is atomic, that is no attribute is multi-valued.
10. Converting from first to second normal form involves subdividing tables to remove transitive dependencies.
11. A transitive dependency occurs when a non-key attribute determines another non-key attribute.
12. The data normalization process is progressive. If a group of tables is in second normal form it is also in third normal form.

Answer 1

ANSWERS -

1) False

Physical database design is the process of modifying the logical database in order to enhance the performance, logical database design is arranging attributes in the database.

2) True

Yes, data normalization and conversion of E-R diagrams to relational tables are two main techniques of logical database design.

3) False

Unnormalized data must contain multivalued attributes, it should have multiple values.

4) True

It should have atleast three tables to form many-many relationship.

5) False

Its an association with same entity type, does not require three tables.

6) True

7) False

Data normalization is the process to reduce data redundancy by using normal forms.

8) True

The whole table should be in the same normal form.

9) True

Every attribute is single valued in table.

10) False

In, 1NF to 2NF conversion partial functional dependency is removed.

11) True

12) False

=================================END================================

Please comment if u need any other info and DO LEAVE A LIKE, it would mean a lot. Thanks :)