quiz6

Wiley Pathways Introduction to Database Management

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Sheet1 Page 1 1. Question: The first step in developing the conceptual model using ER diagrams is ____. 1 ANormalize the entities BComplete the initial ER diagram CIdentify, analyze, and refine the business rules DDefine the attributes, primary keys, and foreign keys for each of the entities C 2. Question: Connectivities and cardinalities are established by business rules. ATrue BFalse A 3. Question: Testing, fine-tuning, and evaluating the database and its applications are part of the ____ phase of the DBLC. ADatabase initial study BDatabase design CImplementation and loading DTesting and evaluation D 4. Question: There are ____ stages in the DBLC. AFour BFive CSix DSeven C 5. Question: The most likely data type for a surrogate key is ____. ACharacter BDate CLogical DNumeric D 6. Question: A ____ relationship exists when an association is maintained within a single entity. AUnary BTernary CBinary DWeak A
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Sheet1 Page 2 7. Question: A derived attribute ____. AMust be stored physically within the database BNeed not be physically stored within the database CHas many values DMust be based on the value of three or more attributes B 8. Question: The process of creating an information system is known as ____ development. ASystems BDatabase CNetwork DTransformation A 9. Question: The step,____, occurs first in the process of building an ERD. ADevelop the initial ERD BCreate a detailed narrative of the organizationx s description of operations CIdentify the attributes and primary keys that adequately describe the entities DIdentify the business rules based on the description of operations B 10. Question: ____ relationships are most common. AUnary BBinary CTernary DHigher-degree B 11. Question: Data redundancies are caused by the fact that every row entry requires duplication of data. ATrue BFalse A 12. Question: To generate a surrogate key, Microsoft Access uses a(n) ____ data type. ASurrogate BSequence CAutoNumber DIdentity C
Background image of page 2
Sheet1 Page 3 13. Question: Data integrity is enforced by the DBMS through the proper use of primary and foreign key rules. ATrue
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This document was uploaded on 03/28/2010.

Page1 / 10

quiz6 - 1. Question: The first step in developing the...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online