DBA manages and administers an effective data warehouse - Research Paper

The Modeling Evaluation (100 points)

 The DBA Role will examine data warehouse administration and database connectivity.

o This will be much like the example on page 669 in the text. Be sure to include as

much detail as needed.

 A Process-to-Entity Matrix will be created using Excel or Word to evaluate the design

project.

o Once entities have been identified they are cross-referenced with the data stores from the DFD. This serves as a check to see that all data is being held, used and not duplicated.

o The entity/function matrix is used to cross-reference the entities with the functions identified in the data flow modelling. As part of this check an entity/function matrix is drawn. Each entity is listed along with all the functions. All entities should have a process that creates, deletes and uses it.

o The following example would be for a typical sales processing system.

Entity Process

Customer Order Product For each entity…

D=Delete

Place order

R C M R=Read

Process order cancellation

R D M M=Modify

Get stock delivery

M C=Create

Add new customer

C

For each process…

 Deliverables

o Network diagram detailing the database connectivity between the server and

users.

o Process-to-Entity Matrix