Exam (elaborations)
OMIS 370 EXAM 3 questions with complete solutions
- Course
- Institution
OMIS 370 EXAM 3 questions with complete solutions
[Show more]
Content preview
OMIS 370 EXAM 3The 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 benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller BravelRadon. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
82191 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now