Exam 9: Data Design

Three main types of relationships can exist between entities: a one-to-one relationship,abbreviated 1:1;a one-to-many relationship,abbreviated 1:M;and a many-to-many relationship,abbreviated M:N.

A table design that contains a repeating group is called _____.

Eamon plans to operate three warehouses,in different cities,to support his business.To find the exact location of a product,he wants to establish a code that identifies a product's warehouse location,floor number,section number,aisle number,and bin number.By doing this,he can ship the ordered products faster.Which of the following codes would you suggest that Eamon use?

Any field that is not a primary key or a candidate key is called a _____.

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

College course numbers usually are assigned using a block sequence code.

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

-In the accompanying figure,any field that serves as a primary key is called a _____.

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 that Eamon use?

A table is in _____ if it is in first normal form and if all fields that are not part of the primary key are functionally dependent on the entire primary key.

A(n)_____ is a graphical model of an information system that depicts the logical relationships and interaction among system entities.

_____ is strictly hardware related because it involves the process of reading and writing binary data to physical media,such as a hard drive,CD/DVD,or network-based storage device.

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

During the systems design phase,_____ are used to organize,access,and maintain data structures.

Common fields can be used to link entities in various types of relationships.

Encryption is the process of creating table designs by assigning specific fields or attributes to each table in the database.

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

A subschema is a view of the database used by one or more systems or users.

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

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