CIS 3050

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

Analysis

In the figure below, the primary key for "Order Line" is which type of key?

Composite

In the figure shown below, which of the following business rules would apply?

Each vendor can supply many parts to any number of warehouses, but need not supply any parts

A composite key consists of only one attribute.

False

A member of a subtype does NOT necessarily have to be a member of the supertype

False

A subtype is a generic entity that has a relationship with one or more entities at a lower level.

False

Databases were developed as the first application of computers to data processing.

False

Generalization is a top-down process.

False

Unlike columns, the rows of a relation may not be interchanged and must be stored in one sequence.

False

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

Structured query language

Data is represented in the form of:

Tables

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

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

A good data definition is always accompanied by diagrams, such as the entity-relationship diagram.

True

Data management technologies are also increasing often used as information systems, as a foundation for analytics or the systematic analysis of data to understand a real-world problem better.

True

Data names should always relate to business characteristics.

True

Data structures include data organized in the form of tables with rows and columns. true

True

Data, rather than processes, are the most complex aspects of many modern information systems.

True

The relationship between a weak entity type and its owner is an identifying relationship.

True

When choosing an identifier, choose one that will not change its value often.

True

While business rules are not redundant, a business rule can refer to another business rule.

True

In the figure below, to which of the following entities are the entities "CAR" and "TRUCK" generalized

Vehicle

Which of the following is true of packaged data models?

Which of the following is true of packaged data models?

A ________ defines or constrains some aspect of the business.

business rule

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

cardinality constraint

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

composite identifier.

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

create table

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

foreign key

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

generalization

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

integrity constraints.

Metatdata typically describes all of the following EXCEPT:

location on disk.

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

logical designs.

Business policies and rules govern all of the following EXCEPT:

managing employees.

The third step in the data modeling process with a packaged data model is:

map data to be used from package to data in current databases.

According to a McKinsey Global Institute Report, in 2010 alone, global enterprises stored more than:

more than 7 billion exabytes of data.

Unplanned duplicate data files are the rule rather than the exception in file processing systems.

True

In packaged data models, all subtype/supertype relationships follow the ________ and ________ rules.

total specialization; overlap

the e-r model is used to construct a conceptual model

true

Because applications are often developed independently in file processing systems:

unplanned duplicate data files are the rule rather than the exception.

All of the following are steps to using a packaged data model EXCEPT:

utilize all business rules that come with the packaged data model.

A value that indicates the date or time of a data value is called a:

time stamp

The entity integrity rule states that:

no primary key attribute can be null.

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

data characteristics are important in the design of programs and other systems components.

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

data integrity

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

data model.

The most important challenge of customizing a purchased data model is:

determining the business rules that will be established through the data model.

Using a packaged data model, projects take less time and cost because:

essential components and structures are already defined.

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

examples.

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

first normal form

A two-dimensional table of data sometimes is called a:

relation

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

specialization

The columns of a relation can be interchanged without changing the meaning or use of the relation.

tRUE

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

total specialization

Information is processed data.

True

An attribute (or attributes) that uniquely identifies each row in a relation is called a:

Primary Key

In the figure below, Name would be an ideal identifier.

SID is the identfier

In an E-R diagram, strong entities are represented by double-walled rectangles.

False

A modern database management system automates more of the backup and recovery tasks than a file system.

True

A primary key is an attribute that uniquely identifies each row in a relation.

True

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

Internal

A database is an organized collection of ________ related data.

Logically

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

Relationships

The intent of a business rule is to break down business structure.

False

Specialization is the reverse of generalization.

True

The disjoint rule specifies that if an entity instance of the supertype is a member of one subtype, it MUST simultaneously be a member of another subtype.

False

A single occurrence of an entity type is called an entity instance.

True

An entity instance of a subtype represents the same entity instance of the supertype.

True

File processing systems have been replaced by database systems in most critical business applications today.

True

Metadata are data that describe the properties of other data.

True

One of the major challenges in data modeling is to recognize and clearly represent entities that are almost the same.

True

Organizations that utilize the file processing approach spend only 20 percent of development time on maintenance.

True

Supertype/subtype relationships should not be used when the instances of a subtype participate in no relationships which are unique to that subtype.

True

The E-R model is used to construct a conceptual model.

True