30 Jan schema integrity.

CIS321 Structured Analysis & Design

Week 4 Quiz

Question 1

(TCOs 9 and 10) The value that is recorded in an attribute if a user does not specify one is known as the

domain.

key.

default value.

data type.

None of the above

Question 2

(TCOs 9 and 10) Which of the following is a category of entities?

Person

Place

Object

Concept

All of the above

Question 3

(TCOs 9 and 10) Pointers to the records of a different file in a database; they are used to link records of one type to those of another type.

Attributes

Referential pointers

Descriptive fields

Foreign keys

None of the above

Question 4

(TCOs 9 and 10) Which of the following is a criterion for making a good data model?

A good data model is simple.

A good data model is essentially nonredundant.

A good data model should be flexible and adaptable to future needs.

Each data attribute should describe at most one entity.

All of the above

Question 5

(TCOs 9 and 10) Which of the following is NOT a guideline for creating a business coding scheme?

Codes should be expandable to accommodate growth.

The full code must result in redundant values for entities.

Codes should be large enough to describe distinguishing characteristics but small enough to be interpreted by a person without a computer.

Codes should be convenient.

All of the above

Question 6

(TCOs 9 and 10) Fields whose values identify one and only one record in a file are called

foreign keys.

primary keys.

alternative keys.

concatenated keys.

None of the above

Question 7

(TCOs 9 and 10) Which defines the minimum and maximum number of occurrences of one entity that may be related to a single occurrence of the other entity?

Domain

Concatenation

Associative entity

Cardinality

None of the above

Question 8

(TCOs 9 and 10) A ternary relationship is

recursive.

reflexive.

between three entities.

not possible in data modeling.

None of the above

Question 9

(TCOs 9 and 10) In the relationship between cities and residents, the resident entity would be

the child.

the parent.

nonspecific.

the subtype.

the supertype.

Question 10

(TCOs 9 and 10) The process that prepares a data model for implementation as a simple, nonredundant, flexible, and adaptable database is known as

process analysis.

requirements analysis.

data analysis.

generalization.

None of the above

Question 11

(TCOs 9 and 10) A table in which rows indicate entities (and possible attributes), the columns indicate locations, and the cells indicate the document level of access, including create, read, update, or delete, is known as

an entity relationship table.

a transitive dependency table.

a data-to-location CRUD matrix.

a decision table.

None of the above

Question 12

(TCOs 9 and 10) The EmployeeID field in an employee table cannot be left blank. This is an example of

key integrity.

domain integrity.

referential integrity.

logical integrity.

schema integrity.

Question 13

(TCOs 9 and 10) What attributes would you have in a table to describe an entity called Course? What would you use as the primary key? What would be the relationship between Grade and Course? Assume that a Course can have a grade for each student in the Course.

the attribute that i may be able to use to describe the entity course would be credithours and coursetitle. the primary key that i would use is CourseID. the relationship would be one to many.

Course would have the Course number as the primary key, course name, Room, session, start time, end time, and GradeKey.

Course and Grade are in a one-to-many relationship.