Please enable JavaScript.
Coggle requires JavaScript to display documents.
DATABASE SYSTEM DEVELOPMENT LIFECYCLE - Coggle Diagram
DATABASE SYSTEM DEVELOPMENT LIFECYCLE
11 STAGE OF DATABASE SYSTEM DEVELOPMENT LIFECYCLE
1) DATABASE PLANNING
i) allow stage of database system lifecycle to be realized as efficiently :
2) SYSTEM DEFINITION
i) Describe the scope and boundaries of the database system and major user view
3) Requirements Collection and Analysis
i)Process of collection and analyzing information
ii) using this information to identify user requirement of new system
4) DATABASE DESIGN
i) process of creating a design for database :
DESIGN METHODOLOGY
i) Structured approach that uses procedures, techniques ,tools and documentation aids to support the process of design.
5) DBMS SELECTION
i) Selection of an appropriate DBMS to support the database system
Main step to selecting a DBMS
1) Define term of reference of study
2)shortlist two or three product
3) evaluate product
4) recommend selection and produce report :
6) APPLICATION DESIGN
i) Design of user interface and application program that use and process the database
ii) are design parallel activities
7) PROTOTYPING
I) Building working model of a database system
1 more item...
CONCEPTUAL DATABASE DESIGN
i) Process of constructing a model of the data used in an
enterprise, independent of all physical considerations
BUILD CONCEPTUAL DATA
1.1 IDENTIFY ENTITY TYPE
•To identify the required entity types
•Document entity types
1.2 IDENTIFY RELATIONSHIP TYPE
To identify the important relationship between the netity type
use erd
determine the multiplicity constraint of relatioship type.
check for fan and chasm traps
1.3 Identify and associate attributes with entity or relationship types
To associate attributes with the appropriate entity and document the details of eachattribute
-Simple/composite attributes
-Single/multi valued attributes
-Derived attributes
-Identify potential problems
1.4 Determine
attribute domains
Determine domain for the attribute in the data model
-document attribute domains
1.5 Determine candidate ,primary , and alternate key attribute
identify the candidate key(s) for each entity
document primary and alternate keys.
1.6 Consider use of enhance modeling concepts (optional step)
-consider the use of enchanced modelling concept ,such as specialization /generalization, aggregation, and composition
1.7 Check model
for redundancy
check for the presence of any redundancy in the model and to remove any that does exist
consider time dimension
1 more item...
OBJ:To build a conceptual data model of the data requirements
of the enterprise
LOGICAL DATABASE DESIGN (STEP 2)
The process of constructing the model of the database used in an enterprise based on a specificdata model
BUILD AND VALIDATE LOGICAL DATA MODEL
Step 2.1 Derive relations for logical data model
To create relations for the logical data model to represent the entities, relationships, and attributes that have been identified
Step 2.2 Validate relations using normalization
To validate the relations in the logical data model using normalization
Step 2.3 Validate relations against user transactions
To ensure that the relations in the logical data model support the required transactions
Step 2.4 Check integrity constraints
To check integrity constraints are represented in the logical data model.
Step 2.5 Review logical data model with user
To review the logical data model with the users to ensure that they consider the model to be a true representation
Step 2.6 Merge logical data models into global Model
(optional step)
To merge logical data models into a single global logical data model that represents all user views
3 more items...
PHYSICAL DATABASE DESIGN (STEP 3-6)
Step 3.1 Design base relations
Step 3.2 Design representation of derived data
To decide how to represent any derived data present in logical data model in target DBMS.
Step 3.3 Design general constraints
To design the general constraints for target DBMS
Design File Organizations and Indexes (STEP4)
determine optimal file organizations to store the base relations and the indexes that are required to achieve acceptable performance
Step 4.1 Analyze transactions
understand the functionality of the transactions that will run on the database and to analyze the important transactions.
1 more item...
need to define:
the name of the relation;
a list of simple attributes in brackets;
the PK and, where appropriate, AKs and FKs.
referential integrity constraints for any FKs identified.