Database Concepts Ch1

What is added to a relational database to eliminate many-to-many relationships? bridging table transitive dependency primary entity secondary entity

Data in first normal form (1NF) does not contain which of the following? primary key repeating groups partial dependencies both a and b

Which of the following is not a step in the Systems Development Life Cycle (SDLC)? systems analysis systems investigation systems design all of the above are steps in the SDLC

In an E-R Model a person, place, or thing with characteristics to be stored in the database are referred to as? entity row attribute file

Which of the following committees are responsible for establishing SQL guidelines? ANSI and ASCII ANSI and ISO IEEE and OSI OSI and ASCII

Which of the following terms best describes where a group of characters that represents a customer's address would be stored in the logical design? record file field database

Which of the following terms is considered the basic unit of data in a database? character field record file

A foreign key is usually found on which side of a relationship? one many unnormalized primary entity

In which step of the Systems Development Life Cycle (SDLC) is the system actually used by the end-user on a regular basis? systems investigation systems analysis systems deployment systems implementation and review

Data mining refers to ____. discovering new data to include in the database analyzing data already stored in a database selling data to other organizations all of the above

Partial dependency exists if what conditions exist? a column is dependent on a portion of the table that is not identified as the primary key a column is dependent only on a portion of a composite primary key the data contains repeating groups the table is not in first normal form (1NF)

Which of the following may contain partial dependencies, but cannot contain repeating groups? unnormalized data first normal form (1NF) second normal form (2NF) third normal form (3NF)

Analyzing historical sales data stored in a database is commonly referred to as ____. data storage data mining data manipulation archived data

Which of the following may contain transitive dependencies, but not partial dependencies? unnormalized data first normal form (1NF) second normal form (2NF) third normal form (3NF)

Which of the following does not contain repeating groups, but has a primary key and possibly partial dependencies? unnormalized data first normal form (1NF) second normal form (2NF) third normal form (3NF)

What represents a characteristic or attribute that is being collected about an entity? record row field both a and b

If the data has no partial dependencies, repeating groups, or transitive dependencies, and has a composite primary key, the data is in which form? first normal second normal third normal unnormalized

The multi-step process used when creating a new system is referred to as ____. the Systems Development Life Cycle data mining E-R Modeling SQL

Which of the following can be used to link the data in two or more tables together? repeating group relationships SDLC common field

In which step of the Systems Development Life Cycle (SDLC) are the logical and physical components defined? systems recovery systems analysis systems design systems implementation and review

Which of the following can lead to partial dependencies? composite primary key common fields foreign keys normalization

A field in the logical design of a database corresponds to a ____ in the physical database. column row table file

Which of the following is an example of an attribute? a person's hair color the people who live in a particular town the patients in a doctor's office vendors

Which of the following is used to create and maintain the physical database? Data mining Database Management System (DBMS) E-R Model Systems Development Life Cycle (SDLC)

A ____ is a storage structure designed to hold a collection of data. column row table database

Which of the following is an interface tool that allows a user to create, edit, and manipulate data in Oracle11g? SQL SQL*Plus ASCII Script