Transcript 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-6a
© 2000 Prentice Hall
Forms in Access 2000
Page 34
Figure 2-6b
© 2000 Prentice Hall
Forms in Access 2000
Page 34
Figure 2-6c
© 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