Database Design The activity of specifying the schema of a database in a given data model
Data Modeling and Database Design
Database Design The activity of specifying the
schema of a database in a given data model
Database Schema The structure of a database
that
Captures data types, relationships and
constraints in data
Is independent of any application program
Changes infrequently
Data Model
A set of primitives for defining the structure
of a database.
A set of operations for specifying retrieval
and updates on a database
Examples Relational, Hierarchical, Networked,
Object-Oriented
In this course, we focus on the Relational data
model.
Database Instance or State The actual data
contained in a database at a given time.
The Database Development Process
Two overall approaches
Top-Down Design systems from an overall
organization perspective
Bottom-Up Design systems from a specific
perspective - one system at a time.
The following is a very brief outline
describing the database development process.
User needs assessment and requirements
gathering Determine what the user’s are looking for, what functions should be
supported, how the system should behave.
Data Modeling Based on user requirements, form
a logical model of the system. This logical model is then converted to a
physical data model (tables, columns, relationships, etc.) that will be
implemented.
Implementation Based on the data model, a
database can be created. Applications are then written to perform the required
functions.
Testing The system is tested using real data.
Deployment The system is deployed to users.
Maintenance of the system begins.