A form of database specification which maps conceptual requirements is called:

Data is represented in the form of: A)data trees. B)tables. C)data notes. D)chairs.

A two-dimensional table of data sometimes is called a: A)group. B)set. C)declaration. D)relation.

________ is a component of the relational data model included to specify business rules to maintain the integrity of data when they are manipulated.

An attribute (or attributes) that uniquely identifies each row in a relation is called a: A)column. B)foreign field. C)primary key. D)duplicate key.

An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a:

A primary key whose value is unique across all relations is called a(n):

A primary key that consists of more than one attribute is called a:

In the SQL language, the ________ statement is used to make table definitions.

Which of the following is NOT a reason to create an instance of a relational schema with sample data?

A domain definition consists of all of the following components EXCEPT:

Which of the following are properties of relations?

Which of the following violates the atomic property of relations?

The entity integrity rule states that: A)no primary key attribute can be null.

The ________ states that no primary key attribute may be null.

All of the following are the main goals of normalization EXCEPT:

When all multivalued attributes have been removed from a relation, it is said to be in:

A relation that contains no multivalued attributes and has non-key attributes solely dependent on the primary key but contains transitive dependencies is in which normal form?

A constraint between two attributes is called a(n):

 A candidate key must satisfy all of the following conditions EXCEPT:

The attribute on the left-hand side of the arrow in a functional dependency is the:

A functional dependency in which one or more non-key attributes are functionally dependent on part, but not all, of the primary key is called a________ dependency.

A functional dependency between two or more non-key attributes is called a:

________ problems are encountered when removing data with transitive dependencies.

A relation that contains minimal redundancy and allows easy use is considered to be:

The logical representation of an organization's data is called a(n):

A good data definition will describe all of the characteristics of a data object EXCEPT:

A fact is an association between two or more:

Data modeling may be the most important part of the systems development process because:

The most common types of entities are:

In an E-R diagram, there are/is________ business rule(s) for every relationship.

Business policies and rules govern all of the following EXCEPT:

A________ defines or constrains some aspect of the business.

Which of the following is NOT a characteristic of a good business rule?

Which of the following is NOT a good characteristic of a data name?

Customers, cars, and parts are examples of:

Which of the following is an entity that exists independently of other entity types?

An entity type whose existence depends on another entity type is called a________ entity.

A(n)________ is the relationship between a weak entity type and its owner.

An entity type names should be all of the following EXCEPT:

A property or characteristic of an entity type that is of interest to the organization is called a(n):

An attribute that must have a value for every entity (or relationship) instance is a(n):

A person's name, birthday, and social security number are all examples of:

An attribute of an entity that must have a value for each entity instance is a(n):

An attribute that can be broken down into smaller parts is called a(n)________ attribute.

The number of entity types that participate in a Unary relationship is:

The number of entity types that participate in a relationship is called the:

 A relationship between the instances of a single entity type is called a ________ relationship.

A simultaneous relationship among the instances of three entity types is called a ________ relationship.

 An attribute that can be calculated from related attribute values is called a ________ attribute.

The total quiz points for a student for an entire semester is a(n) ________ attribute.

Which of the following criteria should be considered when selecting an identifier?

An attribute that uniquely identifies an entity and consists of a composite attribute is called a(n):

An entity that associates the instances of one or more entity types and contains attributes specific to the relationships is called a(n):

 A ________ specifies the number of instances of one entity that can be associated with each instance of another entity.

A relationship where the minimum and maximum cardinality are both one is a(n) ________ relationship.

A requirement to begin designing physical files and databases is:

A key decision in the physical design process is:

Designing physical files requires ________ of where and when data are used in various ways.

A detailed coding scheme recognized by system software for representing organizational data is called a(n):

All of the following are objectives when selecting a data type EXCEPT:

The smallest unit of application data recognized by system software is a:

 An appropriate datatype for one wanting a fixed-length type for last name would include:

 An appropriate datatype for adding a sound clip would be:

he value a field will assume unless the user enters an explicit value for an instance of that field is called a:

A database is an organized collection of ________ related data.

 Older systems that often contain data of poor quality are called ________ systems

Program-data dependence is caused by:

Because applications are often developed independently in file processing systems:

Relational databases establish the relationships between entities by means of common fields included in a file called a(n):

kh có xóa đcnfjankfnaef

A(n)________ is often developed by identifying a form or report that a user needs on a regular basis.

A graphical system used to capture the nature and relationships among data is called a(n):

Data that describe the properties of other data are:

All of the following are properties of metadata EXCEPT:

A person, place, object, event, or concept about which the organization wishes to maintain data is called a(n):

________ are established between entities in a well-structured database so that the desired information can be retrieved.

All of the following are primary purposes of a database management system(DBMS) EXCEPT:

With the database approach, data descriptions are stored in a central location known as a:

A userview is:

Which organizational function should set database standards?

________ is a tool even non-programmers can use to access information from a database.

Which of the following is NOT an advantage of database systems?

The most common source of database failures in organizations is:

A rule that CANNOT be violated by database users is called a:

In a file processing environment, descriptions for data and the logic for accessing the data are built into:

Which of the following is NOT an objective that drove the development and evolution of database technology?

A relatively small team of people who collaborate on the same project is called a:

A workgroup database is stored on a central device called a:

Which of the following is NOT a cost and/or risk of the database approach?

The need for consensus on data definitions is an example of which type of risk in the database environment?

Which of the following is software used to create, maintain, and provide controlled access to databases?

Database development begins with ________, which establishes the range and general contents of organizational databases.

hé lô

34) The traditional methodology used to develop, maintain and replace information systems is called the:

35) The SDLC phase in which every data attribute is defined, every category of data is listed and every business relationship between data entities is defined is called the ________ phase.

36) The SDLC phase in which database processing programs are created is the ________ phase.

38) Organizing the database in computer disk storage is done in the ________ phase.

42) ________ do NOT concentrate on determining the requirements for the database component of an information system.

43) The three-schema approach includes which of the following schemas?

45) ________ is the most popular RDMS data model notation.

The property by which subtype entities possess the values of all attributes of a supertype is called:

Which of the following is a generic entity type that has a relationship with one or more subtypes?

Subtypes should be used when:

The process of defining one or more subtypes of a supertype and forming relationships is called:

The process of defining a more general entity type from a set of more specialized entity types is called:

The ________ rule specifies that an entity instance of a supertype is allowed not to belong to any subtype.

The ________ rule specifies that each entity instance of the supertype must be a member of some subtype in the relationship.

Which of the following is a completeness constraint?

A(n) ________ constraint is a type of constraint that addresses whether an instance of a supertype must also be an instance of at least one subtype.

The ________ rule specifies that an entity instance can be a member of only one subtype at a time.

A ________ addresses whether an instance of a supertype may simultaneously be a member of two or more subtypes.

An attribute of the supertype that determines the target subtype(s) is called the:

The ________ rule states that an entity instance can simultaneously be a member of two (or more) subtypes.

The subtype discriminator is a composite attribute when there is a(n):

In a supertype/subtype hierarchy, each subtype has: