OMIS 370 EXAM 3
The goal of logical database design is to - correct answer ✔✔create well-structured tables that properly
reflect the company's business environment.
What are logical database design techniques? - correct answer ✔✔The conversion of E-R diagrams to
relational tables and data normalization
Logical database design creates tables that will - correct answer ✔✔store data in a non-redundant
manner.
What does placing the unique identifier of one database table in another existing or new table in the
database create? - correct answer ✔✔a foreign key
-may indicated the creation of a one-to-many binary relationship, OR may indicate the creation of a
many-to-many binary relationship.
How does one convert a ONE-to-ONE binary relationship into a relational database from an E-R diagram?
- correct answer ✔✔By placing the unique identifier of one of the tables into the other OR by creating a
single table that combines the attributes of the two entities.
How does one converting a ONE-to-MANY binary relationship into a relational database from an E-R
diagram? - correct answer ✔✔By placing the unique identifier of one of the tables into the other.
What does converting a MANY-to-MANY binary relationship into a relational database from an E-R
diagram require? - correct answer ✔✔The creation of an additional table beyond the two that represent
the two entities in the relationship.
Data normalization is capable of: - correct answer ✔✔creating relational tables that are free of data
redundancy. It is a logical database design technique that can be used to check the accuracy of the E-R
diagrams to relational tables conversion techniques.
What precedes the physical database design? - correct answer ✔✔data normalization
, What is a determinant? - correct answer ✔✔an attribute whose value establishes the value of another
attribute
What is a PARTIAL functional dependency? - correct answer ✔✔a non-key field of a relational table
being dependent on only part of the table's key
What is a TRANSITIVE dependency? - correct answer ✔✔one non-key field of a table being dependent
on another non-key field of the table
When have all multi-valued attributes have been eliminated? - correct answer ✔✔In first normal form
and all those normal forms beyond
Describe data in Second normal form. - correct answer ✔✔it CANNOT have partial functional
dependencies but CAN have transitive dependencies.
Describe data in Third normal form. - correct answer ✔✔It cannot have transitive dependencies.
In third normal form, what is the exception to the rule that a non-key attribute cannot define another
non-key attribute? - correct answer ✔✔the exception to the rule is if the defining attribute is a candidate
key
How is logical database design generally preformed today? - correct answer ✔✔By converting entity-
relationship diagrams to relational table and then checking those tables against the normalization
technique rules.
What is mainly a planning and analysis function? - correct answer ✔✔Data administration
DATABASE administration is: - correct answer ✔✔mainly an operational, day-to-day monitoring and
management function.
What are the advantages of data and database administration? - correct answer ✔✔1. data as a shared
corporate resource
The goal of logical database design is to - correct answer ✔✔create well-structured tables that properly
reflect the company's business environment.
What are logical database design techniques? - correct answer ✔✔The conversion of E-R diagrams to
relational tables and data normalization
Logical database design creates tables that will - correct answer ✔✔store data in a non-redundant
manner.
What does placing the unique identifier of one database table in another existing or new table in the
database create? - correct answer ✔✔a foreign key
-may indicated the creation of a one-to-many binary relationship, OR may indicate the creation of a
many-to-many binary relationship.
How does one convert a ONE-to-ONE binary relationship into a relational database from an E-R diagram?
- correct answer ✔✔By placing the unique identifier of one of the tables into the other OR by creating a
single table that combines the attributes of the two entities.
How does one converting a ONE-to-MANY binary relationship into a relational database from an E-R
diagram? - correct answer ✔✔By placing the unique identifier of one of the tables into the other.
What does converting a MANY-to-MANY binary relationship into a relational database from an E-R
diagram require? - correct answer ✔✔The creation of an additional table beyond the two that represent
the two entities in the relationship.
Data normalization is capable of: - correct answer ✔✔creating relational tables that are free of data
redundancy. It is a logical database design technique that can be used to check the accuracy of the E-R
diagrams to relational tables conversion techniques.
What precedes the physical database design? - correct answer ✔✔data normalization
, What is a determinant? - correct answer ✔✔an attribute whose value establishes the value of another
attribute
What is a PARTIAL functional dependency? - correct answer ✔✔a non-key field of a relational table
being dependent on only part of the table's key
What is a TRANSITIVE dependency? - correct answer ✔✔one non-key field of a table being dependent
on another non-key field of the table
When have all multi-valued attributes have been eliminated? - correct answer ✔✔In first normal form
and all those normal forms beyond
Describe data in Second normal form. - correct answer ✔✔it CANNOT have partial functional
dependencies but CAN have transitive dependencies.
Describe data in Third normal form. - correct answer ✔✔It cannot have transitive dependencies.
In third normal form, what is the exception to the rule that a non-key attribute cannot define another
non-key attribute? - correct answer ✔✔the exception to the rule is if the defining attribute is a candidate
key
How is logical database design generally preformed today? - correct answer ✔✔By converting entity-
relationship diagrams to relational table and then checking those tables against the normalization
technique rules.
What is mainly a planning and analysis function? - correct answer ✔✔Data administration
DATABASE administration is: - correct answer ✔✔mainly an operational, day-to-day monitoring and
management function.
What are the advantages of data and database administration? - correct answer ✔✔1. data as a shared
corporate resource
