chapter 1 - CGS 2545: Database Concepts Spring 2012 Chapter...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
CGS 2545: Database Concepts (Chapter 1) Page 1 © Dr. Mark Llewellyn CGS 2545: Database Concepts Spring 2012 Chapter 1 – The Database Development Process Department of Electrical Engineering and Computer Science Computer Science Division University of Central Florida Instructor : Dr. Mark Llewellyn markl@cs.ucf.edu HEC 236, 407-823-2790 http://www.cs.ucf.edu/courses/cgs2545/spr2012
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
CGS 2545: Database Concepts (Chapter 1) Page 2 © Dr. Mark Llewellyn Enterprise Data Model • First step in database development • Specifies scope and general content • Overall picture of organizational data at high level of abstraction • Entity-relationship diagram • Descriptions of entity types • Relationships between entities • Business rules
Background image of page 2
CGS 2545: Database Concepts (Chapter 1) Page 3 © Dr. Mark Llewellyn Segment from enterprise data model (Pine Valley Furniture Company) [simplified E-R diagram] Enterprise data model describes the high-level entities in an organization and the relationship between these entities
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
CGS 2545: Database Concepts (Chapter 1) Page 4 © Dr. Mark Llewellyn Information Systems Architecture (ISA) • Conceptual blueprint for organization’s desired information systems structure • Consists of: – Data (e.g. Enterprise Data Model – simplified ER Diagram) – Processes – data flow diagrams, process decomposition, etc. – Data Network – topology diagram – People – people management using project management tools (Gantt charts, etc.) – Events and points in time (when processes are performed) – Reasons for events and rules (e.g. decision tables)
Background image of page 4
CGS 2545: Database Concepts (Chapter 1) Page 5 © Dr. Mark Llewellyn Information Engineering • A data-oriented methodology to create and maintain information systems • Top-down planning: a generic IS planning methodology for obtaining a broad understanding of the IS needed by the entire organization • Four steps to Top-Down planning: Planning Analysis Design Implementation
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
CGS 2545: Database Concepts (Chapter 1) Page 6 © Dr. Mark Llewellyn Information Systems Planning Purpose: align information technology with organization’s business strategies Three steps: 1. Identify strategic planning factors a. Goals b. Critical success factors c. Problem areas 2. Identify corporate planning objects a. Organizational units b. Locations c. Business functions d. Entity types 3. Develop enterprise model a. Functional decomposition b. Entity-relationship diagram c. Planning matrices
Background image of page 6
CGS 2545: Database Concepts (Chapter 1) Page 7 © Dr. Mark Llewellyn Identify Strategic Planning Factors
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/15/2012 for the course CGS 2545 taught by Professor Markllewellyn during the Spring '10 term at University of Central Florida.

Page1 / 27

chapter 1 - CGS 2545: Database Concepts Spring 2012 Chapter...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online