Database Management Chapter 6
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.