DBMSs use indexes for many different purposes.
In the original Chen model, each attribute is represented using an oval with the attribute
name connected to the entity with a line.
“Linked SQL” is a term used to refer to SQL statements that are contained within an
application programming language such as COBOL, C++, ASP, Java, or ColdFusion.
The following example exhibits ____________________ integrity:
The CUSTOMER table’s primary key is CUS_CODE. The CUSTOMER primary key
column has no null entries, and all entries are unique. Similarly, the AGENT table’s
primary key is AGENT_CODE, and this primary key column also is free of null entries.
As a rule, a(n) ____________________ must unlock the object after its termination.
Only numeric data types can be added and subtracted in SQL.
Distributed processing does not require a distributed database, and a distributed
database does not require distributed processing.
The ____________________ is the result of adding more semantic constructs to the
original entity relationship (ER) model.
PRODUCT yields all possible pairs of rows from two tablesalso known as the
____________________ product.
Dependencies can be identified with the help of a dependency ____________________.
Normalization is a process that is used for changing attributes to entities.
Distributed database systems do not require complex mechanisms to manage
transactions and ensure the database’s consistency and integrity.
The COMMIT command does not permanently save all changes. In order to do that,
you must use SAVE.
The price paid for increased performance through denormalization is a larger amount of
____________________.
Many companies are already working on the development of a new breed of services
based on XML and Web technologies.
There is never a good reason to use null values in a database.
If you add a new column to a table that already has rows, the existing rows will default
to a value of ____________________ for the new column.