Database Planning, Design,
and Administration
Transparencies
© Pearson Education Limited 1995, 2005
, Main components of an information system.
Main stages of database system
development lifecycle.
Main phases of database design:
conceptual, logical, and physical design.
Benefits of CASE tools.
2
© Pearson Education Limited 1995, 2005
2
, How to evaluate and select a DBMS.
Distinction between data administration and
database administration.
Purpose and tasks associated with data
administration and database administration.
2
© Pearson Education Limited 1995, 2005
3
, Last few decades have seen proliferation
of software applications, many requiring
constant maintenance involving:
◦ correcting faults,
◦ implementing new user requirements,
◦ modifying software to run on new or upgraded
platforms.
Effort spent on maintenance began to absorb
resources at an alarming rate.
© Pearson Education Limited 1995, 2005
4
and Administration
Transparencies
© Pearson Education Limited 1995, 2005
, Main components of an information system.
Main stages of database system
development lifecycle.
Main phases of database design:
conceptual, logical, and physical design.
Benefits of CASE tools.
2
© Pearson Education Limited 1995, 2005
2
, How to evaluate and select a DBMS.
Distinction between data administration and
database administration.
Purpose and tasks associated with data
administration and database administration.
2
© Pearson Education Limited 1995, 2005
3
, Last few decades have seen proliferation
of software applications, many requiring
constant maintenance involving:
◦ correcting faults,
◦ implementing new user requirements,
◦ modifying software to run on new or upgraded
platforms.
Effort spent on maintenance began to absorb
resources at an alarming rate.
© Pearson Education Limited 1995, 2005
4
