Database System Development Lifecycle

ICT502

What is an Information System (IS)?

Resources that enable the collection, management, control, and dissemination of information throughout an organization.

What is database planning?

Management activities that allow the stages of the database system development lifecycle to be realized efficiently and effectively.

What is database design?

Process of creating a design for a database that will satisfy the enterprise’s requirements and missions.

What is database methodology?

A structured approach that uses procedures, techniques, tools, and documentation aids to support and facilitate the process of design.

List at least five critical success factors in database design.

1. Work interactively with users

2. Incorporate structural/integrity considerations

3. Use a Database Design Language (DBDL)

4. Follow a structured methodology

5. Build a data dictionary

6. Use diagrams

7. Be willing to repeat steps

What are the three main phases of database design?

1. Conceptual Database Design

2. Logical Database Design

3. Physical Database Design

What is Conceptual Database Design?

Constructing a model of data used in an enterprise, independent of physical considerations.

What is Logical Database Design?

Constructing a model based on a specific data model (e.g., relational), independent of a particular DBMS and physical considerations.

Objective of Conceptual DB design?

To build a conceptual data model of the data requirements of the enterprise.

✗ Model comprises

✗ entity types

✗ relationship types

✗ attributes and attribute domains

✗ primary and alternate keys

✗ integrity constraints.

Objective of Physical DB design?

1. To translate the conceptual data model into a logical data model

2. Then to validate this model to check that it is structurally correct using normalization supports the required transactions.

What is Physical Database Design?

Producing a description of database implementation on secondary storage, including file organizations, indexes, and security.

Steps in Physical Database Design?

Step 3 Translate logical data model

Step 4 Design file organizations and index

Step 5 Design user views

Step 6 Design security mechanism

List the nine steps in conceptual database design.

1. Identify entity types

2. Identify relationship types

3. Identify and associate attributes

4. Determine attribute domains

5. Determine candidate, primary, alternate keys

6. Consider enhanced modeling concepts (optional)

7. Check for redundancy

8. Validate against user transactions

9. Review with user

List the seven steps in logical database design.

1. Derive relations for logical data model

2. Validate relations using normalization

3. Validate relations against user transactions

4. Check integrity constraints

5. Review with user

6. Merge logical models into global model (optional)

7. Check for future growth