Design: Chapter 6 – Database Design: Design Method

Nov 19th, 2023

4.7 (114 reviews)

30 test answers

question

A set of requirements that is necessary to support the operations of a particular database user is known as a(n) ____.a. user viewb. user tablec. user attributed. user field

answer

a. user view

question

The properties of the entities you choose as you design the user view will become the ____ in the appropriate tables.a. rowsb. columnsc. datad. DBMS

answer

b. columns

question

If each employee works in a single department and each department has only one employee, the relationship between employees and departments is ____.a. one-to-oneb. one-to-manyc. many-to-oned. many-to-many

answer

a. one to one

question

A(n) ____ is a primary key that consists of a column that uniquely identifies an entity, such as a person's Social Security number.a. surrogate keyb. weak entityc. artificial keyd. natural key

answer

d. natural key

question

A column that you create for an entity to serve solely as the primary key and that is visible to users is called a(n) ____.a. synthetic keyb. weak entityc. artificial keyd. natural key

answer

c. artificial key

question

A(n) ____ is a system-generated primary key that is usually hidden from users.a. weak entityb. surrogate keyc. natural keyd. artificial key

answer

b. surrogate key

question

When a DBMS creates a(n) ____ key, it is usually an automatic numbering data type, such as the Access AutoNumber data type.a. surrogateb. artificialc. naturald. logical

answer

a. surrogate

question

A natural key is also called a(n) ____ key.a. Surrogateb. Intelligentc. Secondaryd. Defining

answer

b. Intelligent

question

Which of the following shows sample DBDL documentation for the Employee table?a. Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode)b. Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode)c. Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode, (WageRate, SocSecNum, DepartmentNum) )d. Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode, WageRate, SocSecNum, DepartmentNum)AK SocSecNumSK LastNameFK DepartmentNum→Department

answer

Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode, WageRate, SocSecNum, DepartmentNum)AK SocSecNumSK LastNameFK DepartmentNum→Department

question

An alternative to the primary key of a table is listed with the ____ abbreviation in DBDL.a. SKb. FKc. PKd. AK

answer

d. AK

question

Combining the following two tables would result in ____.Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum)Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode) a. Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, (Street, City, PostalCode) )b. Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, Street, City, State, PostalCode)c. Employee (EmployeeNum, LastName, FirstName, Street, City State, PostalCode, WageRate, SocSecNum)d. Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, EmployeeNum, LastName, FirstName, Street, City, State, PostalCode )

answer

Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, Street, City, State, PostalCode)

question

Independent entities have ____ in an E-R diagrama. dashed bordersb. dark backgroundsc. square cornersd. rounded corners

answer

c. square corners

question

An entity that does not require a relationship to another entity for identification is called a(n) ____.a. alternative entityb. foreign entityc. independent entityd. single entity

answer

c. independent entity

question

A relationship that is necessary for identification is called a(n) ____.a. objectifying relationshipb. merging relationshipc. identifying relationshipd. referential relationship

answer

c. identifying relationship

question

Convert the following table to first normal form:Branch (BranchNum, BranchName, (BookCode, Title, OnHand) ) a. Branch (BranchNum, BranchName)Book (BookCode, Title) b. Branch (BranchNum, BranchName)c. Book (BookCode, Title)d. Branch (BranchNum, BranchName, BookCode, Title, OnHand )

answer

Branch (BranchNum, BranchName, BookCode, Title, OnHand )

question

When implementing the physical-level design, for secondary keys, you must ensure that it is possible to retrieve data rapidly on the basis of a value of the ____ key.a. primaryb. secondaryc. alternated. foreign

answer

b. secondary

question

After the information-level design is completed, ____ is the next step.a. The physical-level designb. The modality-level designc. The DBMS-level designd. The table-level design

answer

a. the physical- level design

question

When designing a database, you might find it helpful to design a(n) ____ to obtain the required information from users.a. E-R diagramb. tablec. reportd. survey form

answer

d. survey form

question

The type of information collected on the survey form that describes how data is updated is ____.a. Attribute informationb. Processing informationc. Relationshipsd. Entity information

answer

b. processing information

question

The crucial issue in making the determination between a single many-to-many-to-many relationship and two (or three) many-to-many relationships is the ____.a. independenceb. data dependencec. redundancyd. cardinality

answer

a. independence

question

If a many-to-many-to-many relationship is created when it is not appropriate to do so, the conversion to ____ normal form will correct the problem.a. firstb. secondc. thirdd. fourth

answer

d. fourth

question

A subtype is called a(n) ____ in IDEF1X terminology.a. dependentb. inner typec. specificationd. category

answer

d. category

question

In IDEF1X, the ____ is the symbol for category.a. squareb. rectanglec. diamondd. circle

answer

d. circle

question

Complete categories are represented by ____ line(s) below the category symbol.a. oneb. twoc. threed. four

answer

b. two

question

Inthe standard E-R diagrams, relationships are drawn as ____, with lines connecting the entities involved in relationships. a. rectanglesb. diamondsc. circlesd. squares

answer

b. diamonds

question

An entity that exists to implement a many-to-many relationship is called a(n) ____.a. composite entityb. complex entityc. complicated entityd. circular entity

