Database Design

5. 1 description OF DATABASE A entropybase is a shargond collection of interrelated info intentional to meet the varied education needs an organization. A database has two eventful properties that it is integrated that it is shared out. 5. 2 IMPORTANCE OF DATABASE The data resources of organization and its management are very historic. The recognition by management that data or information is indeed a resource is a recent development. Information, which in center is analysis and synthesis of data, ordain unquestionably be one of the just about vital 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 speech information will be recognized and treated as an assets. By integrated mean that previously distinct data files have been logically organized to eliminate redundancy and the facilitate data rise to power. By shared mean that all authorized users in the organiza tion have access to the same data to use for variety of other activities. 5. 3 BENEFITS OF THE DATABASE progression The database approach offers number of important advantages. 5. 3. 1Minimal Data tautology There is not as much storing of multiple copies of the data as in manual administration.Database Management System and DataIt is designed into the system reform performance and the system is aware of the redundancy. 5. 3. 2Consistency of Data By eliminating or controlling redundancy in the database approach, it greatly reduce 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 updating apiece occurrence of data peak when change occurs. 5. 3. 3Integration of Data Database data are organized into a superstar logical structure with logical relationship defined between associated data entities.In this way 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. Most database system today permits multiple users to share a database co-currently each functional department can access this data by use their own views of that database. 5. 3. 5Enforcement of Standard Establishing the data administration function is an important role 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 habitude throughout 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 post 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. any the data or the application programs that use the data can be hanged without necessitating a change in other factor. As a pass on program maintenance can be significantly reduced in a database environment.