Exam 2 Sample: Eric Smith, 90/90

  1. Fixed Data Flow Diagram

2a. None of the data sets is in third normal form, though C is almost close.

2b. Variation A. In the Inventory entity, there are no key fields. Searching on a database would be impossible. Without a unique identifier for the entities, every single piece of information would have to be provided to use data, and if you already know all the data, why would you need an Information System?

  1. A and B-specs.

Objective 1: Support for a uniform safety training program.

A-Specs:

B-Specs:

Objective 2: Planning for new facilities to meet material safety data requirements

A-Specs

B-Specs