Scribd
Upload
3 views8 pages

Modeling Approaches for Databases

The document discusses three approaches to modeling: top-down, bottom-up, and targeted modeling. It focuses on top-down modeling which involves building a model from scratch. Bottom-up modifies an existing database. Targeted maintains existing models by adapting to new requirements.

Uploaded by

Jadee Buenaflor
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
3 views8 pages

Modeling Approaches for Databases

The document discusses three approaches to modeling: top-down, bottom-up, and targeted modeling. It focuses on top-down modeling which involves building a model from scratch. Bottom-up modifies an existing database. Targeted maintains existing models by adapting to new requirements.

Uploaded by

Jadee Buenaflor
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Modeling Approaches

Week 2
Objectives:
1. Identify which models must be developed
2. Identify which modeling approach to use
Approaches to Modeling
There are three approaches to modeling: top-
down, bottom-up, and targeted. All three approaches
meet a different need, so you may be involved in
projects that use different approaches. In this course,
you focus most on top-down modeling, which involves
building a model from scratch and following it through
to completion.
Top – Down Modeling
used for designing a new database. It gathers
information about business requirements, and proceeds
to define processes, a logical model of the data, one or
more relational models, and one or more physical
models for each relational model. The steps and
information requirements can range from simple to
elaborate, depending on your needs.
Bottom – Up Modeling
modifies an existing database definition. It builds a
database design based on either metadata extracted
from an existing database or a file with DDL code that
implements an existing database. The resulting
database is represented as a relational model and a
physical model, and you reverse engineer the logical
model from the relational model.
Targeted Modeling
maintains the existing models by adapting to new
requirements. Depending on the requirement, you must
determine which model to modify. If the new requirement is to
add or modify a new business requirement, you typically
modify the logical data model and then forward engineer the
change to the relational model to synchronize the models. If the
new requirement is to add or modify an existing database
definition, you typically modify the relational model and
reverse engineer to synchronize with the logical data model.
Case Study 2:
Modeling Approach
Questions???

You might also like