A(n) ____ might be written by a programmer or it might be created through a DBMS utility program.

Application program




You are watching: A(n) ____ might be written by a programmer or it might be created through a dbms utility program.

____ is a set of tools that work together to provide an advanced data analysis environment for retrieving, processing, and modeling data from the data warehouse.

Online analytical processing


The organization of the data within the folders in a manual file system was determined by ____.

its expected use


The phrase ____ refers to an organization of components that define and regulate the collection, storage, management and use of data within a database environment.

database system


____ relates to the activities that make the database perform more efficiently in terms of storage and access speed.

performance tuning


A verb associating two nouns in a business rule translates to a(n) ____ in the data model.

relationship


In the ____ model, each parent can have many children, but each child has only one parent.

hierarchical


In the ____ model, the user perceives the database as a collection of records in 1:M relationships, where each record can have more than one parent.

network


A(n) ____ enables a database administrator to define schema components.

data definition language (DDL)


A(n) ____ model represents a global view of the database as viewed by the entire organization.

conceptual


The relational model's creator, E. F. Codd, used the term relation as a synonym for ____.

table


In the relational model, ____ are important because they are used to ensure that each row in a table is uniquely identifiable.

keys


In the context of a database table, the statement "A ____ B" indicates that if you know the value of attribute A, you can look up the value of attribute B.

determines


The attribute B is ____ the attribute A if each value in column A determines one and only one value in column B.

functionally dependent on


A ____ key can be described as a superkey without unnecessary attributes, that is, a minimal superkey.

candidate


A CUSTOMER table's primary key is CUS_CODE. The CUSTOMER primary key column has no null entries, and all entries are unique. This is an example of ____ integrity.

entity


To be considered minimally relational, the DBMS must support the key relational operators ____, PROJECT, and JOIN.

SELECT


____, also known as RESTRICT, yields values for all rows found in a table that satisfy a given condition.

SELECT


In an outer join, the matched pairs would be retained and any unmatched values in the other table would be left ____.

null


A ____ contains at least all of the attribute names and characteristics for each table in the system.

data dictionary


The ____ is actually a system-created database whose tables store the user/designer-created database characteristics and contents.

system catalog




See more: How To Prove That A Factor Group Of A Cyclic Group Is Cyclic So Is G/H Proof

In a database context, the word ____ indicates the use of the same attribute name to label different attributes.

homonym


In a database context, a(n) ____ indicates the use of different names to describe the same attribute.

synonym