Database Management Chapter 6

Ace your homework & exams now with Quizwiz!

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) _____. a.one-to-one relationship b.Cartesian join c.outer join d.many-to-many relationship

Cartesian join

Which of the following statements is not true about primary key fields? a.The primary key field is the linking field in the table on the "one" side of a one-to-many relationship. b.The primary key field contains unique data for each record in the table. c.The primary key field must participate in a one-to-many relationship. d.The primary key field is automatically indexed.

The primary key field must participate in a one-to-many relationship.

In an entity-relationship model (ERM), what information appears in ovals? a.relationships b.dependencies c.entities d.attributes

attributes

In an entity-relationship model (ERM) for a many-to-many relationship, what do you call the middle entity that links two other tables? a.secondary entity b.linking entity c.consolidated entity d.composite entity

composite entity

During which process do you typically create anentity-relationship (E-R) diagram? a.maintenance b.information-level design c.troubleshooting user views d.physical-level design

information-level design

Building the entities, attributes, constraints, and relationships in a particular RDBMS is called the _____. a.conceptual design b.entity-relationship (E-R) design c.physical-level design d.information-level design

physical-level design

A(n) _____ is a field that contains unique data for each record in the table but is not used as the primary key field for security or other reasons. a.backup key b.alternate key c.associate key d.secondary key

alternate key

In Database Design Language (DBDL), which items do you underline? a.columns that make up the foreign key b.table names c.columns that make up the primary key d.data types

columns that make up the primary key

Which of the following is a type of E-R diagram? a.entity tree notation b.Access Database Documenter c.crow's foot notation d.Database Design Language (DBDL)

crow's foot notation

Which fields should you index in a table? a.fields that contain sensitive data b.every field c.fields that are not part of a relationship d.fields that are commonly used for sorting

fields that are commonly used for sorting

What can you create in Access to show data in a single record and all its related records? a.one-to-one relationship b.lookup reports c.related user views d.form and subform

form and subform

Which of the following Access features does not demonstrate the power of one-to-many relationships? a.forms with subforms b.select queries involving related tables c.indexes d.subdatasheets

indexes

How does the Access Relationships window indicate the "many" field in a one-to-many relationship? a.ring and crow's foot b.infinity symbol c.filled circle d.number 1

infinity symbol

A _____ serves on the "many" side of a one-to-many relationship with each of two other tables. a.secondary key b.connecting table c.junction table d.lookup table

junction table

Because you cannot directly create a many-to-many relationship between two tables, what must you create to link the tables together? a.Cartesian join b.junction table c.secondary table d.entity-relationship diagram

junction table

Which of the following Access features provides a drop-down list of values for a field? a.subdatasheet b.Relationship report c.subform d.lookup field

lookup field

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? a.one to many b.many to one c.many to many d.one to one

one to many

What type of relationship do two tables have when their primary keys match? a.many-to-one b.many-to-many c.one-to-many d.one-to-one

one-to-one

Which of the following items is not identified in relational database design documentation? a.primary key field for each entity b.attributes needed for each normalized entity c.proper one-to-many relationships between the entities d.possible user views for each entity

possible user views for each entity

Which field in a table does Access index by default? a.first field in the table b.primary key field c.foreign key field d.any numeric field

primary key field

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. a.referential integrity b.access restrictions c.alternate keys d.cardinality

referential integrity

A(n) _____ represents a field or combination of fields that may not be unique, but is commonly used for retrieval and thus should be indexed. a.combo key b.secondary key c.alternate key d.indexed key

secondary key

In the following Database Design Language (DBDL) notation, what does SK stand for?Employees (EmpID, LastName, FirstName, SSN, DeptNum)AK SSNSK LastName, FirstNameFK DeptNumàDepartments a.subkey b.start key c.secondary key d.SQL key

secondary key

In an entity-relationship model (ERM), what does a diamond represent? a.the "one" part of the relationship b.an entity c.the relationship d.the "many" part of the relationship

the relationship

What is the purpose of an index? a.to identify primary, secondary, and alternate keys b.to improve database performance when queries request a sort order for records c.to show which database objects depend on each other d.to store unique data for each record in the table

