Module 6 Data Warehousing

One of the first steps in the creation of a relational database is toa. integrate accounting and nonfinancial data.b. plan for increased secondary storage capacity.c. order data-mining software that will facilitate data retrieval.d. create a data model of the key entities in the system.e. construct the physical user view using SQL.

Weat

The most common type of database model is the __________ database. Multiple Choice hierarchical star schema relational network

Which one of the following is not correct in relation to database?Select one:a. Helps in creating a business power point presentationsb. A database is usually controlled by a database management system (DBMS)c. A structured set of data held in a computer, especially one that is accessible in various ways.d. Most databases use structured query language (SQL) for writing and querying data.

The database model most likely to be used in the development of a modern (not legacy) system is a. hierarchical b. structured c. relational d. network e. navigational

Examine the diagram below and determine what essential mechanism is missing. Once you have identified the missing element, discuss its importance

A Data Flow Diagram (DFD) is composed of which of the following elements?Select one:a. Data Flowsb. All of the abovec. Transformation Processesd. Data sources and destinations

In the context of databases, what does ACID stand for? A. Automatic, Consistent, Integrated, Durable B. Atomicity, Consistency, Isolation, Durability C. Array, Class, Interface, Data D. Add, Change, Insert, Delete

Explain how the E-R diagrams is used to prepare database tables. Also, include explanation of cardinalities.