ERD Questions: Multiple Choice Questions. Each question has only ONE correct ans
ID: 3767575 • Letter: E
Question
ERD Questions: Multiple Choice Questions. Each question has only ONE correct answer.
1. The inability to remove data from a database for one type of entity without removing data for another type of entity is referred to as a(n)
a. update anomaly.
b. insert anomaly.
c. integrity anomaly.
d. deletion anomaly.
e. addition anomaly.
f. insertion dilemma.
g. None of the above.
2. ACME manufacturing wants to track post-sales customer service by collecting information about each customer service call: who called, when the call happened, which customer service representative handled the call, how long the call lasted, which sales transaction prompted the call, and which inventory items were discussed. To begin the service call, the customer service representative (CSR) always requests the sales invoice number that the customer is calling about.This allows the CSR to pull up the specific invoice in the system and associate comments and details of the post-sales service call with that invoice.If the customer calls in multiple times about the same sales invoice, the CSR associates a new set of comments to that sales invoice.The relationship between the Sales Invoice and Post-sales Service Call comments should be modeled as which of the following?
a. one-to-one
b. one-to-many
c. many-to-many
d. zero-to-many
e. zero-to-one
f. D or E are both possible options
3. A relational database in which customer data is not maintained independently of sales invoice data (i.e., one table, instead of two tables, is used to store data) will be susceptible to which of the following problems:
a. an update anomaly.
b. an insert anomaly.
c. a deletion anomaly.
d. an integrity anomaly.
e. A and B
f. B and C
g. A and C
h. A, B, and C
i. A, B, C, and D
j. None of the above
3. Tom Khat is chair of the Purebred Cat (PC) Society, which maintains a database of registered purebred cats and their breeding history in Siamese, CA. He’s designing a database to track these child-parent relationships. One table will store the name, birth date, and other characteristics of all of the cats that have been registered with the PC society. He wanted to track weight, but he was told that would not be PC.Each cat in that table is uniquely identified by a registration number. A second table will contain data that link each cat to its male and female parents by means of their registration numbers. The primary key in the second table is:
a. name
b. birth date
c. the combination of both parents’ primary keys in the first table
d. the same primary key in the first table that identifies the child cat
e. either C or D would be appropriate
f. none of the above
4. Scuz Bootes has been doing custom choppers, piercings, and tattoos for over thirty years. His home and place of business is a garage in the harbor district of Seattle, Washington. He has meticulous records of every job he has ever done, carefully handwritten with the customer name and address, a description of the job, and an attached picture of the bike or body part before and after customization. His unique style has recently attracted the attention of national media after several celebrities sought him out and showcased his work. Business is booming. Consequently, Scuz has hired you to construct an accounting information system, beginning with the historical records. As you read through the records, you notice that some customer last names have different first names in different records. For example, R. Framington Farnsworth (custom chopper), Bob Farnsworth (tattoo), and Snake Farnsworth (tattoos and piercings) all seem to be the same person. So you compile all the customers and their information in a single spreadsheet and take it to Scuz. Scuz helps you reconcile the different names, so the table only has one name per actual customer. But Scuz is a personable guy and he insists on identify his customers in the database by name. Your database knowledge tells you that such a design would:
a. violate the referential integrity rule.
b. suffer from the update anomaly problem.
c. suffer from the insert anomaly problem.
d. violate the entity integrity rule.
e. be okay.
f. B and D
5. Heidi Canal is a headhunter with Career Funnel in Boca Raton, Florida. Heidi is proud of the company's motto: We funnel workers into jobs. CF tracks information about Employers and Clients in two separate tables. They frequently place many clients with a single employer and occassionaly place a single client with many employers. This requirements them to track their placements in separate “Placement” table. In the Placement table, the client ID serves as
a. the primary key.
b. part of the primary key
c. a foreign key.
d. a non-key attribute
e. B and C
f. A, B, and C
g. None of the above
Explanation / Answer
1. G None of the above.
2. B one-to-many
3. A Update Anomaly
3. C the combination of both parents’ primary keys in the first table
4. D violate the entity integrity rule.
5. C. a foreign key.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.