W3: Cumulative Project Assignment

Project Plan: Data

Data Types

1. Create at least 3 tables to illustrate the kinds of data your company will deal with. They can be related or separate types, internal or external. Consider your headings and which might work as primary keys – remember primary keys must be unique. Highlight or bold the primary key for each table. See Chapter 5, Section 1b for examples.

Data Flow

2. Create a diagram illustrating data flow (see Chapter 5 figures for examples). It doesn’t need to be complex at this point, just a breakdown of the system or systems you’ll be using to handle data. Where does external data enter the system? Where does it go and who will have access? Is internal data like employee information directed to one department or person? Why? Where will data be stored – on a local server, the cloud, or something else?

PII

3. Lastly, address how you will handle PII (Personally Identifiable information). In what ways can you ensure only those who need access to such information can retrieve and view it?