Essentials Of Database Management PDF

CHAPTER 1: THE DATABASE ENVIRONMENT AND DEVELOPMENT PROCESS Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014 Pearson Education, Inc. 1 OBJECTIVES Chapter 1 Copyright © 2014 Pearson Education, In...

CHAPTER 1: THE DATABASE ENVIRONMENT AND DEVELOPMENT PROCESS Essentials of Database Management Jeffrey A. Hoffer, Heikki Topi, V. Ramesh Copyright © 2014 Pearson Education, Inc. 1 OBJECTIVES Chapter 1 Copyright © 2014 Pearson Education, Inc. 2 DEFINITIONS Chapter 1 Copyright © 2014 Pearson Education, Inc. 3  Figure 1-1a Data in context Context helps users understand data Chapter 1 Copyright © 2014 Pearson Education, Inc. 4  Figure 1-1b Summarized data Chapter 1 Copyright © 2014 Pearson Education, Inc. 5 Chapter 1 Copyright © 2014 Pearson Education, Inc. 6 Chapter 1 Copyright © 2014 Pearson Education, Inc. 7 Chapter 1 Copyright © 2014 Pearson Education, Inc. 8  Duplicate Data 9 Chapter 1 Copyright © 2014 Pearson Education, Inc. 9 Chapter 1 Copyright © 2014 Pearson Education, Inc. 10 Chapter 1 Copyright © 2014 Pearson Education, Inc. 11  Order Filing System Invoicing Central database DBMS System Contains employee, order, inventory, pricing, and Payroll customer data System Chapter 1 Copyright © 2014 Pearson Education, Inc. 12 Chapter 1 Copyright © 2014 Pearson Education, Inc. 13 Chapter 1 Copyright © 2014 Pearson Education, Inc. 14 Chapter 1 Copyright © 2014 Pearson Education, Inc. 15 Chapter 1 Copyright © 2014 Pearson Education, Inc. 16  One customer may place many orders, but each order is placed by a single customer  One-to-many relationship Chapter 1 Copyright © 2014 Pearson Education, Inc. 17  One order has many order lines; each order line is associated with a single order  One-to-many relationship Chapter 1 Copyright © 2014 Pearson Education, Inc. 18  One product can be in many order lines, each order line refers to a single product  One-to-many relationship Chapter 1 Copyright © 2014 Pearson Education, Inc. 19  Therefore, one order involves many products and one product is involved in many orders  Many-to-many relationship Chapter 1 Copyright © 2014 Pearson Education, Inc. 20 Chapter 1 Copyright © 2014 Pearson Education, Inc. 21  Figure 1-5 Components of the Database Environment Chapter 1 Copyright © 2014 Pearson Education, Inc. 22 Chapter 1 Copyright © 2014 Pearson Education, Inc. 23 Chapter 1 Copyright © 2014 Pearson Education, Inc. 24  FIGURE 1-6 Example business function-to-data entity matrix Chapter 1 Copyright © 2014 Pearson Education, Inc. 25 Chapter 1 Copyright © 2014 Pearson Education, Inc. 26  Planning Analysis Logical Design Physical Design Implementation Maintenance Chapter 1 Copyright © 2014 Pearson Education, Inc. 27  SYSTEMS DEVELOPMENT LIFE CYCLE (SEE ALSO FIGURE 1-7) (CONT.) Purpose–preliminary understanding Planning Planning Deliverable–request for study Analysis Logical Design Physical Design Database activity– Implementation enterprise modeling and early conceptual Maintenance data modeling Chapter 1 Copyright © 2014 Pearson Education, Inc. 28  SYSTEMS DEVELOPMENT LIFE CYCLE (SEE ALSO FIGURE 1-7) (CONT.) Purpose–thorough requirements Planning analysis and structuring Analysis Analysis Deliverable–functional system specifications Logical Design Physical Design Database activity–thorough Implementation and integrated conceptual data modeling Maintenance Chapter 1 Copyright © 2014 Pearson Education, Inc. 29  SYSTEMS DEVELOPMENT LIFE CYCLE (SEE ALSO FIGURE 1-7) (CONT.) Purpose–information requirements Planning elicitation and structure Analysis Deliverable–detailed design specifications Logical Design Logical Design Physical Design Database activity– Implementation logical database design (transactions, forms, Maintenance displays, views, data integrity and security) Chapter 1 Copyright © 2014 Pearson Education, Inc. 30  SYSTEMS DEVELOPMENT LIFE CYCLE (SEE ALSO FIGURE 1-7) (CONT.) Purpose–develop technology and Planning organizational specifications Analysis Deliverable–program/data structures, technology purchases, organization redesigns Logical Design Physical Design Physical Design Database activity– Implementation physical database design (define database to DBMS, physical Maintenance data organization, database processing programs) Chapter 1 Copyright © 2014 Pearson Education, Inc. 31  SYSTEMS DEVELOPMENT LIFE CYCLE (SEE ALSO FIGURE 1-7) (CONT.) Purpose–programming, testing, Planning training, installation, documenting Analysis Deliverable–operational programs, documentation, training materials Logical Design Physical Design Database activity– database implementation, Implementation Implementation including coded programs, documentation, Maintenance installation and conversion Chapter 1 Copyright © 2014 Pearson Education, Inc. 32  SYSTEMS DEVELOPMENT LIFE CYCLE (SEE ALSO FIGURE 1-7) (CONT.) Planning Purpose–monitor, repair, enhance Deliverable–periodic audits Analysis Logical Design Physical Design Database activity– database maintenance, Implementation performance analysis and tuning, error Maintenance Maintenance corrections Chapter 1 Copyright © 2014 Pearson Education, Inc. 33  Prototyping Database Methodology (Figure 1-8) Chapter 1 Copyright © 2014 Pearson Education, Inc. 34 34  Prototyping Database Methodology (Figure 1-8) (cont.) Chapter 1 Copyright © 2014 Pearson Education, Inc. 35  Prototyping Database Methodology (Figure 1-8) (cont.) Chapter 1 Copyright © 2014 Pearson Education, Inc. 36 Prototyping Database Methodology (Figure 1-8) (cont.) 37  Prototyping Database Methodology (Figure 1-8) (cont.) Chapter 1 Copyright © 2014 Pearson Education, Inc. 38 Chapter 1 Copyright © 2014 Pearson Education, Inc. 39 Chapter 1 Copyright © 2014 Pearson Education, Inc. 40 Chapter 1 Copyright © 2014 Pearson Education, Inc. 41  Figure 1-10a Evolution of database technologies Chapter 1 Copyright © 2014 Pearson Education, Inc. 42  Figure 1-10b Database architectures Chapter 1 Copyright © 2014 Pearson Education, Inc. 43  Figure 1-10b Database architectures (cont.) Chapter 1 Copyright © 2014 Pearson Education, Inc. 44  Figure 1-10b Database architectures (cont.) Chapter 1 Copyright © 2014 Pearson Education, Inc. 45 Chapter 1 Copyright © 2014 Pearson Education, Inc. 46  Figure 1-11 Two-tier database with local area network Chapter 1 Copyright © 2014 Pearson Education, Inc. 47  Figure 1-12 Three-tiered client/server database architecture Chapter 1 Copyright © 2014 Pearson Education, Inc. 48 Chapter 1 Copyright © 2014 Pearson Education, Inc. 49  FIGURE 1-13 Computer System for Pine Valley Furniture Company Chapter 1 Copyright © 2014 Pearson Education, Inc. 50