Deck 6: Database Design 2: Design Method

Question 1

The use of an "m" and an "n" in an E-R diagram indicates a many-to-many relationship.

Answer 1

True

Question 2

In an entity-relationship diagram,there is no way to visually determine the primary key.

Answer 2

False

Question 3

When you use an E-R diagram to represent a database,it visually illustrates all the information listed in the DBDL.

Answer 3

True

Question 4

The simplest way to implement a one-to-one relationship is to treat it as a one-to-many relationship.

Question 5

The second step in creating a user view is to normalize the tables.

Question 6

In a one-to-many relationship,the primary key of the "many" table becomes the foreign key of the "one" table.

Question 7

When you combine third normal form tables,the result will always be in third normal form.

Question 8

An entity that depends on another entity for its own existence is called a weak entity.

Question 9

The basic relationships among entities are: one-to-many,many-to-many,and one-to-one.

Question 10

The information-level design methodology involves representing the individual user view as a collection of tables,refining them to eliminate any problems,and then merging them into a cumulative design.

Question 11

The second step in creating a user view is to identify all keys in the tables.

Question 12

A secondary key is a column or collection of columns in one table that is required to match the value of the primary key for some row in another table,or be null.

Question 13

In DBDL,you represent a table by listing all columns and then underlining the primary key.

Question 14

You create a many-to-many relationship by creating a new table whose primary key is the combination of the primary keys of the original tables.

Question 15

When provided with a user view or some sort of stated requirement,you must develop a collection of tables that will support it.

Question 16

An entity that exists to implement a many-to-many relationship is called a multivalued entity.

Question 17

When creating user views,a "user" can be a report that the system must produce,or a type of transaction the system must support.

Question 18

A design that supports all user views is called a normalized design.

Question 19

Entity integrity is the property that states that a secondary key in one table is required to match the value of the primary key for some row in another table or is required to be null.

Question 20

Nulls are used when a value is either unknown or inapplicable.

Question 21

Convert the following table to first normal form: Branch (BranchNum,BranchName,(BookCode,Title,CopyNum,Quality,Price) )

A)Branch (BranchNum,BranchName) Book (BookCode,Title,CopyNum)
B)Branch (BranchNum,BranchName)
C)Book (BookCode,Title,Copynum)
D)Branch (BranchNum,BranchName,BookCode,Title,CopyNum,Quality,Price)

Question 22

After the information-level design is completed,the ____ is the next step.

A)physical-level design
B)modality-level design
C)DBMS-level design
D)table-level design

Question 23

The properties of the entities you choose as you design the user view will become the ____ in the appropriate tables.

A)rows
B)columns
C)records
D)tuples

Question 24

Independent entities have ____ in an E-R diagram.

A)dashed borders
B)dark backgrounds
C)square corners
D)rounded corners

Question 25

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)independence
B)data dependence
C)redundancy
D)cardinality

Question 26

The type of information collected on the survey form that describes reports that must be produced is ____.

A)attribute information
B)processing information
C)relationship information
D)entity information

Question 27

When implementing the physical-level design,you must ensure that it is possible to retrieve data rapidly on the basis of a value of any ____ keys.

A)primary
B)secondary
C)alternate
D)foreign

Question 28

A natural key is also called a(n) ____ key.

A)surrogate
B)intelligent
C)secondary
D)synthetic

Question 29

The following is an example of DBDL documentation for an Employee table ____.

A)Employee (EmployeeNum,LastName,FirstName,Street,City,State,Zip)
B)Employee (EmployeeNum,LastName,FirstName,Street,City,State,Zip)
C)Employee (EmployeeNum,LastName,FirstName,Street,City,State,Zip,(WageRate,SocSecNum,DepartmentNum) )
D)Employee (EmployeeNum,LastName,FirstName,Street,City,State,Zip,WageRate,SocSecNum,DepartmentNum) AK SocSecNum
SK LastName
FK DepartmentNum ® Department

Question 30

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 key
B)surrogate key
C)artificial key
D)natural key

Question 31

A relationship that is necessary for identification is called a(n) ____.

A)objectifying relationship
B)merging relationship
C)identifying relationship
D)referential relationship

Question 32

An entity that does not require a relationship to another entity for identification is called a(n) ____.

A)alternative entity
B)foreign entity
C)independent entity
D)single entity

Question 33

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

A)SK
B)FK
C)PK
D)AK

Question 34

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-one
B)one-to-many
C)many-to-one
D)many-to-many

Question 35

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 key
B)synthetic key
C)artificial key
D)natural key

Question 36

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

