BMIS 325 Midterm

PARTIAL DEPENDENCIES

When a non-key field depends on only part of a primary key

TRANSITIVE DEPENDENCY:

When a non-key field is determined by another non-key field

40. A table MOVIES in an object-oriented database consists of the attributes title (the primary key), year_produced, and actor_name.. Actor_name is a repeating group. Different movies may have different numbers of actors. The table MOVIES violates the following normal form (choose the lowest one): a. 1NF b. 2NF c. 3NF d. 4NF

a. 1NF

34. A table that satisfies 2NF: a. Always satisfies 1NF. b. May violate 1NF. c. Always satisfies 3NF. d. None of the above

a. Always satisfies 1NF.

A table that satisfies BCNF: a. Always satisfies 3NF. b. May violate 3NF. c. May satisfy 3NF. d. None of the above

a. Always satisfies 3NF.

Which of the following statements is not true of information resource management? a. It is very different and much more challenging than managing the other physical resources of an organization. b. Its goal is to use information technology as a tool for processing, distributing, and integrating information throughout an organization. c. Its emergence has created new management responsibilities. d. None of the above.

a. It is very different and much more challenging than managing the other physical resources of an organization.

When converting the ERD to a relational table, how many non-key attributes will the RoomAssign table have? a. One b. Two c. Three d. Four

a. One

In the traditional Systems Development Life Cycle, databases are actually produced during the following phase: a. Systems Implementation b. Systems Analysis c. Systems Design d. Maintenance

a. Systems Implementation

When mapping a supertype/subtype relationship, which of the following is true? a. The supertype primary key is assigned to each subtype. b. The subtype primary key is assigned to each supertype. c. There is no link between the supertype/subtype entities. d. There is no primary key/foreign key relationship between a supertype/subtype.

a. The supertype primary key is assigned to each subtype.

A foreign key may be null and still adhere to the referential integrity constraint. a. True b. False

a. True

Boyce-Codd normal form is stronger than 3NF. a. True b. False

a. True

Two tables that are not union compatible can be made union compatible using the project operator. a. True b. False

a. True

1. The relational model consists of: a. data in the form of tables b. data redundancy c. operations using non-SQL languages d. unorganized data

a. data in the form of tables

The entity integrity rule states that: a. no primary key attribute may be null. b. no primary key can be composite. c. no primary key may be unique. d. no primary key may be equal to a value in a foreign key

a. no primary key attribute may be null.

Relations are: a. two-dimensional tables b. three-dimensional tables c. four-dimensional tables d. five-dimensional tables

a. two-dimensional tables

33. A transitive dependency is which of the following? a. A functional dependency between two or more key attributes. ?????? b. A functional dependency between two or more nonkey attributes. c. A relation that is in first normal form. d. A relation that is in second normal form.

b. A functional dependency between two or more nonkey attributes.

When the referential integrity rule is enforced, which one is usually not a wise action in response to the deletion of a row that contains a primary key value referenced elsewhere? a. Do not allow the deletion b. Accept the deletion without any other action c. Delete the related rows d. Set the foreign keys of related rows to null

b. Accept the deletion without any other action

A primary key is which of the following? a. Any attribute b. An attribute that uniquely identifies each row c. An attribute that uniquely identifies each column d. A derived attribute.

b. An attribute that uniquely identifies each row

23. Union compatibility requires that each table must have the same number of columns, but the corresponding columns can have different data types because the DBMS will convert them during query execution. a.. True b. False

b. False

A primary key may be null. a. True b. False

b. False

When transforming an ERD into a relational table design, the primary key of the child side of a 1-M relationship (the many side) will become a foreign key in the 1 side of the relationship. a. True b. False

b. False

Which of the following is not true of a DBMS? a. It provides efficient storage and retrieval of data. b. It has evolved over the years into a fairly simple set of tools that are relatively easy to master. c. Marketplace demands and product innovation have led to the development of a broad range of features. d. None of the above

b. It has evolved over the years into a fairly simple set of tools that are relatively easy to master.

