The Database Development
Process
Enterprise Data Modeling
• In many organizations, database development begins with enterprise data
modeling.
• Its purpose is to create an overall picture or explanation of organizational
data.
• The first step in database development, in which the scope and general
contents of organizational databases are specified.
• In enterprise data modeling, you review current systems, analyze the nature
of the business areas to be supported.
• Describe the data needed and plan one or more database development
projects.
Systems Development Life Cycle
(SDLC)
SDLC
• The traditional methodology used to develop, maintain, and replace
information systems.
• The SDLC is a complete set of steps that a team of information
systems professionals, including database designers and
programmers, follow in an organization to specify, develop, maintain,
and replace information systems.
Systems Development Life Cycle
(SDLC) (Cont..
1- Planning
• To develop a preliminary understanding of a business situation
• And how information systems might help solve a problem or make an
opportunity possible
Enterprise modeling (Conceptual/Abstract Representation)
• Analyze current data processing
• Analyze the general business functions and their database needs
• Justify need for new data and databases in support of business
Systems Development Life Cycle
(SDLC) (Cont..
Conceptual Data modeling
• Identify scope of database requirements for proposed information system
• Analyze overall data requirements for business function(s) supported by database.
• Develop preliminary conceptual data model, including entities and relationships.
• Compare preliminary conceptual data model with enterprise data model
• Develop detailed conceptual data model, including all entities, relationships,
attributes, and business rules
• Make conceptual data model consistent with other models of information system
• Populate repository with all conceptual database specification
Systems Development Life Cycle
(SDLC) (Cont..
Analysis
• During the Analysis phase of the SDLC, the analyst produces a detailed
data model that identifies all the organizational data that must be
managed for this information system.
• Every data attribute is defined, all categories of data are listed, every
business relationship between data entities is represented, and every
rule that dictates the integrity of the data is specified.
• It is also during the Analysis phase that the conceptual data model is
checked for consistency with other types of models developed to explain
other dimensions of the target information system, such as processing
steps, rules for handling data, and the timing of events
Systems Development Life Cycle
(SDLC) (Cont..
Design
Logical database design
• Analyze in detail the transactions, forms, displays, and inquiries
(database views) required by the business functions supported by the
database
• Integrate database views into conceptual data model
• Identify data integrity and security requirements, and populate repository
View
• A view is virtual table that display data from one or more table
Systems Development Life Cycle
(SDLC) (Cont..
Design
Physical database design
• Define database to DBMS (often generated from repository)
• Decide on physical organization of data
• Design database processing programs
Systems Development Life Cycle
(SDLC) (Cont..
Implementation
• Code and test database processing programs
• Complete database documentation and training materials
• Install database and convert data from prior systems
Systems Development Life Cycle
(SDLC) (Cont..
Maintenance
• Analyze database and database applications to ensure that evolving
information requirements are met
• Tune database for improved performance
• Fix errors in database and database applications and recover database
when it is contaminated (corrupt)
