Purpose
Process of creating a design for a database that will support the enterprise’s mission statement and mission objectives for the required database system
Activities
- Acquire hardware and software
- Develop the details of the new or modified information system
1) Acquire hardware and software
- Identify technical specifications
- Request Vendor proposal
- Test and evaluate vendor proposals
- Make a decision
2) Develop the details of the new or modified information system
A) Conceptual Database Design
- It involved design rules and technique which explain the whole system simple and easily
- So, it reduces the time spent and energy needed for coding, debugging and maintenance
- Conceptual data model is source of information for logical design phase
B) Logical Design
- A process of developing information that going to be applied by organization based on a data model
- Conceptual data model is refined and mapped on to a logical data model
Three main activities
- Production of conceptual data model for all users
- Production of logical data model for every user
- Production of global logical data model
C)Physical Design
- Process of producing a description of the database implementation on secondary storage
Activities
- Determination hardware specifications for database server and peripheral devices
- Determination software specification for operating system (Linux) and special software (e.g. Java)
- Design user interface and data captures devices such as keyboard and mouse
- Report format such as summary report
Application Design
- Design of user interface and application programs that use and process the database.
- Includes two important activities:
1) Transaction
Design
- An action, or series of actions, carried out by a single user or
application program, which accesses or changes content of the database.
- Three main types of transactions: retrieval, update, and mixed
2) User Interface Design
- By
prototyping, it is used to identify features of a system that work well, or are
inadequate and clarify the users’ requirements
Software Design
Design
|
Explanation
|
1) Architectural design
|
Identify the overall structure of the system,
the principal components (sometimes called sub-systems or modules), their
relationships and how they are distributed.
|
2) Abstract Specification
|
An abstract specification of its services and
the constraints under which it must operate
|
3) Interface design
|
Define the interface between system
components
|
4) Component design
|
Take each system component and design how it
will operate
|
5) Data structure design
|
Design the system data structures and how
these are to be represented in a database or structure
|
6) Algorithm design
|
Design or formulate a formula in design
|
6
basic software models
-
Waterfall Model
- V-shaped
Model
- Iterative Model
- Spiral
Model
- Big
Bang Model
-
Agile Model
For more details: https://www.roberthalf.com.au/blog/employers/6-basic-sdlc-methodologies-which-one-best
If you have any comments, please leave them below!
Don't forget to follow me and share! Thank you!
No comments:
Post a Comment
欢迎留言你的意见与看法！
If got any questions, please leave your comments below