The main purpose of relational schema normalization is to: a. Improve speed b. Remove duplication of information c. Make SQL queries easier to write d. Make deletion easier

b. Remove duplication of information

31. A relation is in 1NF if it doesn't contain any ____________? a. Determinants b. Repeating Groups c. Null values in primary key fields d. Functional dependencies

b. Repeating Groups

38. If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form? a. First normal form b. Second normal form c. Third normal form d. Boyce-Codd normal form

b. Second normal form

A null value indicates: a. A numeric value with value 0 b. The absence of a value c. A very small value d. An erroneous value

b. The absence of a value

15. Which one of the following indicates poor data quality? a. The business rule that an employee must belong to a department is enforced by the database. b. The same supplier is shown with two different addresses in two parts of the database. c. Two similar items have two different prices in the supermarket and in the database. d. New prices in a supermarket are updated in a timely fashion in the database.

b. The same supplier is shown with two different addresses in two parts of the database.

A foreign key is which of the following? a. Any attribute b. The same thing as a primary key c. An attribute that serves as the primary key of another relation d. An attribute that serves no purpose

c. An attribute that serves as the primary key of another relation

A table in a database has which of the following properties? a. Each row is not unique b. Attributes can have the same name within a given table. c. Each table has a unique name d. The order of the columns is significant.

c. Each table has a unique name

37. A table in 1NF in which the unique candidate key consists of two of its three attributes: a. Always violates 2NF. b. Never violates 2NF. c. May violate 2NF. d. None of the above

c. May violate 2NF.

For a violation of 2NF to occur in a table in 1NF, the following condition(s) must exist: a. There must be some specific non-trivial multi-valued dependencies. b. There must be transitive dependencies. c. Part of a key determines a nonkey attribute. d. All of the above

c. Part of a key determines a nonkey attribute.

When converting the following ERD to a relational table, what would be the primary key of the Room table? a. Room_Number b. Building_Number c. The combination of Room_Number and Building_Number d. None of the above

c. The combination of Room_Number and Building_Number

When applying the M-M relationship rule for converting an ERD into a relational table design, which of the following statements is true? a. Each M-N relationship becomes a separate table. b. The primary key of the table is the primary key of the entity type participating in the M-N relationship which has the most attributes. c. The primary key of the table is a combined key consisting of the primary keys of the entity types participating in the M-N relationship. d. A and C.

d. A and C.

In the relational database terminology, a table is synonymous with: a. A column b. A row c. An attribute d. A relation

d. A relation

13. In a systems development methodology, the following graphical model should be produced: a. Data model b. Process model c. Environment interaction model d. All of the above

d. All of the above

Which of the following is a type of anomaly that can occur when a relation is not normalized. a. Insertion b. Deletion c. Modification d. All of the above anomalies can occur when a table is not normalized.

d. All of the above anomalies can occur when a table is not normalized.

17. Relationship cardinalities: a. Constrain the number of objects that participate in a relationship. b. Are shown for both directions of a relationship. c. Indicate whether a relationship is mandatory or optional. d. All of the above.

d. All of the above.

25. For the generalization hierarchy rule, which of the following is true? a. Each entity type of a generalization hierarchy becomes a table. b. The columns of a table are the attributes of the corresponding entity type plus the primary key of the parent entity type. c. For each table representing a subtype, define a foreign key constraint that references the table corresponding to the parent entity type. d. All of the above.

d. All of the above.

Nonprocedural access to a database a. Can provide a dramatic improvement in software productivity. b. Allows a user to submit queries to a database without having to know how the data will be retrieved. c. Is supported by more than one tool in most DBMSs. d. All of the above.

d. All of the above.

When trying to determine a primary key for an entity, what characteristics of an attribute make an attribute a potential primary key? a. The attribute should be unique for all instances of an entity. b. The attribute should be stable (not an attribute that changes value over time). c. The attribute should be single purpose (used for identification of an entity instance, not other purposes). d. All of the above.

d. All of the above.

With respect to transaction processing, any DBMS should be capable of a. Ensuring that transactions are free from interference from other users. b. Parts of a transaction are not lost due to a failure. c. Transactions do not make the database inconsistent. d. All of the above.

