第六章 数据设计.ppt

Chapter 6 Data Design Phase Description Phase Description Systems Design is the third of five phases in the systems development life cycle (SDLC) Now you are ready to begin the physical design of the system that will meet the specifications described in the system requirements document Systems design tasks include data design, user interface design, and system architecture Chapter Contents Chapter Objectives Explain data design concepts and data structures Describe file processing systems and various types of files Understand database systems and define the components of a database management system (DBMS) Describe Web-based data design and characteristics Chapter Objectives Explain data design terminology, including entities, fields, common fields, records, files, tables, and key fields Describe data relationships, draw an entity-relationship diagram, define cardinality and use cardinality notation Explain the concept of normalization Understand the steps in database design Chapter Objectives Describe hierarchical, network, relational, and object-oriented database models Explain data warehousing/data mining Differentiate between logical and physical storage and records Explain data control measures Introduction You will develop a physical plan for data organization, storage, and retrieval Begins with a review of data design concepts and terminology, then discusses file-based systems and database systems, including Web-based databases Concludes with a discussion of data mining, data warehousing, physical design issues, logical and physical records, data storage formats, and data controls Data Design Concepts Before constructing an information system, a systems analyst must understand basic design concepts, including data structures and the characteristics of file-oriented and database systems, including Web-based database design Data Design Concepts Data Structures A file or table contains data about people, places or events that interact with the system File-ori