Exam 9: Data Design

Like a primary key, a foreign key must be unique.

A primary key is composed of exactly two fields.

Matching ​Identify the letters of the choices that best match the phrases or definitions. -A field in one table that must match a primary key value in another table in order to establish the relationship between the two tables

Briefly describe the seven coding methods used by companies with examples.

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

Typically, a database management system is managed by a person called _____, who assesses overall requirements and maintains the database for the benefit of an entire organization rather than a single department or user.

A(n) _____ allows a user to specify a task without specifying how the task will be accomplished.

Matching ​Identify the letters of the choices that best match the phrases or definitions. -Defines only those portions of the database that a particular system or user needs or is allowed to access

Eamon wants to provide a discount to premium buyers who order in large quantities. He wants to create a code for each price and share it with them. Also, he wants to ensure that only the premium buyers can decipher the code shared. In this scenario, which of the following codes would you suggest Eamon to use?

Web-based designs are dependent on a specific combination of hardware and software.

A _____ is a set of letters or numbers that represents a data item.

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

A web-based data design requires users to have powerful workstations.

The three normal forms constitute a progression in which the second normal form represents the best design.

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

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

Some abbreviation codes are called _____ codes because they use a specific combination of letters that are easy to remember.

-In the accompanying figure, a _____ is a field or combination of fields that uniquely and minimally identifies a particular member of an entity.

With a _____, users provide an example of the data requested.

A _____ specifies the fields and identifies the primary key in a particular file.