Question 1

How would you set up a relationship between a table of Books and a table of Authors in a relational database?

Accepted Answer

One book can have many authors and one a...

Question 2

When you build a relational database for an organization, what is a good starting point for identifying required user views?

Accepted Answer

A)   Collect the organization's forms and reports.
B)   Video each user.
C)   Conduct a detailed survey.
D)   Attend staff meetings.E) None of the above
F) A) and B)

Question 3

When two tables in a query share no common fields, each record in one table connects to each record in the other table, creating a(n)  _____.

Accepted Answer

A)   many-to-many relationship
B)   one-to-one relationship
C)   outer join
D)   Cartesian joinE) None of the above
F) All of the above

Question 4

In Access Table Datasheet View, how can you display the records from a related table?

Accepted Answer

A)   Click the Lookup button on the ribbon.
B)   Click the Related Records button on the ribbon.
C)   Right-click a field and then click Relationships on the shortcut menu.
D)   Click the expand button to expand a subdatasheet.E) B) and D)
F) B) and C)

Question 5

In a database for a health care clinic, a medical specialty is listed only once in the Specialties table, but each specialty may be linked to many doctors in the Doctors table. What type of relationship do the Specialties and Doctors tables have?

Accepted Answer

A)   one to many
B)   one to one
C)   many to one
D)   many to manyE) A) and D)
F) B) and C)

Question 6

Which of the following tools does not help you document relationships between tables?

Accepted Answer

A)   Database Design Language
B)   user views
C)   entity-relationship diagram
D)   entity-relationship modelE) B) and C)
F) A) and B)

Question 7

Building the entities, attributes, constraints, and relationships in a particular RDBMS is called the _____.

Accepted Answer

A)   information-level design
B)   conceptual design
C)   entity-relationship (E-R)  design
D)   physical-level designE) All of the above
F) A) and B)

Question 8

Which of the following statements is not true about primary key fields?

Accepted Answer

A)   The primary key field must participate in a one-to-many relationship.
B)   The primary key field contains unique data for each record in the table.
C)   The primary key field is automatically indexed.
D)   The primary key field is the linking field in the table on the "one" side of a one-to-many relationship.E) All of the above
F) B) and C)

Question 9

Because you cannot directly create a many-to-many relationship between two tables, what must you create to link the tables together?

Accepted Answer

A)   junction table
B)   entity-relationship diagram
C)   Cartesian join
D)   secondary tableE) A) and C)
F) A) and B)

Question 10

In an entity-relationship model (ERM) , what information appears in ovals?

Accepted Answer

A)   entities
B)   attributes
C)   relationships
D)   dependenciesE) None of the above
F) A) and D)

Question 11

A _____ serves on the "many" side of a one-to-many relationship with each of two other tables.

Accepted Answer

A)   secondary key
B)   junction table
C)   lookup table
D)   connecting tableE) B) and C)
F) A) and C)

Question 12

What can you create in Access to show data in a single record and all its related records?

Accepted Answer

A)   one-to-one relationship
B)   lookup reports
C)   form and subform
D)   related user viewsE) A) and B)
F) B) and C)

Question 13

What shape does an E-R diagram use to represent entities?

Accepted Answer

A)   rectangle
B)   oval
C)   triangle
D)   diamondE) A) and B)
F) None of the above

Question 14

A query creates a Cartesian join between one table with 5 records and another table with 20 records. How many records are displayed in the results?

Accepted Answer

A)   100
B)   25
C)   15
D)   4E) A) and D)
F) All of the above

Question 15

Which of the following is a type of E-R diagram?

Accepted Answer

A)   Access Database Documenter
B)   crow's foot notation
C)   entity tree notation
D)   Database Design Language (DBDL) E) A) and D)
F) B) and C)

Question 16

Which of the following items is not identified in relational database design documentation?

Accepted Answer

