Database Processing Chapter 2 Introduction to Database Development

Database Processing Chapter 2 Introduction to Database Development David M. Kroenke © 2000 Prentice Hall

Database Components Page 26 Figure 2 -1 © 2000 Prentice Hall

Chapter 2 Types of Data • • User data Metadata Indexes Application Metadata Page 25 © 2000 Prentice Hall

Chapter 2 User Data • • A table of data called a relation Columns are fields or attributes Rows are entities Relations must be structured properly Page 26 © 2000 Prentice Hall

Chapter 2 Metadata “A description of the structure of the database” • System tables store metadata – – Page 27 number of tables and table names number of fields and field names primary key fields field names, data types, and length © 2000 Prentice Hall

Chapter 2 Indexes • Improve performance • Improve accessibility • (Overhead data) Page 28 © 2000 Prentice Hall

Chapter 2 Application Metadata • Stores the structure and format of – – Page 29 forms reports queries other application components © 2000 Prentice Hall

Chapter 2 The DBMS • Design Tools Subsystem • Run-Time Subsystem • DBMS Engine Page 29 © 2000 Prentice Hall

Chapter 2 The Design Tools Subsystem • Tools to design and develop – – tables forms queries reports • Programming Languages – macros – languages Page 29 © 2000 Prentice Hall

Chapter 12 Run-Time Subsystem • Processes database components created by design tools Page 30 © 2000 Prentice Hall

Chapter 2 DBMS Engine • Intermediary between the design tools and run-time subsystems and the data • Also handles. . . – transaction management – locking – backup and recovery Page 30 © 2000 Prentice Hall

Chapter 2 Database Schema • Defines a database’s structure – – Page 30 tables - subjects within the database relationships - one-to-many or 1: N domains - set of values a column may have business rules - restrictions on data values © 2000 Prentice Hall

Table Design in Access 2000 Page 32 Figure 2 -4 © 2000 Prentice Hall

Relationships in Access 2000 Page 32 Figure 2 -5 © 2000 Prentice Hall

Chapter 2 Components of Applications • • • Forms Queries Reports Menus Application Programs Page 34 © 2000 Prentice Hall

Forms in Access 2000 Page 34 Figure 2 -6 a © 2000 Prentice Hall

Forms in Access 2000 Page 34 Figure 2 -6 b © 2000 Prentice Hall

Forms in Access 2000 Page 34 Figure 2 -6 c © 2000 Prentice Hall

Queries in Access 2000 Page 34 Figure 2 -8

Reports in Access 2000 Page 34 Figure 2 -10

Menus in Access 2000 Page 34 Figure 2 -12

Visual Basic in Access 2000 Page 34 Figure 2 -14

Chapter 2 Database Development Process Terminology • Prototype - sample database • Top-down development - general to specific (global perspective) • Bottom-up development - specific to general (faster, less risky) Page 41 © 2000 Prentice Hall

Chapter 2 Data Modeling • • • Interviewing users documenting requirements building a data model building a database prototype a process of inference (working backwards) Page 42 © 2000 Prentice Hall

Chapter 2 Data Models • Entity-Relationship Model • Semantic Object Model Page 44 © 2000 Prentice Hall