Exam 14: Database Design

Data mining is the term used to describe the use query tools and decision support tools that are used to generate reports and analyses off of data warehouses.

SQL is a language that supports complete database creation, maintenance and usage, and is the DDL and DML of most relational databases.

Which of the following is an acceptable technique for implementing supertype/subtype entities?

The physical, relational database implementation of the data model is known as the ________________ .

____________________ integrity for a database means that every table should have a primary key (which may be concatenated) but is controlled such that no two records in the table have the same primary key value.

A(n) __________________________________ error exists when a foreign key value in one table has no matching primary key value in the related table.

Vertical distribution of the data means that each table or entire rows in a table would be assigned to different database servers and locations.

What is a blocking factor?

Once a database design and its corresponding schema have been completed, a prototype database can usually be generated very quickly.

One or more ____________________________________ are responsible for the database technology,database design and construction consultation, security, backup and recovery, and performance tuning.

A good data model is simple.

A collection of fields arranged in a predefined format is called a:

A(n) _______________________________________ is responsible for the data planning, definition, architecture, and management.

Conventional files are relatively difficult to design and implement because they are normally designed for use with multiple applications or information systems.

_______________________ tools are frequently capable of generating SQL code for the database from a CASE-based database schema

Most database technologies impose a fixed-length record structure, meaning that each record instance has the same fields, same number of fields and same logical size.

___________ restrict the portion of the database that may be used or accessed by different users and programs.

Files and tables that contain stored copies of historical data for easy retrieval and review without the overhead of regeneration are known as:

A database schema is the physical model or blueprint for a database. It represents the technical implementation of the logical data model.

Document files and tables contain stored copies of historical data for easy retrieval and review without the overhead of regenerating the document.