Case Study

Textbook used:

http://kenchannon.files.wordpress.com/2011/10/essentials-of-systems-analysis-and-design-5th-ed.pdf

Reading

Chapter 7: Structuring System Requirements: Conceptual Data

Problems and Exercises

Chapter 7, Problems/Exercises, Questions 5, 16, and 17. The dropbox for this assignment is "Week 4: Problems and Exercises".

Submit your assignment (in a single MS Word document) to the Dropbox located on the silver tab at the top of this page. For instructions on how to use the Dropbox, read these Step-by-Step Instructions or watch this Dropbox Tutorial.

See Syllabus, Due Dates for Assignments & Exams, for due date information.

Course Project

Systems Analysis SDLC Phase 2 Package

* Petrie's Electronics Case

* Petrie's Electronics Case, Chapter 7, Questions 1–5 and 7.

| |

Objectives | |

Petrie's Electronics needs to improve its marketing and customer retention by increasing customer loyalty. The marketing department is in need of a Customer Relationship Management (CRM) system. Upper management has selected No Customer Escapes as the top Information Technology project this year.

1. In Week 4, we finish the second phase of the system development life cycle (SDLC), System Analysis. We have gathered detailed requirements for the CRM project and created Data Flow Diagrams (DFD) for our process modeling. Now we need to conceptually model our CRM system by reviewing Entity Relationship Diagrams (ERD) which will help next week in designing data bases in the third phase of the SDLC, System Design.

2. In order to finalize detailed requirements, we will need to structure the data collected. DFDs help model how data moves throughout our system; ERDs help us understand how data is related and structured. To aid our understand of ERDs, we need to understand the following.

a. What entities are

b. What attributes are

c. Degrees of Relationships

d. Cardinality Relationships

3. Once we have created the ERDs for our customer...