Database Design

Abstract

Database design is a scheme in which database goals are defined and database alternatives are laid out, analyzed, and an alternative is selected or recommended. It implies that goals are identified and set, and a structured decision making process: 1)identify goals of database, 2)identify issues or problems in the way of goal achievement, 3)identify alternatives to resolve issues, 4)select or recommend an alternative, 5)test the alternative, 6)act or implement. The design provides the comprehensive mental framework and organization of the database. It allows the database to be viewed in its entirety and evaluate how the various aspects of the database need to interact. It allows for the early identification of major issues, potential problems, and design alternatives.