02database_development_process

02database_development_process - Database Management...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: Database Management Database Development Process Douglas Shook 1/20/05 Data Management Fall 2004 Introduction to the Database Development Process Data Management Fall 2004 Purpose of Chapter Provides and overview of the entire process of database development Most topics revisited later in depth dont worry if not clear at this point Focus on the Planning Phase material it will not be covered again (Table 2-1) Planning Phase products (EDM Figs. 2-1, 2-12, & page 78) and planning matrices will be used in later steps Data Management Fall 2004 Figure 2-1 Segment from enterprise data model (Pine Valley Furniture Company CUSTOMER ORDER PRODUCT ORDER LINE Places Is placed by Contains Is contained in Has Is for Data Management Fall 2004 SDLC Cascade or waterfall approach (Fig. 2-4)- Standard approach for large system Database development activities during SDLC (Fig. 2-5) 1) Identification and Selection - Obtain Project 2) Planning - EDM & Planning Matrices 3) Analysis - Conceptual Data Model (CDM) 4) Logical Design - Third Normal Form (3NF) 5) Physical Design - Process vs. Entity, CRUD, TAF, Volume, etc. 6) Implementation - SQL DDLs 7) Maintenance - Database Administration Data Management Fall 2004 Database development activities during the systems development life cycle (SDLC) Project Identification and Selection Project Initiation and Planning Analysis Logical Design Physical Design Implementation Maintenance Data Management Fall 2004 Main Parts of a Database User Data Relations- Tuples- Attributes Metadata System tables Indexes Application metadata Data Management Fall 2004 Creating a Database Tables/Relations Relationships- one-to-one- one-to-many- many-to-many Domains Business Rules Data Management Fall 2004 Database Development Process Three-Schema Brush the dog both ways...
View Full Document

Page1 / 28

02database_development_process - Database Management...

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

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