A)   primary key field for each entity
B)   possible user views for each entity
C)   proper one-to-many relationships between the entities
D)   attributes needed for each normalized entityE) B) and C)
F) A) and B)

Question 17

In the following Database Design Language (DBDL)  notation, what does SK stand for? Employees (EmpID, LastName, FirstName, SSN, DeptNum) 
AK SSN
SK LastName, FirstName
FK DeptNum à Departments

Accepted Answer

A)   subkey
B)   start key
C)   SQL key
D)   secondary keyE) All of the above
F) A) and B)

Question 18

How does the Access Relationships window indicate the "many" field in a one-to-many relationship?

Accepted Answer

A)   ring and crow's foot
B)   number 1
C)   filled circle
D)   infinity symbolE) None of the above
F) A) and C)

Question 19

Define the types of cardinality in a database and explain the cardinality of primary keys and foreign keys.

Accepted Answer

In a database, cardinality refers to the...

Question 20

A one-to-many relationship with _____ means that a record in the parent table must be established before a related record in the child table can be entered.

Accepted Answer

A)   cardinality
B)   access restrictions
C)   referential integrity
D)   alternate keysE) A) and B)
F) A) and C)

Exam 6: Database Design: Relationships

How would you set up a relationship between a table of Books and a table of Authors in a relational database?

Correct AnswerverifiedOne book can have many authors and one a...View AnswerShow Answer

When you build a relational database for an organization, what is a good starting point for identifying required user views?

Correct AnswerverifiedShow Answer

Which of the following items is not identified in relational database design documentation?

Correct AnswerverifiedShow Answer

A one-to-many relationship with _____ means that a record in the parent table must be established before a related record in the child table can be entered.

Correct AnswerverifiedShow Answer

A _____ serves on the "many" side of a one-to-many relationship with each of two other tables.

Correct AnswerverifiedShow Answer

What shape does an E-R diagram use to represent entities?

Correct AnswerverifiedShow Answer

When two tables in a query share no common fields, each record in one table connects to each record in the other table, creating a(n) _____.

Correct AnswerverifiedShow Answer

In an entity-relationship model (ERM) , what information appears in ovals?

Correct AnswerverifiedShow Answer

How does the Access Relationships window indicate the "many" field in a one-to-many relationship?

Correct AnswerverifiedShow Answer

In a database for a health care clinic, a medical specialty is listed only once in the Specialties table, but each specialty may be linked to many doctors in the Doctors table. What type of relationship do the Specialties and Doctors tables have?

Correct AnswerverifiedShow Answer

Because you cannot directly create a many-to-many relationship between two tables, what must you create to link the tables together?

Correct AnswerverifiedShow Answer

Building the entities, attributes, constraints, and relationships in a particular RDBMS is called the _____.

Correct AnswerverifiedShow Answer

Which of the following is a type of E-R diagram?

Correct AnswerverifiedShow Answer

In the following Database Design Language (DBDL) notation, what does SK stand for? Employees (EmpID, LastName, FirstName, SSN, DeptNum) AK SSN SK LastName, FirstName FK DeptNum à Departments

Correct AnswerverifiedShow Answer

In Access Table Datasheet View, how can you display the records from a related table?

Correct AnswerverifiedShow Answer

Which of the following tools does not help you document relationships between tables?

Correct AnswerverifiedShow Answer

Define the types of cardinality in a database and explain the cardinality of primary keys and foreign keys.

Correct AnswerverifiedIn a database, cardinality refers to the...View AnswerShow Answer

What can you create in Access to show data in a single record and all its related records?

Correct AnswerverifiedShow Answer

A query creates a Cartesian join between one table with 5 records and another table with 20 records. How many records are displayed in the results?

Correct AnswerverifiedShow Answer

Which of the following statements is not true about primary key fields?

Correct AnswerverifiedShow Answer

Correct Answer
verified
One book can have many authors and one a...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
In a database, cardinality refers to the...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified