Exam 11: Data Storage Design

FoodTitan is a large grocery store chain in the Chicago,Milwaukee,and the Upper Midwest.Generally their stores have from 18 to 36 checkout lanes with scanners.When somebody scans a bar code,the system is probably using a _____ to process the purchased items.

Which of the following is a concept not generally associated with decision support systems?

An 'international key' is used to relate two tables together (like customer ID from the customer table is an international key in the order table).

The most efficient tables (in terms of storage efficiency)in relational database management systems:

A DSS is a design support structure and does the 'ETL' (extract,transform and load)to create data warehouses.

Marco is working for iTunes and needs to have a database that can store complex data.His best choice might be:

Omar is creating an order database for a multiple site car dealership.The data will be fairly simple: names,addresses,city,state,zip code,make of car,model,style,color,etc.Probably the best choice for him would be a _____________ database.

Maria is working for the Minneapolis Dance Troop (MDT)and wants a database that can support text,numbers,video,and audio.She will probably select the multidimensional database format.

One goal is data storage design is to spread the data over all storage devices so that the redundancy will make for more efficient storage.

This type of file stores 'core information that is important to the business' and for the application (such as customer mailing lists).

Barb is working on a database design.For the most efficient storage she should remove: ______ and ______.

The purpose of creating physical ERDs is to:

In a registration database,Ross has tables for student,professor,classroom,class,class-hour.Since his campus has about 12,000 students,when he runs queries about what student is in what class,taught by what professor in what classroom at which hour,the DBMS software will have to perform many _________

Decision support systems are not designed to find individual records,but to find aggregated information (such as 'what three products sold the best in Boston in February').

The acronym for the standard language used to access data in relational databases is:

A CRUD matrix shows exactly how data are used and created by major processes in the system.

In most cases,decision support systems are best at:

New databases collectively referred to as NoSQL databases have appeared in recent years.Which of the following are categorized as a NoSQL database?

This type of file is used to update a master file:

Legacy databases might include ________ and ______________