A)surrogate
B)artificial
C)natural
D)logical

Question 37

A(n) ____ is a system-generated primary key that is usually hidden from users.

A)logical key
B)surrogate key
C)natural key
D)artificial key

Question 38

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

A)user view
B)user snapshot
C)user window
D)user system

Question 39

If you combine the two tables shown above,the result would be ____.

A)Employee (EmployeeNum,LastName,FirstName,WageRate,SocSecNum,DepartmentNum,(Street,City,Zip) )
B)Employee (EmployeeNum,LastName,FirstName,WageRate,SocSecNum,DepartmentNum,Street,City,State,Zip)
C)Employee (EmployeeNum,LastName,FirstName,Street,City State,Zip,WageRate,SocSecNum)
D)Employee (EmployeeNum,LastName,FirstName,WageRate,SocSecNum,DepartmentNum,EmployeeNum,LastName,FirstName,Street,City,State,Zip )

Question 40

When designing a database,you might find it helpful to design a(n) ____ to obtain the required information from users.

A)E-R diagram
B)IDEF1X diagram
C)report
D)survey form

Question 41

The style of E-R diagram used in the text is ____________________.

Question 42

For each table in a database,you must identify the primary key and any alternate keys,secondary keys,and ____________________ keys.

Question 43

____ 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

Question 44

Foreign keys allow you to create relationships among tables and enforce certain types of ____________________ constraints in a database.

Question 45

If you have alternate keys for a table,you should create a(n) ____________________ index for each alternate key.

Question 46

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)first
B)second
C)third
D)fourth

Question 47

The ____________________ design method begins with a general database design that models the overall enterprise and repeatedly refines the model to achieve a design that supports all necessary applications.

Question 48

In the standard E-R diagrams,relationships are drawn as ____,with lines connecting the entities involved in relationships.

A)rectangles
B)diamonds
C)circles
D)squares

Question 49

A subtype is also called a(n) ____ in IDEF1X terminology.

A)dependent
B)inner type
C)specification
D)category

Question 50

During the ____________________-level design,designers must consider the characteristics of the particular DBMS that the organization will use.

Question 51

Columns in a table that are of interest strictly for the purpose of retrieval are known as ____________________.

Question 52

On an E-R diagram,the number closest to the relationship represents ____ cardinality.

A)maximum
B)minimum
C)midvalue
D)largest

Question 53

On an E-R diagram,____________________ entities have rounded corners.

Question 54

In IDEF1X,the ____ is the symbol for category.

A)square
B)rectangle
C)diamond
D)circle

Question 55

In the ____________________ design method,specific user requirements are synthesized into a design.

Question 56

In IEDF1X,complete categories are represented by ____ horizontal line(s) below the category symbol.

A)one
B)two
C)three
D)four

Question 57

On an E-R diagram,the number closest to the rectangle represents ____ cardinality.

A)maximum
B)minimum
C)midvalue
D)smallest

Question 58

____ 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

Question 59

A relationship that is not necessary for identification is called a(n) ____________________ relationship.

Question 60

An entity that exists to implement a many-to-many relationship is called a(n) ____.

A)composite entity
B)complex entity
C)complicated entity
D)circular entity

Question 61

One way to indicate a one-to-many relationship is to place a crow's foot at the ____________________ end of the relationship.

Question 62

There are three different types of primary keys: natural keys,artificial keys,and surrogate keys. Describe each of these types.

Question 63

____________________ refers to the number of items that must be included in a relationship.

Question 64

To obtain information about ____________________ you might ask users questions such as: "If you know a particular employee number,can you establish other information,such as employee name?"

Question 65

A(n) ____________________ is essentially both an entity and a relationship and is represented in an E-R diagram by a diamond within a rectangle.

Question 66

Explain the difference between a minimum cardinality of zero and a minimum cardinality of one.

Question 67

A weak entity corresponds to the term ____________________.

Question 68

When the existence of one entity depends on the existence of another related entity,there is a(n) ____________________.

Question 69

You can recognize entity subtypes by the fact the primary key is also a(n) ____________________.

Question 70

A(n) ____________________ is a special value that represents the absence of a value in a field.

Question 71

An entity-relationship (E-R) model is an approach to representing data in a(n) ____________________.

Question 72

An entity that depends on another entity for its own existence is called a(n) ____________________.

Question 73

List the steps that must be followed for each user view,as suggested by the information-level design methodology.

Question 74

What type of information should be included on a survey form in order for it to be considered valuable to the design process?

Question 75

The basic relationships are one-to-many,many-to-many,and one-to-one. How do you create each type of relationship in the information-level design?