Test Bank For Database Concepts 7th Edition by Kroenke and Auer ISBN 0133544621 9780133544626
Test Bank For Database Concepts 7th Edition by Kroenke and Auer ISBN 0133544621 9780133544626
Test Bank For Database Concepts 7th Edition by Kroenke and Auer ISBN 0133544621 9780133544626
https://testbankpack.com/p/test-bank-for-database-concepts-7th-
edition-by-kroenke-and-auer-isbn-0133544621-9780133544626/
Solution Manual:
https://testbankpack.com/p/solution-manual-for-database-concepts-
7th-edition-by-kroenke-and-auer-isbn-0133544621-9780133544626/
1) While the relational model for databases appears to hold much promise, few
commercial databases have implemented it.
Answer: FALSE
Diff: 1Page Ref: 62
5) In the relational model, each row of a table contains data that represents an attribute of the
entity.
Answer: FALSE
Diff: 2Page Ref: 63
9) The primary key is used both to identify unique rows in a relation and to represent rows in
relationships.
Answer: TRUE
Diff: 2Page Ref: 66-67
10) To represent a relationship in the relational model, the primary key of one relation is placed
into a second relation.
Answer: TRUE
Diff: 1Page Ref: 71
1
Copyright © 2015 Pearson Education, Inc.
11) When used to represent a relationship, the primary key must have the same name as the
corresponding foreign key.
Answer: FALSE
Diff: 3Page Ref: 72
13) Since surrogate keys are used to uniquely identify rows, their values are normally
displayed prominently on all forms and reports for the users to see.
Answer: FALSE
Diff: 2Page Ref: 70
14) The use of surrogate keys usually complicates application programming since most DBMS
products require the application program to generate surrogate key values.
Answer: FALSE
Diff: 2Page Ref: 70-71
15) Null values can cause problems because they are ambiguous.
Answer: TRUE
Diff: 1 Page Ref: 74-76
16) If the condition exists such that knowing the value of attribute X determines the value of
attribute Y, then attribute Y is functionally dependent on attribute X.
Answer: TRUE
Diff: 1Page Ref: 76
17) Given the functional dependency for the attributes of ENTITY1, X → (A, B, C), X is a
candidate key for the relation ENTITY1 (A, B, C, X).
Answer: TRUE
Diff: 3Page Ref: 77-78
20) Any table that meets the definition of a relation is said to be in second normal
form. Answer: FALSE
Diff: 2Page Ref: 79
2
Copyright © 2015 Pearson Education, Inc.
21) The first step of the normalization process is to identify all the candidate keys of a relation.
Answer: TRUE
Diff: 1Page Ref: 79
22) In the normalization process, it is not necessary to identify all the functional dependencies in
a relation.
Answer: FALSE
Diff: 1Page Ref: 79
24) In the normalization process, if you find a candidate key that is not a primary key, then
you have determined that the relation needs to be broken into two or more other relations.
Answer: FALSE
Diff: 2Page Ref: 79
25) In the normalization process, if you find that every determinant in a relation is a
candidate key, then you have determined that the relation is well formed.
Answer: TRUE
Diff: 2Page Ref: 79
26) Since Microsoft Access is a personal database, it is not subject to the modification
problems that occur in other relational databases.
Answer: FALSE
Diff: 2Page Ref: 90
27) In Microsoft Access, relationships between tables are created in the Relationships window.
Answer: TRUE
Diff: 1Page Ref: 98
28) In Microsoft Access, foreign keys are designated by using the Foreign Key button in the
toolbar.
Answer: FALSE
Diff: 2Page Ref: 99-100
30) Microsoft Access forms can only contain data from one table.
Answer: FALSE
Diff: 1 Page Ref: 102
3
Copyright © 2015 Pearson Education, Inc.
Another document from Scribd.com that is
random and unrelated content:
derivative works based on the work as long as all references to Project
Gutenberg are removed. Of course, we hope that you will support the
Project Gutenberg™ mission of promoting free access to electronic
works by freely sharing Project Gutenberg™ works in compliance with
the terms of this agreement for keeping the Project Gutenberg™ name
associated with the work. You can easily comply with the terms of this
agreement by keeping this work in the same format with its attached full
Project Gutenberg™ License when you share it without charge with
others.
1.D. The copyright laws of the place where you are located also govern
what you can do with this work. Copyright laws in most countries are in
a constant state of change. If you are outside the United States, check the
laws of your country in addition to the terms of this agreement before
downloading, copying, displaying, performing, distributing or creating
derivative works based on this work or any other Project Gutenberg™
work. The Foundation makes no representations concerning the
copyright status of any work in any country other than the United States.
1.E.1. The following sentence, with active links to, or other immediate
access to, the full Project Gutenberg™ License must appear prominently
whenever any copy of a Project Gutenberg™ work (any work on which
the phrase “Project Gutenberg” appears, or with which the phrase
“Project Gutenberg” is associated) is accessed, displayed, performed,
viewed, copied or distributed:
This eBook is for the use of anyone anywhere in the United States
and most other parts of the world at no cost and with almost no
restrictions whatsoever. You may copy it, give it away or re-use it
under the terms of the Project Gutenberg License included with this
eBook or online at www.gutenberg.org. If you are not located in the
United States, you will have to check the laws of the country where
you are located before using this eBook.
1.E.6. You may convert to and distribute this work in any binary,
compressed, marked up, nonproprietary or proprietary form, including
any word processing or hypertext form. However, if you provide access
to or distribute copies of a Project Gutenberg™ work in a format other
than “Plain Vanilla ASCII” or other format used in the official version
posted on the official Project Gutenberg™ website (www.gutenberg.org),
you must, at no additional cost, fee or expense to the user, provide a
copy, a means of exporting a copy, or a means of obtaining a copy upon
request, of the work in its original “Plain Vanilla ASCII” or other form.
Any alternate format must include the full Project Gutenberg™ License
as specified in paragraph 1.E.1.
1.E.7. Do not charge a fee for access to, viewing, displaying, performing,
copying or distributing any Project Gutenberg™ works unless you
comply with paragraph 1.E.8 or 1.E.9.
1.E.8. You may charge a reasonable fee for copies of or providing access
to or distributing Project Gutenberg™ electronic works provided that:
• You pay a royalty fee of 20% of the gross profits you derive from
the use of Project Gutenberg™ works calculated using the method
you already use to calculate your applicable taxes. The fee is owed
to the owner of the Project Gutenberg™ trademark, but he has
agreed to donate royalties under this paragraph to the Project
Gutenberg Literary Archive Foundation. Royalty payments must be
paid within 60 days following each date on which you prepare (or
are legally required to prepare) your periodic tax returns. Royalty
payments should be clearly marked as such and sent to the Project
Gutenberg Literary Archive Foundation at the address specified in
Section 4, “Information about donations to the Project Gutenberg
Literary Archive Foundation.”
• You provide a full refund of any money paid by a user who notifies
you in writing (or by e-mail) within 30 days of receipt that s/he does
not agree to the terms of the full Project Gutenberg™ License. You
must require such a user to return or destroy all copies of the works
possessed in a physical medium and discontinue all use of and all
access to other copies of Project Gutenberg™ works.
• You comply with all other terms of this agreement for free
distribution of Project Gutenberg™ works.
1.F.
1.F.4. Except for the limited right of replacement or refund set forth in
paragraph 1.F.3, this work is provided to you ‘AS-IS’, WITH NO
OTHER WARRANTIES OF ANY KIND, EXPRESS OR IMPLIED,
INCLUDING BUT NOT LIMITED TO WARRANTIES OF
MERCHANTABILITY OR FITNESS FOR ANY PURPOSE.
The Foundation’s business office is located at 809 North 1500 West, Salt
Lake City, UT 84116, (801) 596-1887. Email contact links and up to date
contact information can be found at the Foundation’s website and official
page at www.gutenberg.org/contact
Please check the Project Gutenberg web pages for current donation
methods and addresses. Donations are accepted in a number of other
ways including checks, online payments and credit card donations. To
donate, please visit: www.gutenberg.org/donate.
Most people start at our website which has the main PG search facility:
www.gutenberg.org.