Database Design

5. 1DEFINITION OF DATABASE A selective informationbase is a sh atomic number 18d collection of interrelated data designed to equip the varied randomness needs an organization. A database has two important properties that it is interconnected that it is shared. 5. 2 IMPORTANCE OF DATABASE The data resources of organization and its management are genuinely important. The recognition by management that data or information is indeed a resource is a recent development. Information, which in essence is digest and synthesis of data, will unquestionably be one of the most full of life of corporate resources. It will be structured into models for planning and decision-making.It will integrate into product design and marketing methods. In other words information will be recognized and treated as an assets. By incorporated repute that previously distinct data files have been lucidly create to eliminate redundancy and the facilitate data access. By shared mean that all authorized user s in the organization have access to the very(prenominal) data to use for variety of other activities. 5. 3 BENEFITS OF THE DATABASE APPROACH The database attempt offers number of important advantages. 5. 3. 1Minimal Data Redundancy thither is not as much storing of multiple copies of the data as in manual system.Database Management System and DataIt is designed into the system improve surgery and the system is aware of the redundancy. 5. 3. 2Consistency of Data By eliminating or controlling redundancy in the database approach, it greatly sheer the approach, it greatly reduce the opportunities for inconsistency. When controlled redundancy is permitted in the database, the database system itself should enforce consistency by update each occurrence of data item when agitate occurs. 5. 3. 3 desegregation of Data Database data are organized into a single logical structure with logical relationship defined between associated data entities.In this panache user can easily relate one item of data to another related item. 5. 3. 4Sharing of Data A database in intended to be share by authorized users in the organization. closely database system today permits multiple users to share a database co-currently each operational department can access this data by using their induce views of that database. 5. 3. 5Enforcement of Standard Establishing the data administration function is an important part in the database approach. This organizational function has authority for defining and enforcing data standards.The database administrator will approve all data names, formats and data usage end-to-end the organization. 5. 3. 6Data Accessibility & Data Responsiveness A database system provides multiple retrieval paths to each item of data giving a much greater flexibility in locating and retrieving data to user. 5. 3. 7Reduced Program Maintenance A database system data are independent of the application programs that use them within limits. Either the data or the applic ation programs that use the data can be hanged without necessitating a change in other factor. As a result program forethought can be significantly reduced in a database environment.