{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Chapter 07 IM - Systems Analysis and Design Sixth Edition...

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

View Full Document Right Arrow Icon
Systems Analysis and Design, Sixth Edition Page 1 of 22 Systems Analysis and Design Sixth Edition Instructor’s Manual CHAPTER SEVEN Data Design LESSON PLAN OBJECTIVES When students finish this chapter, they will be able to: 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 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 Explain the importance of codes and describe various coding schemes Describe relational and object-oriented database models Explain data warehousing and data mining Differentiate between logical and physical storage and records Explain data control measures INSTRUCTOR NOTES Introduction, 302 LECTURE NOTES This is the second of three chapters in the systems design phase of the SDLC. Note the focus of this chapter. Recall the items created in the systems analysis phase, and list the concepts introduced in Chapter 6. Present the Chapter Introduction Case: Mountain View College Bookstore on page 303. This introduction case sets up the material developed in the chapter. Review the background, participants, project status, and discussion topics for the case. Discuss Figure 7-1. CLASSROOM ACTIVITIES Consider assigning students to each role in the Chapter Introduction Case: Mountain View College Bookstore on page 303 and having them enact the case dialogue.
Background image of page 1

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

View Full Document Right Arrow Icon
Page 2 of 22 Chapter 7, Data Design Data design concepts, 304 LECTURE NOTES List basic design concepts that must be understood before constructing an information system. Data structures, 304 LECTURE NOTES Define data structure and file or table . Use Figures 7-2 and 7-3 to explain how a file-oriented system is different from a database system . Define file processing system . In a file-oriented system, each department or area within an organization has its own set of files. On the other hand, a database is a centrally managed and controlled collection of data that can be accessed, retrieved, and used by multiple departments. Point out that although file processing systems still exist, most of today’s information systems are designed as databases. Overview of file processing, 305 LECTURE NOTES Explain how file processing still is used. The following is true of processing systems: They are efficient, because they do not require the additional processor time and memory space needed by preprogrammed database functions They are simple to create, especially when a data file is accessed by only one application They can be tailored tightly to specific application or business needs Discuss Figure 7-4. Describe three problems in a file processing environment: data redundancy , data integrity problems, and
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}