Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
Database Concepts, 8e (Kroenke)
Chapter 5 Database Design
1) The technique for representing E-R relationships in the relational model is dependent on the
minimum cardinality.
2) For a 1:1 relationship, the key of each table should be placed in the other table as the foreign
key.
3) Relationships that are 1:1 do not require referential integrity constraints.
4) In certain circumstances, there may be a preference as to which table in a 1:1 relationship
contains the foreign key.
5) When applied to 1:N relationships, the term "parent" refers to the many side of the relationship
since a child may have many parents.
6) To represent a 1:N relationship in the relational model, the key of the entity on the one side of
the relationship is placed as a foreign key in the entity on the many side of the relationship.
7) To represent a 1:N relationship in the relational model, the key of either entity may be placed
as a foreign key in the other entity.
8) In the relational model, many-to-many relationships cannot be directly represented by
relations the way 1:1 and 1:N relationships can.
9) To represent a M:N relationship in the relational model, an intersection table is created to
represent the relationship itself.
10) The key for an intersection table is always the combination of the keys of the parent entities.
11) Microsoft Access uses the same pure N:M relationships that occur in data modeling.
12) As far as Microsoft Access is concerned, there are no N:M relationships.
13) As far as Microsoft Access is concerned, there are no 1:N relationships.
14) By default, Microsoft Access creates 1:1 relationships between tables.
15) To create a 1:1 relationship in Microsoft Access, the Indexed property of the foreign key
column must be set to Yes (No Duplicates).
16) Which of the following is true when representing a 1:1 binary relationship using the
relational model?
A) The key of the entity with the highest minimum cardinality must be placed in the other entity
as a foreign key.
B) The key of each entity must be placed in the other as a foreign key.
C) The key of either entity is placed in the other as a foreign key.
D) The key of the entity with the most attributes must be placed in the other entity as a foreign
key.
E) Both entities must have the same primary key.
17) Given the tables
TABLE_A (Attribute1, Attribute2, Attribute3)
TABLE_B (Attribute4, Attribute5, Attribute6)
as shown in the figure below, which of the following would display the correct placement of
foreign keys in the relational model?
A) TABLE_A (Attribute1, Attribute2, Attribute3)
TABLE _B (Attribute4, Attribute5, Attribute6, Attribute1)
B) TABLE _A (Attribute1, Attribute2, Attribute3, Attribute4, Attribute5)
TABLE _B (Attribute4, Attribute5, Attribute6)
C) TABLE _A (Attribute1, Attribute2, Attribute3, Attribute4)
TABLE _B (Attribute4, Attribute5, Attribute6, Attribute1)
D) TABLE _A (Attribute1, Attribute2, Attribute3)
TABLE _B (Attribute4, Attribute5, Attribute6)
E) TABLE _A (Attribute1, Attribute2, Attribute3, Attribute6)
TABLE _B (Attribute4, Attribute5, Attribute6)
18) Which of the following is the correct technique for representing a 1:N relationship in the
relational model?
A) The key of the entity on the one side is placed into the relation for the entity on the many side.
B) The key of the child is placed into the relation of the parent.
C) The key of either relation can be placed into the other relation.
D) The key of the entity on the many side is placed into the relation for the entity on the one side.
E) An intersection relation is created, and the keys from both parent entities are placed as keys in
the intersection relation.
19) Given the tables
PRODUCT (ProductID, Description, Cost)
SUPPLIER (SupplierID, ContactName, PhoneNumber)
as shown in the figure below, which of the following would represent the correct placement of
foreign keys?
A) PRODUCT (ProductID, Description, Cost)
SUPPLIER (SupplierID, ContactName, PhoneNumber)
B) PRODUCT (ProductID, Description, Cost)
SUPPLIER (SupplierID, ContactName, PhoneNumber, ProductID)
C) PRODUCT (ProductID, Description, Cost, SupplierID)
SUPPLIER (SupplierID, ContactName, PhoneNumber, ProductID)
D) PRODUCT (ProductID, Description, Cost, ContactName)
SUPPLIER (SupplierID, ContactName, PhoneNumber)
E) PRODUCT (ProductID, Description, Cost, SupplierID)
SUPPLIER (SupplierID, ContactName, PhoneNumber)
20) Which of the following is the correct technique for representing a M:N relationship using the
relational model?
A) An intersection relation is created, and the key of either entity is placed as a key in both the
intersection relation and in the other relation.
B) An intersection relation is created with a surrogate key, which is placed in each of the parent
entities.
C) An intersection relation is created, and the keys of both parent entities are placed as a
composite key in the intersection relation.
D) The key from either relation is placed as a foreign key in the other relation.
E) None of the above
21) Given the tables
PRODUCT (ProductID, Description, Cost)
SUPPLIER (SupplierID, ContactName, PhoneNumber)
as shown in the figure below, which of the following would represent the correct placement of
foreign keys?
A) PRODUCT (ProductID, Description, Cost)
SUPPLIER (SupplierID, ContactName, PhoneNumber)
B) PRODUCT (ProductID, Description, Cost, SupplierID)
SUPPLIER (SupplierID, ContactName, PhoneNumber, ProductID)
C) PRODUCT (ProductID, Description, Cost)
SUPPLIER (SupplierID, ContactName, PhoneNumber)
PRODUCT_SUPPLIER (ProductID, SupplierID, PhoneNumber)
D) PRODUCT (ProductID, Description, Cost, SupplierID)
SUPPLIER (SupplierID, ContactName, PhoneNumber)
E) PRODUCT (ProductID, Description, Cost)
SUPPLIER (SupplierID, ContactName, PhoneNumber)
PRODUCT_SUPPLIER (ProductID, SupplierID)
22) In many-to-many relationships in a relational database design, ________.
A) the key of the child is placed as a foreign key into the parent
B) the key of the parent is placed as a foreign key into the child
C) the keys of both tables are placed in a third table
D) the keys of both tables are joined into a composite key
E) Both C and D
23) In many-to-many relationships in a relational database design, ________.
A) the intersection table is ID-dependent on one of the parents
B) the intersection table is ID-dependent on both of the parents
C) the minimum cardinality from the intersection table to the parents is always M
D) Both A and B
E) Both B and C
24) In relational database design, ID-dependent entities are used to ________.
A) represent 1:1 relationships
B) represent 1:N relationships
C) represent N:M relationships
D) handle recursive relationships
E) eliminate the need for weak entities being converted to tables
25) What relationship pattern is illustrated in the following schema?
PRODUCT (ProductID, Description)
SUPPLIER (SupplierID, ContactName, PhoneNumber)
PRODUCT_SUPPLIER (ProductID, SupplierID, Cost)
ProductID in PRODUCT_SUPPLIER must exist in ProductID in PRODUCT
SupplierID in PRODUCT_SUPPLIER must exist in SupplierID in PRODUCT
A) Association relationship
B) Intersection relationship
C) Recursive relationship
D) Strong entity relationship
E) Supertype/subtype relationship
26) What relationship pattern is illustrated in the following schema?
VEHICLE (VehicleID, Cost)
CAR (VehicleID, NumberOfSeats)
TRUCK (VehicleID, CargoCapacity)
VehicleID in CAR must exist in VehicleID in VEHICLE
VehicleID in TRUCK must exist in VehicleID in VEHICLE
A) Association relationship
B) Intersection relationship
C) Recursive relationship
D) Strong entity relationship
E) Supertype/subtype relationship
27) Which of the following is not true about representing subtypes in a relational database
design?
A) One table is created for the supertype and one for each subtype.
B) All of the attributes of the supertype are added to the subtype relations.
C) The key of the supertype is made the key of the subtypes.
D) A subtype and its supertype are representations of the same underlying table.
E) An instance of the supertype may be related to one instance each of several subtypes.
28) Microsoft Access does not create N:M relationships because ________.
A) Microsoft Access creates databases based on database designs instead of data models.
B) Microsoft Access creates databases based on data models instead of database designs.
C) Microsoft Access cannot implement association relationships.
D) Microsoft Access cannot implement supertype/subtype relationships.
E) Microsoft Access cannot implement recursive relationships.
29) As far as Microsoft Access is concerned, there are no ________.
A) 1:1 relationships
B) 1:N relationships
C) N:1 relationships
D) N:M relationships
E) recursive relationships
30) By default, when Microsoft Access creates a relationship between two tables, it creates a(n)
________.
A) 1:1 relationship
B) 1:N relationship
C) N:M relationship
D) association relationship
E) recursive relationship
31) To create a 1:1 relationship between two tables in Microsoft Access ________.
A) the Indexed property of the foreign key column must be set to No
B) the Indexed property of the foreign key column must be set to Yes (Duplicates OK)
C) the Indexed property of the foreign key column must be set to Yes (No Duplicates)
D) the Data Type of the foreign key column must be set to AutoNumber
E) the Smart Tag property of the foreign key column must be set to Foreign Key
32) Microsoft Access does not create N:M relationships because Microsoft Access creates
databases based on ________.
33) As far as Microsoft Access is concerned, there are no ________.
34) By default, when Microsoft Access creates a relationship between two tables it creates a(n)
________ relationship.
