FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 5: Database Design

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

Which of the following is not true about surrogate keys?

A) They are identifiers that are supplied by the system, not the users.
B) They have no meaning to the users.
C) They are nonunique within a table.
D) They can be problematic when combining databases.
E) The DBMS will not allow their values to be changed.

F) A) and D)
G) None of the above

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

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.

F) A) and E)
G) A) and B)

Correct Answer

verified

Show Answer

Question 33

Short Answer

Review LaterAdd Note

Microsoft Access does not create N:M relationships because Microsoft Access creates databases based on ________.

To represent a many-to-many relationship in the relational model,a(n)________ table is used.

Each attribute of an entity becomes a(n) ________ of a table.

A surrogate key is appropriate when the primary key of a table contains a lengthy text field.

For a 1:1 relationship,the key of each table should be placed in the other table as the foreign key.

In the relational model,many-to-many relationships cannot be directly represented by relations the way 1:1 and 1:N relationships can.

What relationship pattern is illustrated in the following schema? EMPLOYEE (EmployeeID,OfficePhone,Manager) Manager in EMPLOYEE must exist in EmployeeID in EMPLOYEE

When transforming an E-R data model into a relational database design,the key of the parent entity should be placed as part of the primary key into the child entity ________.

Explain the pragmatic reason for using surrogate keys.

Explain the representation of a many-to-many strong entity relationship in a relational database design.

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

By default,when Microsoft Access creates a relationship between two tables it creates a(n)________ relationship.

Relationships that are 1:1 do not require referential integrity constraints.

How are one-to-one recursive relationships addressed using the relational model?

Microsoft Access uses the same pure N:M relationships that occur in data modeling.

The key of the parent entity becomes part of the key of an ID-dependent entity.

The identifier of the entity becomes the ________ of the corresponding table.

Which of the following is true when representing a 1:1 binary relationship using the relational model?