to improve database performance when queries request a sort order for records

ProductType is a foreign key field in the Orders table and is constrained to a list of valid entries stored in the ProductTypes table. What problem does this design prevent? a.creation anomalies b.update anomalies c.record locking d.deletion anomalies

update anomalies

Which of the following tools does not help you document relationships between tables? a.entity-relationship model b.entity-relationship diagram c.user views d.Database Design Language

user views

The E-R model (ERM) represents entities, attributes, and _____. a.views b.indexes c.relationships d.properties

relationships

A user view of data is _____. a.a report requested by users b.a form used for data entry c.the specific data needed by a person or process for a particular task d.a table created by a particular user

the specific data needed by a person or process for a particular task

What shape does an E-R diagram use to represent entities? a.oval b.triangle c.diamond d.rectangle

rectangle

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? a.25 b.15 c.4 d.100

100

Which of the following fields would you most likely index but set the index's Unique property to No? a.OfficeNumber b.StreetAddress c.EmployeeID d.LastName

LastName

Which properties do you set to display a list of possible values that are helpful when you enter or update data in a foreign key field? a.Lookup properties b.Subdatasheet properties c.Indexed properties d.Foreign Key List properties

Lookup properties

A query includes the DeptID and DeptName fields from the Departments table and the EmployeeLast field from the Employees table. Both tables are shown below. What must you change before you can reassign the DeptID field value for a particular employee in the query results?Departments (DeptID, DeptName)Employees (EmpID, EmployeeFirst, EmployeeLast, DeptID) a.Remove the EmpID field from the query. b.Replace the DeptID field from the Departments table with the DeptID field from the Employees table. c.Set DeptID as the primary key field in the Employees table. d.Add the DeptName field to the query.

Replace the DeptID field from the Departments table with the DeptID field from the Employees table.

A query includes the DeptID and DeptName fields from the Departments table and the EmployeeLast field from the Employees table. Both tables are shown below. What happens when you update the DeptName field value for an employee?Departments (DeptID, DeptName)Employees (EmpID, EmployeeFirst, EmployeeLast, DeptID) a.Access changes the DeptID field value in the same record. b.The DeptName field value changes for that one employee only. c.The DeptName field value changes for all employees in that department. d.Access displays an error message and does not accept the update.

The DeptName field value changes for all employees in that department.

Which of the following is not true about one-to-many relationships? a.A foreign key field cannot also be the primary key field for a particular table. b.One record in the "one" table can be linked or related to many records in the "many" table. c.The linking field must have the same name in the primary and related tables. d.The linking field in the "one" table is always the primary key field for that table.

The linking field must have the same name in the primary and related tables.

In Access Table Datasheet View, how can you display the records from a related table? a.Right-click a field and then click Relationships on the shortcut menu. b.Click the Related Records button on the ribbon. c.Click the Lookup button on the ribbon. d.Click the expand button to expand a subdatasheet.

Click the expand button to expand a subdatasheet.

When you build a relational database for an organization, what is a good starting point for identifying required user views? a.Video each user. b.Collect the organization's forms and reports. c.Conduct a detailed survey. d.Attend staff meetings.

Collect the organization's forms and reports.

How might you resolve an inappropriate Cartesian join? a.Convert the join type to a RIGHT join. b.Convert the join type to a LEFT join. c.Connect the two tables through a third junction table. d.Change the query to an update query.

Connect the two tables through a third junction table.

Which of the following is a valid reason for creating a one-to-one relationship between two tables? a.Data needs to be imported from separate sources. b.The tables create a Cartesian join. c.One table would otherwise not participate in a relationship. d.The tables are rarely updated.

Data needs to be imported from separate sources.


Related study sets

Business Ethics and Corporate Responsibility

View Set

Types of Life Policies (chapter 4)

View Set

Intro to the Qur'an Ross Final Study Guide

View Set

Chpt 7: Becoming Ethical" The Development of Morality

View Set

Chapter 2: The Logic of Compound Statements

View Set

Fahmy 3030 Langenscheidt Grundwortschatz Englisch Teil 1

View Set