answer

a. composite entity

question

On an E-R diagram, the number closest to the rectangle represents ____ cardinality.a. maximumb. minimumc. midvalued. smallest

answer

a. maximum

question

On an E-R diagram, the number closest to the relationship represents ____ cardinality.a. maximumb. minimumc. midvalued. largest

answer

minimum

question

____ means that an entity has a minimum cardinality of zero. a. The entity has a mandatory role in the relationship.b. The entity is not required in the relationship.c. The entity should not be in the relationship as an attribute.d. The entity must be listed with all zeroes in the data fields.

answer

b. The entity is not required in the relationship.

question

____ means that an entity has a minimum cardinality of one.a. The entity is required in the relationship.b. The entity is not required in the relationship.c. The entity should not be in the relationship as an attribute.d. The entity must be listed with all ones in the data fields.

answer

a. The entity is required in the relationship.

1 of 30

question

A set of requirements that is necessary to support the operations of a particular database user is known as a(n) ____.a. user viewb. user tablec. user attributed. user field

answer

a. user view

question

The properties of the entities you choose as you design the user view will become the ____ in the appropriate tables.a. rowsb. columnsc. datad. DBMS

answer

b. columns

question

answer

a. one to one

question

A(n) ____ is a primary key that consists of a column that uniquely identifies an entity, such as a person's Social Security number.a. surrogate keyb. weak entityc. artificial keyd. natural key

answer

d. natural key

Don’t waste time

You can get a custom paper by one of our expert writers.

Get your custom essay

Helping students since 2015

question

A column that you create for an entity to serve solely as the primary key and that is visible to users is called a(n) ____.a. synthetic keyb. weak entityc. artificial keyd. natural key

answer

c. artificial key

question

A(n) ____ is a system-generated primary key that is usually hidden from users.a. weak entityb. surrogate keyc. natural keyd. artificial key

answer

b. surrogate key

question

When a DBMS creates a(n) ____ key, it is usually an automatic numbering data type, such as the Access AutoNumber data type.a. surrogateb. artificialc. naturald. logical

answer

a. surrogate

question

A natural key is also called a(n) ____ key.a. Surrogateb. Intelligentc. Secondaryd. Defining

answer

b. Intelligent

question

answer

Employee (EmployeeNum, LastName, FirstName, Street, City, State, PostalCode, WageRate, SocSecNum, DepartmentNum)AK SocSecNumSK LastNameFK DepartmentNum→Department

question

An alternative to the primary key of a table is listed with the ____ abbreviation in DBDL.a. SKb. FKc. PKd. AK

answer

d. AK

question

answer

Employee (EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, Street, City, State, PostalCode)

question

Independent entities have ____ in an E-R diagrama. dashed bordersb. dark backgroundsc. square cornersd. rounded corners

answer

c. square corners

question

An entity that does not require a relationship to another entity for identification is called a(n) ____.a. alternative entityb. foreign entityc. independent entityd. single entity

answer

c. independent entity

question

A relationship that is necessary for identification is called a(n) ____.a. objectifying relationshipb. merging relationshipc. identifying relationshipd. referential relationship

answer

c. identifying relationship

question

answer

Branch (BranchNum, BranchName, BookCode, Title, OnHand )

question

answer

b. secondary

question

After the information-level design is completed, ____ is the next step.a. The physical-level designb. The modality-level designc. The DBMS-level designd. The table-level design

answer

a. the physical- level design

question

When designing a database, you might find it helpful to design a(n) ____ to obtain the required information from users.a. E-R diagramb. tablec. reportd. survey form

answer

d. survey form

question

The type of information collected on the survey form that describes how data is updated is ____.a. Attribute informationb. Processing informationc. Relationshipsd. Entity information

answer

b. processing information

question

answer

a. independence

question

If a many-to-many-to-many relationship is created when it is not appropriate to do so, the conversion to ____ normal form will correct the problem.a. firstb. secondc. thirdd. fourth

answer

d. fourth

question

A subtype is called a(n) ____ in IDEF1X terminology.a. dependentb. inner typec. specificationd. category

answer

d. category

question

In IDEF1X, the ____ is the symbol for category.a. squareb. rectanglec. diamondd. circle

answer

d. circle

question

Complete categories are represented by ____ line(s) below the category symbol.a. oneb. twoc. threed. four

answer

b. two

question

Inthe standard E-R diagrams, relationships are drawn as ____, with lines connecting the entities involved in relationships. a. rectanglesb. diamondsc. circlesd. squares

answer

b. diamonds

question

An entity that exists to implement a many-to-many relationship is called a(n) ____.a. composite entityb. complex entityc. complicated entityd. circular entity

answer

a. composite entity

question

On an E-R diagram, the number closest to the rectangle represents ____ cardinality.a. maximumb. minimumc. midvalued. smallest

answer

a. maximum

question

On an E-R diagram, the number closest to the relationship represents ____ cardinality.a. maximumb. minimumc. midvalued. largest

answer

minimum

question

answer

b. The entity is not required in the relationship.

question

answer

a. The entity is required in the relationship.

Design: Chapter 6 – Database Design: Design Method

Haven't found what you need?