d. All of the above.

16. A goal of normalization is to: a. Minimize the number of relationships b. Minimize the number of entities c. Minimize the number of tables d. Minimize data redundancy

d. Minimize data redundancy

When converting the ERD to a relational table, what would be the primary key of the RoomAssign table? a. Room_Number b. Date_Assigned c. The combination of Faculty_ID and Room_Number d. The combination of Faculty_ID, Room_Number, Building _Number

d. The combination of Faculty_ID, Room_Number, Building _Number

32. A table is in 2NF if the table is in 1NF and what other condition is met? a. There are no functional dependencies. b. There are no null values in primary key fields. c. There are no repeating groups. d. There are no attributes that are functionally dependent on only part of the relation's primary key.

d. There are no attributes that are functionally dependent on only part of the relation's primary key.

27. Which of the following should be included in design documentation? a. decisions that might be unclear to others even if there are no feasible alternatives b. documentation of inconsistency in a specification c. documentation of incompleteness in a specification d. all of the above.

d. all of the above.

1. What are the three characteristics of a database?

persistent Shared interrelated

2ND NORMAL FORM:

A table that has No PARTIAL DEPENDENCIES

3RD NORMAL FORM:

A table that has No TRANSITIVE DEPENDENCIES

1ST NORMAL FORM:

A table that has no repeating GROUPS (values within a single cell in a row)

A support position that specializes in managing individuals databases and DBMSs.

Database administrator

A support position that specializes in managing individuals, databases, and DBMSs.

Database administrator

2. List six common features of most DBMSs.

Database definition Non-procedural access Application development Procedural language interface Transaction processing Database tuning

A graphical representation that depicts things of interest (entities) and relationships among entities

Entity Relationship Model

Model that describes relationships between events and processes

Environment interaction model

describes relationships between events and processes

Environment interaction model

3. List the three levels of database description in the Three Schema Architecture.

External Conceptual Internal

Converting from an ERD to a table design.

Forward Engineering

Quantitative, objective and data intensive skills

Hard skills

A language, such as SQL, that allows you to specify the parts of a database to access rather than to code a complex procedure.

Non-procedural database language

Activity that removes redundancy in a table design

Normalization

describes relationships among processes

Process model

A scaled down version of a system, usually implemented quickly and used to clarify requirements

Prototype

An industry standard database language that includes statements for database definition, database manipulation, and database control.

SQL

A database description

Schema

A set of related components that work together to accomplish some objective

System

A named, two-dimensional arrangement of data consisting of a heading part and a body part.

Table

An industry standard database language that includes statements for database definition, database manipulation, and database control.

Table

List four goals of database development.

The database should serve a large community of users Support Organizational Policies Contain high quality data_ Provide efficient access

4. What is the goal of information resource management?

To use information technology as a tool for processing, distributing, and integrating information throughout an organization

Reliable and efficient processing of large volumes of repetitive work. DBMSs ensure that simultaneous users do not interfere with each other and that failures do not cause lost work.

Transaction processing

Computer-aided software engineering applications that help improve the productivity of information systems professional working on large projects.

CASE tools

An arrangement of components (clients and servers) and data among computers connected by a network. It supports efficient processing of messages between clients and servers.

Client-server architecture

2. List the six common characteristics of data quality.

Completeness Lack of ambiguity Correctness Timeliness Reliability Consistency

six common characteristics of data quality

Completeness Lack of ambiguity Correctness Timeliness Reliability Consistency

1. What are the four phases of database development?

Conceptual Data Modeling Logical Database Design Distributed Database Design Physical Database Design

Activity that produces a table design from an ERD

Conversion

A collection of components that support data acquisition, dissemination, maintenance, retrieval, and formatting.

DBMS

A management position that performs planning and policy setting for the information resources of an entire organization.

Data administrator

A database should have an identity separate from the applications (computer programs, forms, and reports) that use it. The separate identity allows the database definition to be changed without affecting related applications.

Data independence

Model that describes kinds of data and relationships among data

Data model

describes kinds of data and relationships

Data model