Exam 9: Data Design

Systems that interact with a DBMS are relatively independent of how the physical data is maintained.

List and discuss at least five specific database management system (DBMS)advantages.

_____ enables Java applications to exchange data with any database that uses SQL statements and is compliant with its standard.

_____ use a keyword to encode a number.

_____ combine data from different item attributes,or characteristics,to build a code.

_____,a coding method that uses one byte per character,is used on mainframe computers and high-capacity servers.

One type of validity check,called _____,is a set of rules that avoids data inconsistency and quality problems.

A repeating group is a set of one or more fields that can occur only once in a single record,with each occurrence having the same value.

A 3NF design avoids redundancy and data integrity problems that still can exist in 2NF designs.

_____ describes the numeric relationship between two entities and shows how instances of one entity relate to instances of another entity.

Mainframe storage refers to data that a user can view,understand,and access,regardless of how or where that information actually is organized or stored.

Explain why large firms use data warehouses.

The basic elements of logical storage are alphabetic or numeric characters,such as the letter A or the number 9.

To resolve potential database connectivity and access problems,companies use ODBC-compliant software that enables communication among various systems and DBMSs.

Explain the importance and process of system file backup.

_____ are numbers or letters assigned in a specific order.

The complete definition of a database,including descriptions of all fields,tables,and relationships,is called a _____.

A(n)_____ is a collection of tools,features,and interfaces that enables users to add,update,manage,access,and analyze data.

Web-based systems are popular because they offer ease of access,cost-effectiveness,and worldwide connectivity.

Migrating a traditional database design to the web can require design modification,additional software,and some added expense.